pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Aaron Bono <postgresql@aranya.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Richard Huxton <dev@archonet.com>
Cc: PostgreSQL SQL List <pgsql-sql@postgresql.org>
Subject: Re: Query Join Performance
Date: Wed, 25 Apr 2007 23:07:16 -0400
Message-ID: <20070426030716.GD10666@alvh.no-ip.org> (raw)
In-Reply-To: <bf05e51c0704251757o311dd849n2c6a52e1c68b933e@mail.gmail.com>
References: <bf05e51c0704241826u3e6652d1m26973b837e0b1397@mail.gmail.com>
	<462F9714.8090802@archonet.com>
	<bf05e51c0704251339u2883211eh4cdedcbec63c2be9@mail.gmail.com>
	<6573.1177539802@sss.pgh.pa.us>
	<bf05e51c0704251757o311dd849n2c6a52e1c68b933e@mail.gmail.com>

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.



view thread (6+ messages)

Message-ID: <20070426030716.GD10666@alvh.no-ip.org>
Permalink:  ../20070426030716.GD10666@alvh.no-ip.org/
Also on:    postgresql.org/message-id/20070426030716.GD10666@alvh.no-ip.org

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: alvherre@commandprompt.com, postgresql@aranya.com, tgl@sss.pgh.pa.us, dev@archonet.com
  Subject: Re: Query Join Performance
  In-Reply-To: <20070426030716.GD10666@alvh.no-ip.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox