From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-performance@postgresql.org
Subject: Re: Curious about dead rows.
Date: Tue, 13 Nov 2007 17:10:28 -0500
Message-ID: <20071113221028.GH11563@crankycanuck.ca> (raw)
In-Reply-To: <473A1DC3.3070608@verizon.net>
References: <20071112171805.GQ32349@crankycanuck.ca>
<47389504.4020700@verizon.net>
<20071112185218.GS32349@crankycanuck.ca>
<4738A2EC.9090500@verizon.net>
<20071112190833.GY32349@crankycanuck.ca>
<4739BD65.9070605@verizon.net>
<20071113152111.GG11563@crankycanuck.ca>
<473A0023.5020609@verizon.net>
<20071113213510.GF11563@crankycanuck.ca>
<473A1DC3.3070608@verizon.net>
I'm not a private support organisation; please send your replies to the
list, not me.
On Tue, Nov 13, 2007 at 04:57:23PM -0500, Jean-David Beyer wrote:
> What is it controlled by? The following are the non-default values in
> postgresql.conf:
>
> redirect_stderr = on
> log_directory = '/srv/dbms/dataB/pgsql/pg_log'
> log_filename = 'postgresql-%a.log'
> log_truncate_on_rotation = on
> log_rotation_age = 1440
> log_rotation_size = 0
> log_min_messages = debug2
This will certainly include error messages, then. Or it ought to. You do
see errors in the log when you create one, right? (Try causing an error in
psql to make sure.)
> log_line_prefix = '%t '
> log_statement = 'none' (this was 'mod', but it uses too much
> disk to leave it turned on -- only
> 4 GBytes in that partition)
>
> >
> They are; they are the primary keys of two tables. But those are all done
> before the last VACUUM FULL ANALYZE runs, so the dead rows should have been
> eliminated. And the output of the sequence is the only way of generating a
> primary key, so it should be impossible anyhow.
I thought you were doing INSERTs? It's not true that the output of the
sequence is the only way -- if you insert directly, it will happily insert
into that column. But it should cause an error to show in the log, which is
what's puzzling me.
A
--
Andrew Sullivan
Old sigs will return after re-constitution of blue smoke
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: ajs@crankycanuck.ca
Subject: Re: Curious about dead rows.
In-Reply-To: <20071113221028.GH11563@crankycanuck.ca>
* 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