Re: what is the maximum number of rows in a table in postgresql 8.1

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: sathiya psql <sathiya(dot)psql(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: what is the maximum number of rows in a table in postgresql 8.1
Date: 2008-03-25 13:09:34
Message-ID: 47E8F98E.1040505@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

sathiya psql wrote:
> EXPLAIN ANALYZE SELECT count(*) from call_log_in_ram ;
>
And your usual query is:

SELECT count(*) from call_log_in_ram;

?

If so, you should definitely build a summary table maintained by a
trigger to track the row count. That's VERY well explained in the
mailing list archives. This was suggested to you very early on in the
discussion.

If you have problems with other queries, how about showing EXPLAIN
ANALYZE for the other queries you're having problems with?

--
Craig Ringer

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Bill Moran 2008-03-25 13:10:46 Re: postgresql is slow with larger table even it is in RAM
Previous Message sathiya psql 2008-03-25 12:50:25 Re: what is the maximum number of rows in a table in postgresql 8.1