Re: Slow "Select count(*) ..." query on table with 60 Mio. rows

From:	"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To:	"Matthew Wakeling" <matthew(at)flymine(dot)org>, <pgsql-performance(at)postgresql(dot)org>
Subject:	Re: Slow "Select count(*) ..." query on table with 60 Mio. rows
Date:	2010-01-14 15:47:53
Message-ID:	4B4EE849020000250002E4A4@gw.wicourts.gov
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2010-01-14 15:47:53 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>  2010-01-14 15:59:57 from Ivan Voras <ivoras(at)freebsd(dot)org>   2010-01-14 16:03:16 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>  2010-01-14 18:01:50 from Greg Smith <greg(at)2ndquadrant(dot)com>   2010-01-14 18:12:17 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>    2010-01-14 18:25:14 from Greg Smith <greg(at)2ndquadrant(dot)com>     2010-01-14 18:33:50 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>      2010-01-14 18:49:58 from Greg Smith <greg(at)2ndquadrant(dot)com>
Lists:	pgsql-performance

Responses

• Re: Slow "Select count(*) ..." query on table with 60 Mio. rows at 2010-01-14 15:59:57 from Ivan Voras
• Re: Slow "Select count(*) ..." query on table with 60 Mio. rows at 2010-01-14 18:01:50 from Greg Smith

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Pierre Frédéric Caillaud	2010-01-14 15:59:15	Re: performance config help
Previous Message	A. Kretschmer	2010-01-14 15:18:14	Re: Slow "Select count(*) ..." query on table with 60 Mio. rows