Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk?

From:	Bryce Nesbitt <bryce2(at)obviously(dot)com>
To:	pgsql-performance(at)postgresql(dot)org
Subject:	Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk?
Date:	2010-02-10 08:29:53
Message-ID:	4B726E81.2060904@obviously.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2010-02-10 04:04:18 from Bryce Nesbitt <bryce2(at)obviously(dot)com>  2010-02-10 08:29:53 from Bryce Nesbitt <bryce2(at)obviously(dot)com>   2010-02-10 09:11:51 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>   2010-02-10 20:31:58 from Robert Haas <robertmhaas(at)gmail(dot)com>    2010-02-10 23:18:36 from "Jorge Montero" <jorge_montero(at)homedecorators(dot)com>    2010-02-11 01:52:28 from Bryce Nesbitt <bryce2(at)obviously(dot)com> 📎     2010-02-11 03:52:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>      2010-02-13 07:55:07 from Bryce Nesbitt <bryce2(at)obviously(dot)com>      2010-02-13 08:09:26 from Bryce Nesbitt <bryce2(at)obviously(dot)com> 📎     2010-02-11 13:29:52 from Robert Haas <robertmhaas(at)gmail(dot)com>  2010-02-12 15:09:41 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>   2010-02-12 16:05:45 from Karl Denninger <karl(at)denninger(dot)net> 📎    2010-02-12 16:11:00 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>     2010-02-12 16:43:10 from Karl Denninger <karl(at)denninger(dot)net> 📎      2010-02-12 16:54:27 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>      2010-02-12 20:07:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>       2010-02-13 07:58:12 from Bryce Nesbitt <bryce2(at)obviously(dot)com> 📎        2010-02-13 15:40:09 from Pierre Frédéric Caillaud <lists(at)peufeu(dot)com>        2010-02-15 16:41:43 from Robert Haas <robertmhaas(at)gmail(dot)com>   2010-02-13 07:45:23 from Bryce Nesbitt <bryce2(at)obviously(dot)com> 📎
Lists:	pgsql-performance

In response to

• 512, 600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? at 2010-02-10 04:04:18 from Bryce Nesbitt

Responses

• Re: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? at 2010-02-10 09:11:51 from Pavel Stehule
• Re: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? at 2010-02-10 20:31:58 from Robert Haas

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Pavel Stehule	2010-02-10 09:11:51	Re: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk?
Previous Message	Scott Marlowe	2010-02-10 07:11:30	Re: Linux I/O tuning: CFQ vs. deadline