Re: [PERFORM] how to partition disks

hubert depesz lubaczewski writes: On 6/14/06, Sven Geisler raid 10 is of course not questionable. but are you sure that it will work faster than for example: 2 discs (raid 1) for xlog 6 discs (raid 10) for tables 6 discs (raid 10) for indices? Caching up on the performance list. Although th

Re: [PERFORM] how to partition disks

On Wed, Jun 14, 2006 at 04:32:23PM +0200, Sven Geisler wrote: For example, You run two queries with two clients and each queries needs to read some indices from disk. In this case it more efficient to read from different volumes than to read from one large volume where the disc arms has to jump

Re: [PERFORM] how to partition disks

On Wed, Jun 14, 2006 at 04:32:23PM +0200, Sven Geisler wrote: > Hi Richard, > > Richard Broersma Jr schrieb: > >>This depends on your application. Do you have a lot of disc reads? > >>Anyhow, I would put the xlog always to a RAID 10 volume because most of > >>the I/O for update and inserts is goi

Re: [PERFORM] how to partition disks

Hi Richard, Richard Broersma Jr schrieb: This depends on your application. Do you have a lot of disc reads? Anyhow, I would put the xlog always to a RAID 10 volume because most of the I/O for update and inserts is going to the xlog. 4 discs xlog 6 discs tables 4 discs tables2 I have a quest

Re: [PERFORM] how to partition disks

> > raid 10 is of course not questionable. but are you sure that it will > > work faster than for example: > > 2 discs (raid 1) for xlog > > 6 discs (raid 10) for tables > > 6 discs (raid 10) for indices? > > > > This depends on your application. Do you have a lot of disc reads? > Anyhow, I woul

Re: [PERFORM] how to partition disks

Hi Hupert, hubert depesz lubaczewski schrieb: On 6/14/06, *Sven Geisler* <[EMAIL PROTECTED] > wrote: You should configure your discs to RAID 10 volumes. You should set up a separate volume for WAL. A volume for an additional table space may also useful.

Re: [PERFORM] how to partition disks

On 6/14/06, Sven Geisler <[EMAIL PROTECTED]> wrote: You should configure your discs to RAID 10 volumes.You should set up a separate volume for WAL.A volume for an additional table space may also useful.In your case I would do 2 partitions:1. RAID 10 with 8 discs for general data raid 10 is of cours

Re: [PERFORM] how to partition disks

Hi Hubert, hubert depesz lubaczewski schrieb: hi i'm waiting for new server to arrive. for the server i will get hp msa1000, with 14 discs (72g, 15000 rpm). what kind of partitioning you suggest, to get maximum performance? for system things i will have separate discs, so whole array is only for

[PERFORM] how to partition disks

hii'm waiting for new server to arrive.for the server i will get hp msa1000, with 14 discs (72g, 15000 rpm).what kind of partitioning you suggest, to get maximum performance?for system things i will have separate discs, so whole array is only for postgresql. data processing is oltp, but with large