| From: | Brandon <cdsboy(at)gmail(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Query Planner Optimization? |
| Date: | 2012-09-21 17:08:28 |
| Message-ID: | CAO9bLMYe5bBeFDYUpLhYp66gfeMcpr6zLQ9+YhOQu2xim3u9xA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Claudio Freire | 2012-09-22 02:43:49 | Re: PostgreSQL performance on 64 bit as compared to 32 bit |
| Previous Message | Jon Leighton | 2012-09-21 10:46:58 | Cost of opening and closing an empty transaction |