Re: Query Join Performance

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Aaron Bono <postgresql(at)aranya(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Richard Huxton <dev(at)archonet(dot)com>, PostgreSQL SQL List <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Query Join Performance
Date: 2007-04-26 03:07:16
Message-ID: 20070426030716.GD10666@alvh.no-ip.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Aaron Bono wrote:

> Looks like a vacuum analyze did the trick. Performance is beautiful now. I
> should have tried that earlier.
>
> I thought I had the auto vacuum turned on (PostgreSQL 8.1) but I guess it
> doesn't do analyze?
>
> Anyway, I will schedule a vacuum analyze nightly - it is low usage and won't
> cause any problems.

It should have done an analyze at some point. Unless this is Windows,
in which case there's a bug that precludes autovacuum from running at
all.

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Nemo Terry 2007-04-26 04:11:02 Re: Which function transform x,y to latitude/longitude?
Previous Message Aaron Bono 2007-04-26 00:57:04 Re: Query Join Performance