From: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
---|---|
To: | aftab <akhangd(at)hotmail(dot)co(dot)uk> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #5226: Limit operator slows down |
Date: | 2009-12-02 16:42:38 |
Message-ID: | 4B1698FE.9050305@postnewspapers.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On 2/12/2009 10:35 PM, aftab wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5226
> Logged by: aftab
> Email address: akhangd(at)hotmail(dot)co(dot)uk
> PostgreSQL version: 8.3.8
> Operating system: Centos 5
> Description: Limit operator slows down
> Details:
>
> S1="SELECT *
> FROM position WHERE
> position.POSITION_STATE_ID=2 AND
> position.TARGET_ID=18
> ORDER BY position.ID DESC
> ";
> S2="SELECT *
> FROM position WHERE
> position.POSITION_STATE_ID=2 AND
> position.TARGET_ID=18
> ORDER BY position.ID DESC
> LIMIT 1
> ";
>
> S1 takes 0.16ms compared to S2 which takes 5 secs. Both S1 and S2 are same
> except "LIMIT 1 " is added to S2.
Please read this:
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
then re-post your question to the pgsql-general mailing list, including
appropriate EXPLAIN ANALYZE output for both queries, etc.
--
Craig Ringer
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2009-12-02 16:46:56 | Re: BUG #5225: create table: cast necessary for constant?? |
Previous Message | Tom Lane | 2009-12-02 16:35:01 | Re: BUG #5225: create table: cast necessary for constant?? |