Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 - Mailing list pgsql-performance

From Decibel!
Subject Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
Date
Msg-id 20070911234941.GN38801@decibel.org
Whole thread Raw
In response to Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-performance
On Wed, Sep 12, 2007 at 12:02:46AM +0100, Gregory Stark wrote:
> "Decibel!" <decibel@decibel.org> writes:
>
> > On Tue, Sep 11, 2007 at 02:49:28PM -0400, Jean-David Beyer wrote:
> >> It is tricky for me to find a big enough file to test. I tried one of the
> >
> > dd if=/dev/zero of=bigfile bs=8192 count=1000000
>
> On linux another useful trick is:
>
> echo 1 > /proc/sys/vm/drop_caches

The following C code should have similar effect...


/*
 * $Id: clearmem.c,v 1.1 2003/06/29 20:41:33 decibel Exp $
 *
 * Utility to clear out a chunk of memory and zero it. Useful for flushing disk buffers
 */

int main(int argc, char *argv[]) {
    if (!calloc(atoi(argv[1]), 1024*1024)) { printf("Error allocating memory.\n"); }
}
--
Decibel!, aka Jim Nasby                        decibel@decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

Attachment

pgsql-performance by date:

Previous
From: Decibel!
Date:
Subject: Re: SAN vs Internal Disks
Next
From: david@lang.hm
Date:
Subject: Re: SAN vs Internal Disks