[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    [PERFORM] Query Planner Optimization?
From:       Brandon <cdsboy () gmail ! com>
Date:       2012-09-21 17:08:28
Message-ID: CAO9bLMYe5bBeFDYUpLhYp66gfeMcpr6zLQ9+YhOQu2xim3u9xA () mail ! gmail ! com
[Download RAW message or body]

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?


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
[prev in list] [next in list] [prev in thread] [next in thread]