Re: slow query

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Anj Adu <fotographs(at)gmail(dot)com>
Cc: tv(at)fuzzy(dot)cz, pgsql-performance(at)postgresql(dot)org
Subject: Re: slow query
Date: 2010-06-05 09:38:02
Message-ID: AANLkTimOIYuXbEylsRbF2rMjcz58pp3RgTdJCtSAJ-t4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Jun 4, 2010 at 12:21 PM, Anj Adu <fotographs(at)gmail(dot)com> wrote:
> The behaviour is different in postgres 8.1.9 (much faster)  (the table
> has 9 million rows instead of 25 million..but the query comes back
> very fast (8 seconds)..
>
> Wonder if this is very specific to 8.4.0

You should really be running 8.4.4.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Anj Adu 2010-06-05 14:02:37 Re: slow query
Previous Message hubert depesz lubaczewski 2010-06-05 09:02:31 Re: slow query