Re: Hash join on int takes 8..114 seconds

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>
Cc: "Richard Huxton" <dev(at)archonet(dot)com>, "PFC" <lists(at)peufeu(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Hash join on int takes 8..114 seconds
Date: 2008-11-21 20:08:45
Message-ID: 049C2591982D4B2A81E45043922A9656@andrusnotebook
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Alvaro,

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

So only way is to disable other database acces if vacuum full is required.

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

Log files for every day are full of garbage messages below.
So I hope that vacuum is running well, isn't it ?

Andrus.

2008-11-19 00:00:48 EET 11728 1 LOG: autovacuum: processing database
"postgres"
2008-11-19 00:01:48 EET 11729 1 LOG: autovacuum: processing database
"mydb1"
2008-11-19 00:02:48 EET 11730 1 LOG: autovacuum: processing database
"emydb1"
2008-11-19 00:03:48 EET 11731 1 LOG: autovacuum: processing database
"template1"
2008-11-19 00:04:48 EET 11732 1 LOG: autovacuum: processing database
"testmydb1"
2008-11-19 00:05:48 EET 11733 1 LOG: autovacuum: processing database
"mydb3"
2008-11-19 00:06:48 EET 11734 1 LOG: autovacuum: processing database
"postgres"
2008-11-19 00:07:48 EET 11735 1 LOG: autovacuum: processing database
"mydb1"
2008-11-19 00:08:48 EET 11736 1 LOG: autovacuum: processing database
"emydb1"
2008-11-19 00:09:48 EET 11737 1 LOG: autovacuum: processing database
"template1"
2008-11-19 00:10:48 EET 11750 1 LOG: autovacuum: processing database
"testmydb1"
2008-11-19 00:11:48 EET 11751 1 LOG: autovacuum: processing database
"mydb3"
2008-11-19 00:12:48 EET 11752 1 LOG: autovacuum: processing database
"postgres"
2008-11-19 00:13:48 EET 11753 1 LOG: autovacuum: processing database
"mydb1"
2008-11-19 00:14:48 EET 11754 1 LOG: autovacuum: processing database
"emydb1"
2008-11-19 00:15:48 EET 11755 1 LOG: autovacuum: processing database
"template1"
2008-11-19 00:16:48 EET 11756 1 LOG: autovacuum: processing database
"testmydb1"
2008-11-19 00:17:48 EET 11757 1 LOG: autovacuum: processing database
"mydb3"
...

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Alvaro Herrera 2008-11-21 20:20:36 Re: Hash join on int takes 8..114 seconds
Previous Message Tom Lane 2008-11-21 20:07:02 Re: Hash join on int takes 8..114 seconds