Does PostgreSQL have a size limitation

[Rick Brough]

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

[Niheel]

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.

[Rick Brough]

Thanks for the update. I'll try to contact the author.
Rick