| From: | Sezai YILMAZ <sezai(dot)yilmaz(at)pro-g(dot)com(dot)tr> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Huge Data |
| Date: | 2004-01-14 12:27:56 |
| Message-ID: | 400535CC.7070402@pro-g.com.tr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Richard Huxton wrote:
>On Wednesday 14 January 2004 11:11, Sezai YILMAZ wrote:
>
>
>>Hi,
>>
>>I use PostgreSQL 7.4 for storing huge amount of data. For example 7
>>million rows. But when I run the query "select count(*) from table;", it
>>results after about 120 seconds. Is this result normal for such a huge
>>table? Is there any methods for speed up the querying time? The huge
>>table has integer primary key and some other indexes for other columns.
>>
>>
>
>PG uses MVCC to manage concurrency. A downside of this is that to verify the
>exact number of rows in a table you have to visit them all.
>
>There's plenty on this in the archives, and probably the FAQ too.
>
>What are you using the count() for?
>
>
I use count() for some statistics. Just to show how many records
collected so far.
-sezai
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sezai YILMAZ | 2004-01-14 12:39:24 | Re: Huge Data |
| Previous Message | Bob Parkinson | 2004-01-14 12:13:44 | Re: Drawbacks of using BYTEA for PK? |