| From: | Christopher Browne <cbbrowne(at)libertyrms(dot)info> |
|---|---|
| To: | "Wilson A(dot) Galafassi Jr(dot)" <juniorlist(at)yahoo(dot)com(dot)br> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: partitioning for postgresql |
| Date: | 2003-08-06 20:51:07 |
| Message-ID: | 60n0em8q84.fsf@dev6.int.libertyrms.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
> what is suggested partitioning schema for postgresql??
> the size of my db is 5BG and i have 36GB scsi disk!
The interesting forms of partitioning kind of assume that you have
multiple disk drives.
If you only have one drive, then there is not terribly much reason to
prefer anything much over simply having one big partition, and letting
the data fall where it will.
If you had two drives, then it would make sense to have data on one
drive and WAL on the other. With three drives, having other I/O (such
as database logging) on a third drive would have merit.
But none of those approaches are useful if you only have one disk
drive.
--
"cbbrowne","@","libertyrms.info"
<http://dev6.int.libertyrms.com/>
Christopher Browne
(416) 646 3304 x124 (land)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2003-08-06 20:51:13 | Re: EXTERNAL storage and substring on long strings |
| Previous Message | scott.marlowe | 2003-08-06 20:37:34 | Re: ext3 block size |