By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,915 Members | 1,339 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,915 IT Pros & Developers. It's quick & easy.

Does PostgreSQL have a size limitation

P: 2
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
Share this Question
Share on Google+
2 Replies


Expert Mod 100+
P: 2,330
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

P: 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.