Postgresql system requirements to support large databases.

[wilbur douma]

We are looking at implementing a large Postgresql database (50GB -
100GB) and are wondering if there are any limitations or problems for
a database of this size running on 32-bit architecture. I have seen
some older posts where it appears that Postgresql seemed to have
performance problems when the database reached 5GB, and it was
recommended that 64-bit architecture be used. Is this still true with
Postgresql version 7.4? This will be out first experience with
Postgresql and we are needing to get some ideas of what system
requirements a database of this size will require. Since the machines
that we have are all 32-bit, we would like to know if we will need to
go to 64-bit. Any comments or suggestions??

Thanks in advance for any help.

[Tom Lane]

wd****@zootweb.com (wilbur douma) writes:

We are looking at implementing a large Postgresql database (50GB -
100GB) and are wondering if there are any limitations or problems for
a database of this size running on 32-bit architecture.

The only thing a 64-bit arch will buy you is somewhat better support for
very large amounts of RAM (more than 4Gb). That might be worth having
depending on what your access patterns to the database will be like,
since more RAM would let more of the database be cached in memory.
But it's by no means a certain winner.

Personally I think you'd be better advised to worry about the quality of
your disk subsystem than to spend money on 64-bit buzzword compliance.

You can find more about such topics in the pgsql-performance archives.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

[Tom Lane]

wd****@zootweb.com (wilbur douma) writes:

We are looking at implementing a large Postgresql database (50GB -
100GB) and are wondering if there are any limitations or problems for
a database of this size running on 32-bit architecture.

The only thing a 64-bit arch will buy you is somewhat better support for
very large amounts of RAM (more than 4Gb). That might be worth having
depending on what your access patterns to the database will be like,
since more RAM would let more of the database be cached in memory.
But it's by no means a certain winner.

Personally I think you'd be better advised to worry about the quality of
your disk subsystem than to spend money on 64-bit buzzword compliance.

You can find more about such topics in the pgsql-performance archives.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)