Karen Hill wrote:
How many tables can PostgreSQL theoretically and then practically
handle? What is the largest database size possible? What was the
biggest database you've ever had on PostgreSQL? What were the
challenges and what kind of hardware and OS works best?
Maximum number of tables etc. is a FAQ:
http://www.postgresql.org/docs/faqs.FAQ.html#item4.4
It's been running on unix-like systems for much longer than Windows.
Apart from that, the best system is probably determined by your experience.
What is an effective way to predict database size when designing
tables?
Rule-of-thumb - assume 3-5 times the size of the raw data to allow for
overhead, indexes etc. Other than that, you can find details of on-disk
formats for rows towards the end of the manuals.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
