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

2008-03-25 Thread hubert depesz lubaczewski
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 t

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

2008-03-25 Thread Simon Riggs
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... >

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

2008-03-25 Thread Tino Schwarze
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 num

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

2008-03-25 Thread Richard Broersma
On Tue, Mar 25, 2008 at 5:12 AM, sathiya psql <[EMAIL PROTECTED]> 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_ro

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

2008-03-25 Thread sathiya psql
> > > 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

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

2008-03-25 Thread Richard Broersma
On Tue, Mar 25, 2008 at 4:42 AM, sathiya psql <[EMAIL PROTECTED]> 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 a

[ADMIN] what is the maximum number of rows in a table in postgresql 8.1

2008-03-25 Thread sathiya psql
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 ???