I'm designing a database for a project, and have been trying to get an idea of PostgreSQL performance for large table sizes.
I'm aware that this is highly dependant upon hardware, table design and other performance criteria, but I was hoping that some of you may have some experience which will give me an idea of what I can expect.
According to the PostgreSQL documentation, there is no hard limit per se on a table size in terms of row count, allow there is a limit of 32TB on the physical size of the table.
Does anyone have any experience with, or can point me towards examples, the feasibilility of Postgres tables with row counts in the order of 10^9?
I appreciate this is a fairly involved topic, but I'm just interested in finding some additional background reading.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert