--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
> IIRC, vacuum fsyncs once per table (possibly more
> depending on whether
> you add FULL, ANALYZE, etc). Not clear what case
> you are considering
> exactly.
>
Vacuum and Vacuum full. The script I attached to a
previous post to demonstrate the behavior (at least on
this workstation) creates and populates a single table
via a stored procedure, updates approximately half the
rows and then executes a vacuum followed by a vacuum
full.
The insert and update commands execute far faster
(showing 5-10 megs of disk transfer per second on
average) than both the vacuum and vacuum full (showing
512k to 1meg of transfer per second).
Regards,
Shelby Cain
__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail