Re: Why Select Count(*) from table - took over 20 minutes?

From:	Ozz Nixon <ozznixon(at)gmail(dot)com>
To:	Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc:	Diego Schulz <dschulz(at)gmail(dot)com>, PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject:	Re: Why Select Count(*) from table - took over 20 minutes?
Date:	2010-10-28 15:36:21
Message-ID:	B6CED44A-2607-4AD1-8172-024A649D9353@gmail.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2010-10-26 08:13:04 from Szymon Guz <mabewlun(at)gmail(dot)com>  2010-10-26 14:21:58 from David Fetter <david(at)fetter(dot)org>   2010-10-26 14:37:47 from Szymon Guz <mabewlun(at)gmail(dot)com>  2010-10-26 14:29:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>   2010-10-26 14:37:58 from Szymon Guz <mabewlun(at)gmail(dot)com>    2010-10-26 17:18:41 from Ozz Nixon <ozznixon(at)gmail(dot)com>     2010-10-26 17:26:31 from Bill Moran <wmoran(at)potentialtech(dot)com>     2010-10-26 17:33:05 from John R Pierce <pierce(at)hogranch(dot)com>      2010-11-03 10:15:23 from Jasen Betts <jasen(at)xnet(dot)co(dot)nz>     2010-10-26 17:33:51 from Alan Hodgson <ahodgson(at)simkin(dot)ca>     2010-10-26 20:30:08 from Diego Schulz <dschulz(at)gmail(dot)com>      2010-10-27 11:15:08 from Merlin Moncure <mmoncure(at)gmail(dot)com>       2010-10-28 15:36:21 from Ozz Nixon <ozznixon(at)gmail(dot)com>        2010-10-28 16:04:50 from Merlin Moncure <mmoncure(at)gmail(dot)com>
Lists:	pgsql-general

In response to

• Re: Why Select Count(*) from table - took over 20 minutes? at 2010-10-27 11:15:08 from Merlin Moncure

Responses

• Re: Why Select Count(*) from table - took over 20 minutes? at 2010-10-28 16:04:50 from Merlin Moncure

Browse pgsql-general by date

	From	Date	Subject
Next Message	ludwig	2010-10-28 15:52:53	Re: PostGIS return multiple points
Previous Message	John Cheng	2010-10-28 15:28:24	earthdistance or PostGIS for find * within point and radius