Postgres Pro
Downloads
Home   >   mailing lists

Re: what is the maximum number of rows in a table in postgresql 8.1 - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: what is the maximum number of rows in a table in postgresql 8.1
Date
Msg-id 20080325120101.GC6756@alvh.no-ip.org
Whole thread Raw
In response to Re: what is the maximum number of rows in a table in postgresql 8.1  ("sathiya psql" <sathiya.psql@gmail.com>)
Responses Re: what is the maximum number of rows in a table in postgresql 8.1
List pgsql-performance
Tree view 
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.

pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: postgresql is slow with larger table even it is in RAM
Next
From: "sathiya psql"
Date:
Subject: Re: what is the maximum number of rows in a table in postgresql 8.1