Skip site navigation (1) Skip section navigation (2)

Re: How to setup disk spindles for best performance

From: Christiaan Willemsen <cwillemsen(at)technocon(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: Merlin Moncure <mmoncure(at)gmail(dot)com>,pgsql-performance(at)postgresql(dot)org
Subject: Re: How to setup disk spindles for best performance
Date: 2008-08-21 08:34:19
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
Thanks Joshua,

So what about putting the indexes on a separate array? Since we do a lot 
of inserts indexes are going to be worked on a lot of the time.



Joshua D. Drake wrote:
> Christiaan Willemsen wrote:
>> So, what you are basically saying, is that a single mirror is in 
>> general more than enough to facilitate the transaction log.
> And to answer your question, yes. Transaction logs are written 
> sequentially. You do not need a journaled file system and raid 1 is 
> plenty for most if not all work loads.
> Sincerely,
> Joshua D. Drake

In response to


pgsql-performance by date

Next:From: André VolpatoDate: 2008-08-21 13:53:33
Subject: Re: Postgres not using array
Previous:From: Moritz OnkenDate: 2008-08-21 07:45:32
Subject: Re: Slow query with a lot of data

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group