optimal newfs for postgres data store

From: Vivek Khera <khera(at)kcilink(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: optimal newfs for postgres data store
Date: 2001-05-16 15:14:04
Message-ID: x77kzhba2r.fsf@onceler.kciLink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Does anyone have advice on optimal newfs options for a FFS file system
on FreeBSD (with soft-updates on, naturally)?

Looking at my test server, admittedly with not a lot of data on it, I
see lots of files sized at 8k or 16k and some larger, and a few zero
sized.

I'm thinking setting bumping the -i value to 8k or 16k. Any other
flags to tweak? The file system is a 5 disk RAID5 with 130Gb on it.

Thanks.

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera(at)kciLink(dot)com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/

Browse pgsql-general by date

  From Date Subject
Next Message Keith G. Murphy 2001-05-16 15:14:08 Re: Re: Which Front End for Postgresql
Previous Message Tom Lane 2001-05-16 15:00:06 Re: trouble with the automatic indexes on CREATE TABLE