Postgres Pro
Downloads
Home   >   mailing lists

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

From Ozz Nixon
Subject Re: Why Select Count(*) from table - took over 20 minutes?
Date
Msg-id B6CED44A-2607-4AD1-8172-024A649D9353@gmail.com
Whole thread Raw
In response to Re: Why Select Count(*) from table - took over 20 minutes?  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: Why Select Count(*) from table - took over 20 minutes?
List pgsql-general
Tree view 
How/where do I query this?

My script does not need a 100% accurate count - just a recently valid count - so I can verify the web crawlers are
stillcrawling :-) 

On Oct 27, 2010, at 7:15 AM, Merlin Moncure wrote:

> pg_class.reltuples

pgsql-general by date:

Previous
From: John Cheng
Date:
Subject: earthdistance or PostGIS for find * within point and radius
Next
From: ludwig@kni-online.de
Date:
Subject: Re: PostGIS return multiple points