Re: The results of my PostgreSQL/filesystem performance tests - Mailing list pgsql-performance

From Sean Chittenden
Subject Re: The results of my PostgreSQL/filesystem performance tests
Date
Msg-id 20030828214940.GQ83759@perrin.nxad.com
Whole thread Raw
In response to Re: The results of my PostgreSQL/filesystem performance tests  (Vivek Khera <khera@kcilink.com>)
List pgsql-performance
> >> I need to step in and do 2 things:
> SC> Thanks for posting that.  Let me know if you have any questions while
> SC> doing your testing.  I've found that using 16K blocks on FreeBSD
> SC> results in about an 8% speedup in writes to the database, fwiw.
>
> ok.. ignore my prior request about how to set that... i missed you
> had included a patch.
>
> Any recommendations on newfs parameters for an overly large file
> system used solely for Postgres?  Over 100Gb (with raid 10) or over
> 200Gb (with raid 5)?

Nope, you'll have to test and see.  If you find something that works,
however, let me know.  -sc

--
Sean Chittenden

pgsql-performance by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Queries sometimes take 1000 times the normal time
Next
From: Ken Geis
Date:
Subject: bad estimates / non-scanning aggregates