pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mark Kirkwood <markir@paradise.net.nz>
To: Pailloncy Jean-Gérard <pailloncy@gdr-isis.enst.fr>
Cc: pgsql-performance@postgresql.org
Subject: Re: Fwd: FreeBSD, PostgreSQL, semwait and sbwait!
Date: Tue, 04 May 2004 19:39:22 +1200
Message-ID: <409748AA.2030801@paradise.net.nz> (raw)
In-Reply-To: <52623D23-9AA4-11D8-9268-000A95DE2550@gdr-isis.enst.fr>
References: <200403231248.34425.darcy@wavefire.com>
	<40615443.4030003@paradise.net.nz>
	<52623D23-9AA4-11D8-9268-000A95DE2550@gdr-isis.enst.fr>

I am wondering if your wait is caused by contention between 
pg_autovacuum and the DELETE that is running. Your large Pg blocksize 
(32K) *may* be contributing to any possible contention as well. Maybe 
try disabling pg_autovacuum to see if there is any change in behaviour.

Also going through my head is '32 Kb bock's size (to match ffs and raid 
block's size)' - does that mean you have raid strip size = 32K? maybe 
try 128K (I know it sounds like a bad thing, but generally raid stripes 
of 128K->256K are better than 32K->64K)

regards

Mark


Pailloncy Jean-Gérard wrote:

> Hello,
>
>>
> I found the same problem.
>
> I use OpenBSD 3.3,
> On Pentium 2,4 GHz with 1 Gb RAM, RAID 10.
> With PostgreSQL 7.4.1 with 32 Kb bock's size (to match ffs and raid 
> block's size)
> With pg_autovacuum daemon from Pg 7.5.
>
> I run a web indexer.
> sd0 raid-1 with system pg-log and indexer-log
> sd1 raid-10 with pg-data and indexer-data
> The sd1 disk achives between 10 and 40 Mb/s on normal operation.
>
> When I get semwait in top, system waits ;-)
> Not much disk activity.
> Not much log in pg or indexer.
> Just wait....
>



view thread (9+ messages)

Message-ID: <409748AA.2030801@paradise.net.nz>
Permalink:  ../409748AA.2030801@paradise.net.nz/
Also on:    postgresql.org/message-id/409748AA.2030801@paradise.net.nz

 · 

reply

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: markir@paradise.net.nz, pailloncy@gdr-isis.enst.fr
  Subject: Re: Fwd: FreeBSD, PostgreSQL, semwait and sbwait!
  In-Reply-To: <409748AA.2030801@paradise.net.nz>

* 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