pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedwhat is the maximum number of rows in a table in postgresql 8.1
7+ messages / 5 participants
[nested] [flat]
* what is the maximum number of rows in a table in postgresql 8.1
@ 2008-03-25 11:42 sathiya psql <sathiya.psql@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: sathiya psql @ 2008-03-25 11:42 UTC (permalink / raw)
To: pgsql-admin
Ok, finally am changing my question.
Do get quick response from postgresql what is the maximum number of records
i can have in a table in postgresql 8.1 ???
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: what is the maximum number of rows in a table in postgresql 8.1
@ 2008-03-25 12:10 Richard Broersma <richard.broersma@gmail.com>
parent: sathiya psql <sathiya.psql@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Richard Broersma @ 2008-03-25 12:10 UTC (permalink / raw)
To: sathiya psql <sathiya.psql@gmail.com>; +Cc: pgsql-admin
On Tue, Mar 25, 2008 at 4:42 AM, sathiya psql <sathiya.psql@gmail.com> wrote:
> Ok, finally am changing my question.
> Do get quick response from postgresql what is the maximum number of records
> i can have in a table in postgresql 8.1 ???
I am not sure I understand your question. maybe this link answers
your question:
http://www.postgresql.org/about/
Regards,
Richard Broersma Jr.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: what is the maximum number of rows in a table in postgresql 8.1
@ 2008-03-25 12:12 sathiya psql <sathiya.psql@gmail.com>
parent: Richard Broersma <richard.broersma@gmail.com>
0 siblings, 4 replies; 7+ messages in thread
From: sathiya psql @ 2008-03-25 12:12 UTC (permalink / raw)
To: Richard Broersma <richard.broersma@gmail.com>; +Cc: pgsql-admin
>
>
> 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
Regards
Sathiya
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: what is the maximum number of rows in a table in postgresql 8.1
@ 2008-03-25 12:18 Tino Schwarze <postgresql@tisc.de>
parent: sathiya psql <sathiya.psql@gmail.com>
3 siblings, 0 replies; 7+ messages in thread
From: Tino Schwarze @ 2008-03-25 12:18 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: what is the maximum number of rows in a table in postgresql 8.1
@ 2008-03-25 12:23 Richard Broersma <richard.broersma@gmail.com>
parent: sathiya psql <sathiya.psql@gmail.com>
3 siblings, 0 replies; 7+ messages in thread
From: Richard Broersma @ 2008-03-25 12:23 UTC (permalink / raw)
To: sathiya psql <sathiya.psql@gmail.com>; +Cc: pgsql-admin
On Tue, Mar 25, 2008 at 5:12 AM, sathiya psql <sathiya.psql@gmail.com> wrote:
> i need what will be the maximum number of rows to have good performance in
> postgres 8.1
This article give you the options that you have with postgresql.
http://www.commandprompt.com/blogs/joshua_drake/2007/08/how_many_rows_do_i_have_anyway/
Regards,
Richard Broersma Jr.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: what is the maximum number of rows in a table in postgresql 8.1
@ 2008-03-25 13:59 Simon Riggs <simon@2ndquadrant.com>
parent: sathiya psql <sathiya.psql@gmail.com>
3 siblings, 0 replies; 7+ messages in thread
From: Simon Riggs @ 2008-03-25 13:59 UTC (permalink / raw)
To: sathiya psql <sathiya.psql@gmail.com>; +Cc: Richard Broersma <richard.broersma@gmail.com>; pgsql-admin
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: what is the maximum number of rows in a table in postgresql 8.1
@ 2008-03-25 14:05 hubert depesz lubaczewski <depesz@depesz.com>
parent: sathiya psql <sathiya.psql@gmail.com>
3 siblings, 0 replies; 7+ messages in thread
From: hubert depesz lubaczewski @ 2008-03-25 14:05 UTC (permalink / raw)
To: sathiya psql <sathiya.psql@gmail.com>; +Cc: pgsql-admin
On Tue, Mar 25, 2008 at 05:42:46PM +0530, sathiya psql wrote:
> i need what will be the maximum number of rows *to have good performance* in
> postgres 8.1
any. just accept the fact that count(*) is *always* slow.
use triggers to store counts if you are using them all of the time.
also, i have two simple requests:
1. try to write to 1 mailing list. and not send the same question to all
lists you can find.
2. please try to avoid using workds like "lakh" or "crore" in your
mails.
i assume they mean something in your country of origin, but as far as i
know this is not english.
regards,
depesz
--
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA. here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2008-03-25 14:05 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-03-25 11:42 what is the maximum number of rows in a table in postgresql 8.1 sathiya psql <sathiya.psql@gmail.com>
2008-03-25 12:10 ` Richard Broersma <richard.broersma@gmail.com>
2008-03-25 12:12 ` sathiya psql <sathiya.psql@gmail.com>
2008-03-25 12:18 ` Tino Schwarze <postgresql@tisc.de>
2008-03-25 12:23 ` Richard Broersma <richard.broersma@gmail.com>
2008-03-25 13:59 ` Simon Riggs <simon@2ndquadrant.com>
2008-03-25 14:05 ` hubert depesz lubaczewski <depesz@depesz.com>
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