From: Simon Riggs <simon@2ndquadrant.com>
To: sathiya psql <sathiya.psql@gmail.com>
Cc: Richard Broersma <richard.broersma@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: what is the maximum number of rows in a table in postgresql 8.1
Date: Tue, 25 Mar 2008 13:59:05 +0000
Message-ID: <1206453545.4285.908.camel@ebony.site> (raw)
In-Reply-To: <f966c2ee0803250512k280eda90s629b9642da6162a7@mail.gmail.com>
References: <f966c2ee0803250442h76dabe80sfff5eb64c93dccb2@mail.gmail.com>
<396486430803250510t58a5532coc7955463101395c0@mail.gmail.com>
<f966c2ee0803250512k280eda90s629b9642da6162a7@mail.gmail.com>
On Tue, 2008-03-25 at 17:42 +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
You want a simple answer to a very difficult question and regrettably it
isn't that simple or that quick.
Some of the considerations you would need to think about would be:
* What workloads are you running?
* What hardware will it run on?
* What performance is required?
...
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com
PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: simon@2ndquadrant.com, sathiya.psql@gmail.com, richard.broersma@gmail.com
Subject: Re: what is the maximum number of rows in a table in postgresql 8.1
In-Reply-To: <1206453545.4285.908.camel@ebony.site>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox