Re: Order by (for 15 rows) adds 30 seconds to query time

From: Jean-Michel Pouré <jmpoure(at)free(dot)fr>
To: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Order by (for 15 rows) adds 30 seconds to query time
Date: 2009-12-01 20:06:05
Message-ID: 1259697965.14418.6.camel@acer
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Le mardi 01 décembre 2009 à 18:52 +0000, Richard Neill a écrit :
> Is this normal? Have I hit a bug?

PostgreSQL query analyzer needs to run a couple of times before it can
rewrite and optimize the query. Make sure demand_id, id and join IDs
carry indexes.

Run EXPLAIN ANALYSE your_query to understand how the parser works and
post it back here.

Kind regards,
Jean-Michel

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2009-12-01 20:06:06 Re: Order by (for 15 rows) adds 30 seconds to query time
Previous Message Richard Neill 2009-12-01 18:52:13 Order by (for 15 rows) adds 30 seconds to query time