From: Richard Huxton <dev@archonet.com>
To: Steinar H. Gunderson <sgunderson@bigfoot.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: WAL sync behaviour
Date: Thu, 10 Nov 2005 14:14:30 +0000
Message-ID: <437355C6.4030604@archonet.com> (raw)
In-Reply-To: <20051110133241.GA4031@uio.no>
References: <20051110133241.GA4031@uio.no>
Steinar H. Gunderson wrote:
> Hi,
>
> We're having problems with our PostgreSQL server using forever for simple
> queries, even when there's little load -- or rather, the transactions seem
> to take forever to commit. We're using 8.1 (yay!) on a single Opteron, with
> WAL on the system two-disk (software) RAID-1, separate from the database
> four-disk RAID-10. All drives are 10000rpm SCSI disks, with write cache
> turned off; we value our data :-) We're running Linux 2.6.13.4, with 64-bit
> kernel but 32-bit userspace.
You're beyond my area of expertise, but I do know that someone's going
to ask what filesystem this is (ext2/xfs/etc). And probably to see the
strace too.
Hmm - the only things I can think to check:
Do vmstat/iostat show any unusual activity?
Are your system logs on these disks too?
Could it be the journalling on the fs clashing with the WAL?
--
Richard Huxton
Archonet Ltd
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dev@archonet.com, sgunderson@bigfoot.com
Subject: Re: WAL sync behaviour
In-Reply-To: <437355C6.4030604@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox