Home > mailing lists

Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? - Mailing list pgsql-performance

From	Bryce Nesbitt
Subject	Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk?
Date	February 10, 2010 07:49:31
Msg-id	4B726E81.2060904@obviously.com Whole thread Raw
In response to	512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? (Bryce Nesbitt <bryce2@obviously.com>)
Responses	Re: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Re: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk?
List	pgsql-performance

Tree view

Or, if you want to actually read that query plan, try:
http://explain.depesz.com/s/qYq

pgsql-performance by date:

From: Scott Marlowe
Date: 10 February 2010, 06:11:45
Subject: Re: Linux I/O tuning: CFQ vs. deadline

From: Pavel Stehule
Date: 10 February 2010, 08:12:05
Subject: Re: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk?

Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? - Mailing list pgsql-performance

Previous

Next