Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow query postgres 8.3 - Mailing list pgsql-performance

From tv@fuzzy.cz
Subject Re: Slow query postgres 8.3
Date
Msg-id 50d8f2eb94b393c11221c9d5232d7326.squirrel@sq.gransy.com
Whole thread Raw
In response to Slow query postgres 8.3  ("Anne Rosset" <arosset@collab.net>)
Responses Re: Slow query postgres 8.3
List pgsql-performance
Tree view 
> Hi,
>
> I am trying to tune a query that is taking too much time on a large
> dataset (postgres 8.3).
>

Hi, run ANALYZE on the tables used in the query - the stats are very off,
so the db chooses a really bad execution plan.

Tomas

pgsql-performance by date:

Previous
From: "Anne Rosset"
Date:
Subject: Slow query postgres 8.3
Next
From: Tomas Vondra
Date:
Subject: Re: Why it is using/not using index scan?