pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (7+ messages)  latest in thread

Message-ID: <1206453545.4285.908.camel@ebony.site>
Permalink:  ../1206453545.4285.908.camel@ebony.site/
Also on:    postgresql.org/message-id/1206453545.4285.908.camel@ebony.site

 · 

reply

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