Skip site navigation (1) Skip section navigation (2)

Re: Postgresql 8.0 beta 1 - strange cpu usage statistics and slow vacuuming

From: Shelby Cain <alyandon(at)yahoo(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>,pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: Postgresql 8.0 beta 1 - strange cpu usage statistics and slow vacuuming
Date: 2004-08-24 18:00:00
Message-ID: 20040824180000.2456.qmail@web41602.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers-win32
--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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 

In response to

pgsql-hackers-win32 by date

Next:From: Magnus HaganderDate: 2004-08-24 18:16:33
Subject: Re: REPOST: InitDB Failure on install
Previous:From: Magnus HaganderDate: 2004-08-24 17:43:54
Subject: Re: REPOST: InitDB Failure on install

pgsql-general by date

Next:From: Tom LaneDate: 2004-08-24 18:07:37
Subject: Re: Invalid input for integer on VIEW
Previous:From: mikeDate: 2004-08-24 17:42:52
Subject: Re: Invalid input for integer on VIEW

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group