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 20081121194805.GI5210@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:

> Will value of 30 allow other clients to work when VACUUM FULL is running ?

1. vacuum_cost_delay does not affect vacuum full
2. vacuum full is always blocking, regardless of settings

So I gather you're not doing any vacuuming, eh?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-performance by date:

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