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 sathiya psql
Subject Re: what is the maximum number of rows in a table in postgresql 8.1
Date
Msg-id f966c2ee0803250454k716edf4cgcd054e7b563e530c@mail.gmail.com
Whole thread Raw
In response to Re: what is the maximum number of rows in a table in postgresql 8.1  ("Harald Armin Massa" <haraldarminmassa@gmail.com>)
Responses Re: what is the maximum number of rows in a table in postgresql 8.1
Re: what is the maximum number of rows in a table in postgresql 8.1
List pgsql-performance
Tree view


th maximum number of records in one PostreSQL table ist unlimited:
am asking for good performance, not just limitation..

If i have half a crore record, how the performance will be ?

http://www.postgresql.org/about/

[for some values of unlimited]

Some further help:

googling for:
postgresql limits site:postgresql.org
but i need some experimentation result...

I have 1 GB RAM with Pentium Celeron.
50 lakh records and postgres performance is not good....

It takes 30 sec for simple queries....


pgsql-performance by date:

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