Postgres Pro
Downloads
Home   >   mailing lists

Re: Hash join on int takes 8..114 seconds - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: Hash join on int takes 8..114 seconds
Date
Msg-id 20081121191646.GH5210@alvh.no-ip.org
Whole thread Raw
In response to Re: Hash join on int takes 8..114 seconds  ("Andrus" <kobruleht2@hot.ee>)
Responses Re: Hash join on int takes 8..114 seconds  ("Andrus" <kobruleht2@hot.ee>)
List pgsql-performance
Tree view 
Andrus wrote:

> I discovered vacuum_cost_delay=2000 option. Will this remove blocking
> issue and allow vacuum full to work ?

No.

Are you really using vacuum_cost_delay=2000?  If so, therein lies your
problem.  That's a silly value to use for that variable.  Useful values
are in the 20-40 range probably, or maybe 10-100 being extremely
generous.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-performance by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: Hash join on int takes 8..114 seconds
Next
From: "Andrus"
Date:
Subject: Re: Hash join on int takes 8..114 seconds