Postgres Pro
Downloads
Home   >   mailing lists

Re: Order by (for 15 rows) adds 30 seconds to query time - Mailing list pgsql-performance

From Jean-Michel Pouré
Subject Re: Order by (for 15 rows) adds 30 seconds to query time
Date
Msg-id 1259697965.14418.6.camel@acer
Whole thread Raw
In response to Order by (for 15 rows) adds 30 seconds to query time  (Richard Neill <rn214@cam.ac.uk>)
Responses Re: Order by (for 15 rows) adds 30 seconds to query time
Re: Order by (for 15 rows) adds 30 seconds to query time
List pgsql-performance
Tree view 
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
Attachment

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Order by (for 15 rows) adds 30 seconds to query time
Next
From: Richard Neill
Date:
Subject: Re: Order by (for 15 rows) adds 30 seconds to query time