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

From: "sathiya psql" <sathiya(dot)psql(at)gmail(dot)com>
To: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>
Cc: "Harald Armin Massa" <haraldarminmassa(at)gmail(dot)com>, 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 12:08:24
Message-ID: f966c2ee0803250508t444524b6y44b9ee67c8e04673@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>
>
>
> Shows us the explain analyze. There is no problem with a large number
> of records, as long as you're not expecting to process all of them all
> the time.

yes many a times i need to process all the records,

often i need to use count(*) ????

so what to do ?? ( those trigger options i know already, but i wil l do
count on different parameters )

>
>
>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Pavan Deolasee 2008-03-25 12:23:58 Re: increasing shared buffer slow downs query performance.
Previous Message Alvaro Herrera 2008-03-25 12:01:01 Re: what is the maximum number of rows in a table in postgresql 8.1