"Bradford L. Barrett" wrote:
>
> Greetings all..
>
> Quick question, hopefully someone can answer for me... We have been
> running PostgreSQL for over a year now, using php3 to interface our
> web site to the db.. current main db size consists of roughly 3 million
> line items (electronic components) split across 10 tables. When we
> do our nightly delete/vacuum/insert, the Elapsed times given for the
> vacuum seem to have no bearing to reality... could anyone explain,
> first, what the numbers actually represent, and secondly, where are
> they obtained? Using "Elapsed xxx/yyy", what does 'xxx' and 'yyy'
> mean? Yes, the longer the vacuum takes, the greater the numbers are,
> but they don't seem to reflect reality...
getrusage() is used. xxx - sec in system mode, yyy - in user.
BTW, upgrade to 6.5.X - vacuum is now (much) faster in some cases.
Vadim
