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

pgsql-performance by date

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

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