Обсуждение: Query Planner Optimization?

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?