Re: [ADMIN] request for tuning suggestions from PC Week Labs

From: Ragnar Kjørstad <postgres(at)ragnark(dot)vestdata(dot)no>
To: Timothy Dyck <Timothy_Dyck(at)zd(dot)com>
Cc: pgsql-admin(at)postgreSQL(dot)org
Subject: Re: [ADMIN] request for tuning suggestions from PC Week Labs
Date: 2000-01-30 11:41:36
Message-ID: 20000130124136.A12525@vestdata.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Sun, Jan 30, 2000 at 12:56:39AM -0500, Timothy Dyck wrote:
> Hi all, I'm the database analyst for PC Week Labs and am comparing
> PostgreSQL with Inprise's InterBase (which will be open sourced later this
> year). As part of this project, I'm running a benchmark with a mix of OLTP
> and DSS queries in a set of various mixes and at a variety of user loads
> (up to 100 concurrent users). I'd like to get your tuning suggestions on
> the engine to make sure I am not missing anything.
>
> My test server is a departmental-type machine with two Pentium III 450MHz
> CPUs with 512MB of RAM running RedHat Linux 6.1. PGDATA is pointing to a
> RAID 5 array and the database is ~40 MB of data before indexing, and so
> will fit entirely into the db cache. The OS swapfile is not used at all. I
> will be using ODBC to query the database.
>
> 1. The biggest performance item I've seen in looking through the mailing
> lists is the fsync option. I want to leave this enabled as I don't think a
> transactional database should ever lose data. My understanding is that
> with it on PG checkpoints after every commit. Is there a way to let the
> log grow to a certain size before checkpointing? When fsync is off, how is
> data loss possible?
>
> 2. How do I move the log to a different spindle from the disks the
> database data is on?
>
> 3. Any other suggestions are much appreciated.

The speed of fsync is a filesystem issue.

Reiserfs is generally somewhat faster than ext2, and has journaling.
Unfortenately I think the log can only be used for metadata right now -
but you shold check that with the developers.

--
Ragnar Kjørstad

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Mario Simeone 2000-01-30 14:48:42 Triggers on postgres
Previous Message Carlo Perassi 2000-01-30 08:45:42 search engine php3 not case sensitive