469,342 Members | 5,582 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,342 developers. It's quick & easy.

Does PostgreSQL have a size limitation

I'm in the early stages of researching the migrating of an OLTP Oracle database (size 200+ GB) and still growing to PostgreSQL 8.x. Before I spend alot of time documenting the migration path, I'd like to know if there is a limitation to the size of a PostgeSQL database. If so, what is the limitation?

Any feedback would be greatly appreciated

Thanks,

Rick
Jul 28 '05 #1
2 7606
Niheel
2,431 Expert Mod 2GB
http://www.troubleshooters.com/lpm/2...stgreSQL_Intro

Scroll down and you'll see this. There is a e-mail for the author of that bit of information (Steve Litt) on that page.

Limitations of PostgreSQL
>> 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: 1GB in 7.1 and later
> Maximum number of rows in a table: unlimited
> Maximum number of columns in a table: 1600
> Maximum number of indexes on a table: unlimited
Hope that helps you.




They talk about 60GB. Your database is 3 1/3 times bigger. I would e-mail that author. That is a really big db.
Jul 28 '05 #2
Thanks for the update. I'll try to contact the author.
Rick
Jul 29 '05 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Mage | last post: by
33 posts views Thread by Joshua D. Drake | last post: by
2 posts views Thread by Anurag | last post: by
6 posts views Thread by AB | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.