Re: slow update of index during insert/copy

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Thomas Finneid" <tfinneid(at)student(dot)matnat(dot)uio(dot)no>
Cc: "Scott Carey" <scott(at)richrelevance(dot)com>, "Craig Ringer" <craig(at)postnewspapers(dot)com(dot)au>, pgsql-performance(at)postgresql(dot)org
Subject: Re: slow update of index during insert/copy
Date: 2008-09-01 20:42:07
Message-ID: dcc563d10809011342i55d32d23la4604e71d19dfdb0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Sep 1, 2008 at 2:32 PM, Thomas Finneid
<tfinneid(at)student(dot)matnat(dot)uio(dot)no> wrote:
>
> Scott Carey wrote:
>>
>> For a development box, just enable write-back caching regardless of the
>> battery back up situation. As long as its not your only copy of
>
> Will have a look at it, the data is not important and can be reproduced any
> time on any machine. The controller I have is a Areca ARC-1220 Serial ATA 8
> port RAID Controller - PCI-E, SATA II, so I dont know exactly what it
> supports of caching.

It's a pretty good card. It should support 1G of cache at least, and
definitely supports battery backup. Have had a pair of 1680 Arecas in
production for a month now and so far I'm very happy with the
reliability and performance.

The other Scott is technically right about the lack of need for
battery back on a dev machine as long as you go in and change the
chaching to write back, and I'm sure the card will give you a red
dialog box saying this is a bad idea. Now, if it would take you a day
of downtime to get a dev database back in place and running after a
power loss, then the bbu may be worth the $200 or so.

While I like to have a machine kitted out just like prod for testing,
for development I do tend to prefer slower machines, so that
developers might notice if they've just laid a big fat bloaty code
egg that's slower than it should be. Try to optimize for acceptable
performance on such server and you're far more likely to get good
performance behaviour in production.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2008-09-01 20:49:38 Re: slow update of index during insert/copy
Previous Message Scott Carey 2008-09-01 20:40:50 Re: slow update of index during insert/copy