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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
