Re: [PERFORM] Tuning PostgreSQL

2003-07-24 Thread Ron Johnson
On Thu, 2003-07-24 at 13:29, Greg Stark wrote: > "scott.marlowe" <[EMAIL PROTECTED]> writes: > > > If you are writing 4k out to a RAID5 of 10 disks, this is what happens: > > > > (assumiung 64k stipes...) > > READ data stripe (64k read) > > READ parity stripe (64k read) > > make changes to data s

Re: [PERFORM] hardware performance and some more

2003-07-24 Thread Ron Johnson
On Thu, 2003-07-24 at 13:25, Kasim Oztoprak wrote: > On 24 Jul 2003 17:08 EEST you wrote: > > > On 24 Jul 2003 at 15:54, Kasim Oztoprak wrote: [snip] > > we do not have memory problem or disk problems. as I have seen in the list the best > way to > use disks are using raid 10 for data and raid

Re: [PERFORM] Tuning PostgreSQL

2003-07-24 Thread Greg Stark
"scott.marlowe" <[EMAIL PROTECTED]> writes: > If you are writing 4k out to a RAID5 of 10 disks, this is what happens: > > (assumiung 64k stipes...) > READ data stripe (64k read) > READ parity stripe (64k read) > make changes to data stripe > XOR new data stripe with old parity stripe to get a ne

Re: [PERFORM] hardware performance and some more

2003-07-24 Thread William Yu
| first of all I would like to learn that, any of you use the postgresql | within the clustered environment? Or, let me ask you the question, in | different manner, can we use postgresql in a cluster environment? If | we can do what is the support method of the postgresql for clusters? You could do

Re: [PERFORM] hardware performance and some more

2003-07-24 Thread Kasim Oztoprak
On 24 Jul 2003 18:44 EEST you wrote: > > Now, the second question is related to the performance of the database. Assuming > > we have a > > dell's poweredge 6650 with 4 x 2.8 Ghz Xeon processors having 2 MB of cache for > > each, with the > > main memory of lets say 32 GB. We can either use a sm

Re: [PERFORM] hardware performance and some more

2003-07-24 Thread Roman Fail
> Now, the second question is related to the performance of the database. Assuming we > have a > dell's poweredge 6650 with 4 x 2.8 Ghz Xeon processors having 2 MB of cache for > each, with the > main memory of lets say 32 GB. We can either use a small SAN from EMC or we can put > all disks > in

Re: [PERFORM] hardware performance and some more

2003-07-24 Thread Kasim Oztoprak
On 24 Jul 2003 17:08 EEST you wrote: > On 24 Jul 2003 at 15:54, Kasim Oztoprak wrote: > > > The questions for this explanation are: > > 1 - Can we use postgresql within clustered environment? > > 2 - if the answer is yes, in which method can we use postgresql within a > > cluster? >

Re: [PERFORM] hardware performance and some more

2003-07-24 Thread Shridhar Daithankar
On 24 Jul 2003 at 15:54, Kasim Oztoprak wrote: > The questions for this explanation are: > 1 - Can we use postgresql within clustered environment? > 2 - if the answer is yes, in which method can we use postgresql within a > cluster? > active - passive or active - active? Couple

[PERFORM] hardware performance and some more

2003-07-24 Thread Kasim Oztoprak
hello, some of my questions may not be related to this group however, I know that some of them are directly related to this list. first of all I would like to learn that, any of you use the postgresql within the clustered environment? Or, let me ask you the question, in different manner, can w