On May 29, 2007, at 12:03 PM, Joost Kraaijeveld wrote:
vacuum_cost_delay = 200
vacuum_cost_page_hit = 6
#vacuum_cost_page_miss = 10 # 0-1 credits
#vacuum_cost_page_dirty = 20# 0-1 credits
vacuum_cost_limit = 100
I didn't see anyone else mention this, so...
Joost Kraaijeveld wrote:
On Tue, 2007-05-29 at 21:43 +0100, Dave Page wrote:
Cliff, Jason or Rob era? Could be important...
Cliff and Jason.
Rob is in my Ozzy collection ;-)
And rightly so imho.
:-)
/D
---(end of broadcast)---
TIP 7: You
On Tue, May 29, 2007 at 07:56:07PM +0200, Joost Kraaijeveld wrote:
Thanks, I tried it and it worked. I did not know that changing this
setting would result in such a performance drop ( I just followed an
It's not a performance drop. It's an on-purpose delay of the
functionality, introduced so
Hi
I am currently running a vacuum analyse through PgAdmin on a PostgreSQL
8.1.9 database that takes forever without doing anything: no
(noticeable) disk activity or (noticeable) CPU activity.
The mesage tab in PgAdmin says:
...
Detail: 0 index pages have been deleted, 0 are currently
Could this be because of my Cost-Based Vacuum Delay settings ?
Yeah. It is supposed to slow down VACUUM so it doesn't kill your server,
but it is not aware of the load. It will also slow it down if there is no
load. That is its purpose after all ;)
If you want fast vacuum,
On Tue, 2007-05-29 at 19:16 +0200, PFC wrote:
Could this be because of my Cost-Based Vacuum Delay settings ?
Yeah. It is supposed to slow down VACUUM so it doesn't kill your
server,
but it is not aware of the load. It will also slow it down if there is no
load. That is its
Joost Kraaijeveld wrote:
Hi
I am currently running a vacuum analyse through PgAdmin on a PostgreSQL
8.1.9 database that takes forever without doing anything: no
(noticeable) disk activity or (noticeable) CPU activity.
The mesage tab in PgAdmin says:
...
Detail: 0 index pages have
Dave Page wrote:
and lots of entries looking just like this ( 0 % CPU, 500 secs).
There are no other connections to the database and the machine does not
do anything else than me typing this e-mail and playing Metallica MP3's.
Cliff, Jason or Rob era? Could be important...
Well Metallica
On Tue, 2007-05-29 at 21:43 +0100, Dave Page wrote:
Cliff, Jason or Rob era? Could be important...
Cliff and Jason.
Rob is in my Ozzy collection ;-)
--
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
web: www.askesis.nl