[PERFORM] partitioning for postgresql

2003-08-14 Thread Wilson A. Galafassi Jr.
hello!!! what is suggested partitioning schema for postgresql?? the size of my db is 5BG and i have 36GB scsi disk! thanks wilson

Re: [PERFORM] partitioning for postgresql

2003-08-14 Thread scott.marlowe
On Wed, 6 Aug 2003, Wilson A. Galafassi Jr. wrote: > hello!!! > what is suggested partitioning schema for postgresql?? > the size of my db is 5BG and i have 36GB scsi disk! The first recommendation is to run Postgresql on a RAID set for reliability. I'm assuming you're building a machine and

Re: [PERFORM] partitioning for postgresql

2003-08-09 Thread Christopher Browne
> 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