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: "Harald Armin Massa" <haraldarminmassa(at)gmail(dot)com>
Cc: 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 11:54:06
Message-ID: f966c2ee0803250454k716edf4cgcd054e7b563e530c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>
> 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....

>
>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Alvaro Herrera 2008-03-25 11:59:21 Re: postgresql is slow with larger table even it is in RAM
Previous Message Harald Armin Massa 2008-03-25 11:48:21 Re: what is the maximum number of rows in a table in postgresql 8.1