Re: Querying 19million records very slowly

From:	PFC <lists(at)boutiquenumerique(dot)com>
To:	"Paul Ramsey" <pramsey(at)refractions(dot)net>, "Kjell Tore Fossbakk" <kjelltore(at)gmail(dot)com>
Cc:	pgsql-performance(at)postgresql(dot)org
Subject:	Re: Querying 19million records very slowly
Date:	2005-06-21 21:33:30
Message-ID:	op.ssqot4d4th1vuj@localhost
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2005-06-21 19:09:48 from Kjell Tore Fossbakk <kjelltore(at)gmail(dot)com>  2005-06-21 19:59:22 from Paul Ramsey <pramsey(at)refractions(dot)net>   2005-06-21 21:33:30 from PFC <lists(at)boutiquenumerique(dot)com>    2005-06-22 07:45:22 from Kjell Tore Fossbakk <kjelltore(at)gmail(dot)com>     2005-06-22 08:03:57 from Tobias Brox <tobias(at)nordicbet(dot)com>      2005-06-22 08:18:30 from Kjell Tore Fossbakk <kjelltore(at)gmail(dot)com>       2005-06-22 08:39:21 from Tobias Brox <tobias(at)nordicbet(dot)com>        2005-06-22 08:55:35 from Michael Glaesemann <grzm(at)myrealbox(dot)com>         2005-06-22 09:10:42 from Kjell Tore Fossbakk <kjelltore(at)gmail(dot)com>          2005-06-22 09:36:44 from Tobias Brox <tobias(at)nordicbet(dot)com>           2005-06-22 13:50:39 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>         2005-06-22 15:23:41 from Stefan Weiss <spaceman(at)foo(dot)at>     2005-06-22 14:20:13 from Paul Ramsey <pramsey(at)refractions(dot)net>      2005-06-22 14:41:54 from Kjell Tore Fossbakk <kjelltore(at)gmail(dot)com>       2005-06-22 16:28:44 from Tobias Brox <tobias(at)nordicbet(dot)com>        2005-06-23 13:31:13 from Kjell Tore Fossbakk <kjelltore(at)gmail(dot)com>         2005-06-23 15:31:12 from Tobias Brox <tobias(at)nordicbet(dot)com>
Lists:	pgsql-performance

In response to

• Re: Querying 19million records very slowly at 2005-06-21 19:59:22 from Paul Ramsey

Responses

• Re: Querying 19million records very slowly at 2005-06-22 07:45:22 from Kjell Tore Fossbakk

Browse pgsql-performance by date

	From	Date	Subject
Next Message	William Yu	2005-06-21 21:53:52	Re: Trying to figure out pgbench
Previous Message	Tom Lane	2005-06-21 21:20:07	Re: Limit clause not using index