Re: [PERFORM] Tuning PostgreSQL

2003-07-26 Thread Balazs Wellisch
Since there seem to be a lot of different opinions regarding the various different RAID configurations I thought I'd post this link to the list: http://www.storagereview.com/guide2000/ref/hdd/perf/raid/index.html This is the best resource for information on RAID and hard drive performance I found

Re: [PERFORM] Tuning PostgreSQL

2003-07-26 Thread Tom Lane
"Arjen van der Meijden" <[EMAIL PROTECTED]> writes: > Well, reboting is not a problem with ext2, but crashing might be... And > normally you don't plan a systemcrash ;) > Ext3 and xfs handle that much better. A journaling filesystem is good to use if you can set it to journal metadata but not file

Re: [PERFORM] Tuning PostgreSQL

2003-07-26 Thread Arjen van der Meijden
> Andrew McMillan wrote: > > The general heuristic is that RAID-5 is not the way to deal > with databases. Now surely someone will disagree with me, > but as I understand it RAID-5 has a bottleneck on a single > disk for the > (checksum) information. Bottleneck is not the word you want > to h

[PERFORM] SUBSCRIBE

2003-07-26 Thread Rauf Kuliyev
SUBSCRIBE ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [PERFORM] Tuning PostgreSQL

2003-07-26 Thread Andrew McMillan
On Wed, 2003-07-23 at 00:53, Alexander Priem wrote: > Wow, I never figured how many different RAID configurations one could think > of :) > > After reading lots of material, forums and of course, this mailing-list, I > think I am going for a RAID5 configuration of 6 disks (18Gb, 15.000 rpm > eac