From: Rosser Schwarz <rschwarz@totalcardinc.com>
To: 'Tom Lane' <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: atrocious update performance
Date: Wed, 17 Mar 2004 12:42:22 -0600
Message-ID: <002b01c40c4f$95d8a750$2500fa0a@CardServices.TCI.com> (raw)
In-Reply-To: <26451.1079546289@sss.pgh.pa.us>
while you weren't looking, Tom Lane wrote:
> Hm. It looks like you mistakenly traced psql rather than the backend,
> but since the delay went away we wouldn't have learned
> anything anyhow.
> Have you got any idea what conditions may have changed between seeing
> delay and not seeing delay?
None, offhand. I have noticed that when a large query is running,
the machine can sporadically just freeze--or at least take inordinately
long for some other process, be it top or ls, another query, or whatever
to start. Nothing looks saturated when it happens, and, while you can
count on it to happen, it's not consistent enough to reproduce.
> This is pretty odd too. It looks like it's doing checkpoints every so
> often (look for the writes to pg_control), which a backend engaged in
> a long-running query surely ought not be doing. Need to think about
> why that might be...
Does the fact that all the reads and writes are 32K mean anything out
of the ordinary? $PGSRC/src/include/pg_config_manual.h has BLCKSZ
#defined to 16384. I was running previously with a 32K BLCKSZ, but
that turned out to be rather sub-optimal for as heavily indexed as our
tables are. I've dumped and rebuilt several times since then.
/rls
--
Rosser Schwarz
Total Card, Inc.
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: rschwarz@totalcardinc.com, tgl@sss.pgh.pa.us
Subject: Re: atrocious update performance
In-Reply-To: <002b01c40c4f$95d8a750$2500fa0a@CardServices.TCI.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