Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group