> >> 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
In response to
pgsql-performance by date
|Next:||From: Ron Johnson||Date: 2003-08-28 22:04:19|
|Subject: Re: Replication Ideas|
|Previous:||From: scott.marlowe||Date: 2003-08-28 21:26:14|
|Subject: Re: opinion on RAID choice|