On 30 October 2012 05:27, Tom Lane wrote:
> edw...@clericare.com writes:
>> The following two queries differ only by adding "LIMIT 1", but the one with
>> the limit gets radically worse performance. I've done VACUUM FULL, VACUUM
>> ANALYZE, and REINDEX DATABASE and there are no modifications since
edw...@clericare.com writes:
> The following two queries differ only by adding "LIMIT 1", but the one with
> the limit gets radically worse performance. I've done VACUUM FULL, VACUUM
> ANALYZE, and REINDEX DATABASE and there are no modifications since.
> EXPLAIN ANALYZE SELECT * FROM commits WHERE
The following bug has been logged on the website:
Bug reference: 7627
Logged by: Edward Faulkner
Email address: edw...@clericare.com
PostgreSQL version: 9.2.1
Operating system: OSX 10.8.2
Description:
The following two queries differ only by adding "LIMIT 1", but the
