Skip site navigation (1) Skip section navigation (2)

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

From: Tino Schwarze <postgresql(at)tisc(dot)de>
To: pgsql-admin(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:18:52
Message-ID: 20080325121852.GF10192@easy2.in-chemnitz.de (view raw or flat)
Thread:
Lists: pgsql-admin
On Tue, Mar 25, 2008 at 05:42:46PM +0530, sathiya psql wrote:

> > I am not sure I understand your question.  maybe this link answers
> > your question:
> > http://www.postgresql.org/about/
> >
> this i know.....
> 
> this is the documentation limitations...
> 
> i need what will be the maximum number of rows *to have good performance* in
> postgres 8.1

That depends on your database schema and the queries you're running.
We've got PostgreSQL 8.2 databases with over 200 million rows in a
table and it's performing well. And there are possibly larger databases
around.

Bye,

Tino.

-- 
www.craniosacralzentrum.de
www.spiritualdesign-chemnitz.de
www.forteego.de

Tino Schwarze * Lortzingstra├če 21 * 09119 Chemnitz

In response to

pgsql-admin by date

Next:From: Richard BroersmaDate: 2008-03-25 12:23:36
Subject: Re: what is the maximum number of rows in a table in postgresql 8.1
Previous:From: sathiya psqlDate: 2008-03-25 12:12:46
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