Re: [DOCS] Re: [ADMIN] postgres limitation

2001-02-05 Thread Bruce Momjian
We made a separate web page for the long version. > Bruce Momjian writes : > > > Can I get some feedback from the group? Should a long or short version > > be used in the FAQ? > > Please keep the long version in the FAQ at least until the full > version makes its way into the docs... > > Kim

Re: [ADMIN] postgres limitation

2001-01-29 Thread Kim Minh Kaplan
Bruce Momjian writes : > Can I get some feedback from the group? Should a long or short version > be used in the FAQ? Please keep the long version in the FAQ at least until the full version makes its way into the docs... Kim Minh.

Re: [DOCS] Re: [ADMIN] postgres limitation

2001-01-29 Thread Vince Vielhaber
On Sat, 27 Jan 2001, Bruce Momjian wrote: > Can I get some feedback from the group? Should a long or short version > be used in the FAQ? Neither, it has it's own web page. Vince. > > > > > How about the full answer? I think Tom did a fantastic job of writing up, > > be a shame to make it go

Re: [ADMIN] postgres limitation

2001-01-28 Thread Bruce Momjian
I think I have digested most of this information. I added it to the FAQ, generalized it in the text of the FAQ, or added it to the TODO list. Thanks, Tom. New FAQ text: --- These are the limits: Maximum size for a data

Re: [ADMIN] postgres limitation

2001-01-28 Thread Bruce Momjian
> > > Maximum size for a table? > > > > > > 2G blocks, hence 16 to 64 terabytes depending on the BLCKSZ > > > configuration constant. (If someone were to run around and make sure > > > all the block-number arithmetic is unsigned, we could claim 4G blocks, > > > but I think it's not all unsigned n

Re: [ADMIN] postgres limitation

2001-01-28 Thread Bruce Momjian
I updated the maximum number of columns: Maximum size for a database? unlimited (60GB databases exist) Maximum size for a table?64 TB on all operating systems Maximum size for a row? unlimited in 7.1 and later Maximum size for a field?1

Re: [ADMIN] postgres limitation

2001-01-27 Thread Bruce Momjian
Can I get some feedback from the group? Should a long or short version be used in the FAQ? > > How about the full answer? I think Tom did a fantastic job of writing up, > be a shame to make it go to waste for brevity? :( > > On Sat, 27 Jan 2001, Bruce Momjian wrote: > > > OK, how is this? >

Re: [ADMIN] postgres limitation

2001-01-27 Thread Tom Lane
The Hermit Hacker <[EMAIL PROTECTED]> writes: > How about the full answer? I think Tom did a fantastic job of writing up, > be a shame to make it go to waste for brevity? :( Perhaps someone would like to polish the answer into a section in the Administrator's Guide? Then the FAQ answer could st

Re: [ADMIN] postgres limitation

2001-01-27 Thread The Hermit Hacker
How about the full answer? I think Tom did a fantastic job of writing up, be a shame to make it go to waste for brevity? :( On Sat, 27 Jan 2001, Bruce Momjian wrote: > OK, how is this? > > > These are the limits: > > Maximum size for a database? unlimited (60GB databases exis

Re: [ADMIN] postgres limitation

2001-01-27 Thread Bruce Momjian
OK, how is this? These are the limits: Maximum size for a database? unlimited (60GB databases exist) Maximum size for a table?64 TB on all operating systems Maximum size for a row? unlimited in 7.1 and later Maximum si

Re: [ADMIN] postgres limitation

2001-01-27 Thread Tom Lane
Bruce, I think section 4.6 of the FAQ is a tad on the short and overly optimistic side. Here's a set of more precise statements ... 4.6) What is the maximum size for a row, table, database? Maximum size for a database? Effectively unlimited, although you may see performance problems w

Re: [ADMIN] postgres limitation

2001-01-27 Thread Bruce Momjian
> Maximum size for a row? >unlimited in 7.1 and later > Maximum number of rows in a table? >unlimited > Maximum number of columns in a table? >unlimited > Maximum number of indexes on a table? >

Re: [ADMIN] postgres limitation

2001-01-27 Thread R D
Hi, The FAQ says: _ 4.6) What is the maximum size for a row, table, database? These are the limits: Maximum size for a database? unlimited (60GB databases exist) Maximum size for a table?

[ADMIN] postgres limitation

2001-01-26 Thread a
Hi, Is there any document about the limitation of postgres like the total size of one table the max row number of a table the max size of a row... Thanks Feng