Re: Slow query postgres 8.3

From: tv(at)fuzzy(dot)cz
To: "Anne Rosset" <arosset(at)collab(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow query postgres 8.3
Date: 2011-04-09 10:35:54
Message-ID: 50d8f2eb94b393c11221c9d5232d7326.squirrel@sq.gransy.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tomas Vondra 2011-04-09 14:59:38 Re: Why it is using/not using index scan?
Previous Message Anne Rosset 2011-04-09 01:29:42 Slow query postgres 8.3