472,352 Members | 1,579 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,352 software developers and data experts.

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


Jul 28 '05 #1
2 7769
2,452 Expert Mod 2GB

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.
Jul 29 '05 #3

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

Similar topics

by: Mage | last post by:
Hello! create or replace function trigger_keywords_maintain() returns trigger as $$ return 'MODIFY' $$ language plpythonu; update table set...
by: Joshua D. Drake | last post by:
Hello, I think the below just about says it all: http://www.commandprompt.com/images/mammoth_versus_dolphin_500.jpg Sincerely, Joshua...
by: Anurag | last post by:
This simple one beats me all ends up(sincerely). I have been doing DB2 UDB for some time now, reading a lot of good discussions in this forum,...
by: Andy B | last post by:
If I bought one of these boxes/OS combos as a postgresql database server, would postgresql be able to make the best use of it with a huge (e.g....
by: Joseph Geretz | last post by:
I'm developing a Web Service using DIME to download and upload files from and to an IIS server. In order to increase the download filesize to...
by: AB | last post by:
Hello all, I heard once that there is a limitation on the number of lines of code that a program can have when using C, but not for C++. Is this...
by: vivian | last post by:
Hi Is there any limitation in query result in postgresql? When I run the query , I only can see maximum 1000 records(rows). Actually the results...
by: nehashri | last post by:
hi can ne1 tell me advantage of postgresql over ms access and limitation of postgresql over MS access. plz help thanx neha
by: leegold58 | last post by:
Hi, Is there a "way around" the size limitation for Access? I'm thinking of something like spanning a huge table accross multiple databases... ...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS...
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.