[BUGS] BUG #5230: Limit operator slows down

2009-12-03 Thread aftab
The following bug has been logged online: Bug reference: 5230 Logged by: aftab Email address: akha...@hotmail.co.uk PostgreSQL version: 8.3.8 Operating system: Centos 5 Description:Limit operator slows down Details: S1=SELECT * FROM position WHERE

Re: [BUGS] BUG #5230: Limit operator slows down

2009-12-03 Thread Robert Haas
On Thu, Dec 3, 2009 at 7:07 AM, aftab akha...@hotmail.co.uk wrote: The following bug has been logged online: Bug reference:      5230 Logged by:          aftab Email address:      akha...@hotmail.co.uk PostgreSQL version: 8.3.8 Operating system:   Centos 5 Description:        Limit

Re: [BUGS] BUG #5230: Limit operator slows down

2009-12-03 Thread Robert Haas
On Thu, Dec 3, 2009 at 10:45 AM, aftab khan akha...@hotmail.co.uk wrote: This is not exactly the same what I posted yesterday, What I have posted today also include EXPLAIN ANALYZE OUTPUT . [ adding the list back to the CC line ] It looks like you have a problem very similar to one Laurence