select on 1milion register = 6s

From:	"Bruno Rodrigues Siqueira" <bruno(at)ravnus(dot)com>
To:	<pgsql-performance(at)postgresql(dot)org>
Subject:	select on 1milion register = 6s
Date:	2007-07-28 19:27:14
Message-ID:	000c01c7d14d$4df223f0$e900a8c0@brunolaptop
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2007-07-28 19:27:14 from "Bruno Rodrigues Siqueira" <bruno(at)ravnus(dot)com>  2007-07-28 19:56:58 from Hervé Piedvache <bill(dot)footcow(at)gmail(dot)com>   2007-07-28 22:40:48 from "Bruno Rodrigues Siqueira" <bruno(at)ravnus(dot)com>   2007-07-28 23:07:18 from "Bruno Rodrigues Siqueira" <bruno(at)ravnus(dot)com>  2007-07-28 19:59:26 from Craig James <craig_james(at)emolecules(dot)com>   2007-07-28 20:12:10 from "Bruno Rodrigues Siqueira" <bruno(at)ravnus(dot)com>    2007-07-28 22:36:16 from Ragnar <gnari(at)hive(dot)is>     2007-07-28 22:38:54 from "Bruno Rodrigues Siqueira" <bruno(at)ravnus(dot)com>     2007-07-29 16:35:37 from Decibel! <decibel(at)decibel(dot)org>      2007-07-29 16:44:23 from "Bruno Rodrigues Siqueira" <bruno(at)ravnus(dot)com>       2007-07-30 01:29:26 from Decibel! <decibel(at)decibel(dot)org>        2007-07-30 06:52:41 from Decibel! <decibel(at)decibel(dot)org>    2007-07-29 04:51:41 from "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>     2007-07-29 18:02:20 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>     2007-08-01 17:37:11 from Jan Dittmer <jdi(at)l4x(dot)org>
Lists:	pgsql-performance

Responses

• Re: select on 1milion register = 6s at 2007-07-28 19:56:58 from Hervé Piedvache
• Re: select on 1milion register = 6s at 2007-07-28 19:59:26 from Craig James

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Jeremy Harris	2007-07-28 19:40:12	Re: Slow query with backwards index scan
Previous Message	Tilmann Singer	2007-07-28 19:27:13	Re: Slow query with backwards index scan