Thread: what are postgresql limits?
i've posted to general mailing list, but no clear answer, so i ask to you. i hope this is right. what are max db and table size under Linux x86 and Linux Alpha. Are there other Limitations? If yes, what are. I've a big project in my mind (may be 100 Gb of data) so i must know the numbers Thank you for your answer and good job! valter mazzola, http://naturalismedicina.com/linswap, The Linux & GPL apps banner exchange program.
On Fri, 23 Apr 1999, valter wrote: > i've posted to general mailing list, but no clear answer, so i ask to > you. i hope this is right. > > what are max db and table size under Linux x86 and Linux Alpha. > > Are there other Limitations? If yes, what are. > I've a big project in my mind (may be 100 Gb of data) so i must know the > numbers > > Thank you for your answer and good job! > > valter mazzola, http://naturalismedicina.com/linswap, The Linux & GPL > apps banner exchange program. There are no maximum sizes that we are currently aware of *except* for the number of rows that can be in a database, which, I believe, is limited athtis time to a 32bit int (oid) ... Other then that, we had a bug in pre-v6.5 servers that due to the 2gig limitation on files in some OSs, a problem did occur, but this bug is fixed in v6.5 ... Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
> i've posted to general mailing list, but no clear answer, so i ask to > you. i hope this is right. > > what are max db and table size under Linux x86 and Linux Alpha. > > Are there other Limitations? If yes, what are. > I've a big project in my mind (may be 100 Gb of data) so i must know the > numbers No limits. 100GB is fine. Use 6.5 beta for testing. Some platforms had bugs in 2gig files, though I believe alpha was OK for that. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026
Bruce Momjian wrote: > > i've posted to general mailing list, but no clear answer, so i ask to > > you. i hope this is right. > > > > what are max db and table size under Linux x86 and Linux Alpha. > > > > Are there other Limitations? If yes, what are. > > I've a big project in my mind (may be 100 Gb of data) so i must know the > > numbers > > No limits. > write this in the documentation , Unlimited is a good point! > > 100GB is fine. Use 6.5 beta for testing. Some platforms had bugs in > 2gig files, though I believe alpha was OK for that. > > -- > Bruce Momjian | http://www.op.net/~candle > maillist@candle.pha.pa.us | (610) 853-3000 > + If your life is a hard drive, | 830 Blythe Avenue > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
> Bruce Momjian wrote: > > > > i've posted to general mailing list, but no clear answer, so i ask to > > > you. i hope this is right. > > > > > > what are max db and table size under Linux x86 and Linux Alpha. > > > > > > Are there other Limitations? If yes, what are. > > > I've a big project in my mind (may be 100 Gb of data) so i must know the > > > numbers > > > > No limits. > > > > write this in the documentation , Unlimited is a good point! I will write this in the FAQ. This is a good point. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026