| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Karen Hill <karen_hill22(at)yahoo(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL theoretical maximums. |
| Date: | 2006-07-27 18:08:26 |
| Message-ID: | 44C9011A.5070504@archonet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jasbinder Bali | 2006-07-27 19:49:08 | server administration problem: Database startup and permissions |
| Previous Message | Peter Eisentraut | 2006-07-27 18:08:19 | Re: PostgreSQL theoretical maximums. |