Postgres Pro
Downloads
Home   >   mailing lists

Query Planner Optimization? - Mailing list pgsql-performance

From Brandon
Subject Query Planner Optimization?
Date
Msg-id CAO9bLMYe5bBeFDYUpLhYp66gfeMcpr6zLQ9+YhOQu2xim3u9xA@mail.gmail.com
Whole thread Raw
List pgsql-performance
Tree view 
I've run into a query planner issue while querying my data with a
large offset (100,000). My schema is
http://pgsql.privatepaste.com/ce7cc05a66 . I have about 220,000 rows
in audit_spoke.audits. The original query
http://pgsql.privatepaste.com/61cbdd51c2 ( explain:
http://explain.depesz.com/s/84d ) takes quite a bit longer this query
http://pgsql.privatepaste.com/45ad8c7135 ( explain:
http://explain.depesz.com/s/KmT ). Is this just an edge case for the
query planner or am I doing something wrong in the first query?

pgsql-performance by date:

Previous
From: Jon Leighton
Date:
Subject: Cost of opening and closing an empty transaction
Next
From: "mal.oracledba"
Date:
Subject: Newbie performance problem - semop taking most of time ?