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.
> Joshua D. Drake
In response to
pgsql-performance by date
|Next:||From: André Volpato||Date: 2008-08-21 13:53:33|
|Subject: Re: Postgres not using array|
|Previous:||From: Moritz Onken||Date: 2008-08-21 07:45:32|
|Subject: Re: Slow query with a lot of data |