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

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: sathiya psql <sathiya(dot)psql(at)gmail(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:01:01
Message-ID: 20080325120101.GC6756@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

sathiya psql escribió:

> I have 1 GB RAM with Pentium Celeron.
> 50 lakh records and postgres performance is not good....
>
> It takes 30 sec for simple queries....

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.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message sathiya psql 2008-03-25 12:08:24 Re: what is the maximum number of rows in a table in postgresql 8.1
Previous Message Alvaro Herrera 2008-03-25 11:59:21 Re: postgresql is slow with larger table even it is in RAM