Re: [PERFORM] Curious about dead rows.

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Scott Marlowe wrote: > On Nov 10, 2007 1:57 PM, Jean-David Beyer <[EMAIL PROTECTED]> wrote: >> Joshua D. Drake wrote: >>> Truncate will not create dead rows. However ROLLBACK will. Are you >>> getting any duplicate key errors or anything like that when

Re: [PERFORM] Curious about dead rows.

On Nov 10, 2007 1:57 PM, Jean-David Beyer <[EMAIL PROTECTED]> wrote: > > Joshua D. Drake wrote: > > > > Truncate will not create dead rows. However ROLLBACK will. Are you > > getting any duplicate key errors or anything like that when you insert? > > > On the mistaken assumption that TRUNCATE left

Re: [PERFORM] Curious about dead rows.

Joshua D. Drake wrote: > On Sat, 10 Nov 2007 13:38:23 -0500 Jean-David Beyer > <[EMAIL PROTECTED]> wrote: > >>> Tom Lane wrote: Jean-David Beyer <[EMAIL PROTECTED]> writes: > I am doing lots of INSERTs on a table that starts out empty (I > did a TRUNCATE on it). I am not, AFAIK, doing

Re: [PERFORM] Curious about dead rows.

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sat, 10 Nov 2007 13:38:23 -0500 Jean-David Beyer <[EMAIL PROTECTED]> wrote: > Tom Lane wrote: > > Jean-David Beyer <[EMAIL PROTECTED]> writes: > >> I am doing lots of INSERTs on a table that starts out empty (I did > >> a TRUNCATE on it). I am not,

Re: [PERFORM] Curious about dead rows.

Tom Lane wrote: > Jean-David Beyer <[EMAIL PROTECTED]> writes: >> I am doing lots of INSERTs on a table that starts out empty (I did a >> TRUNCATE on it). I am not, AFAIK, doing DELETEs or UPDATEs. Autovacuum is >> on. I moved logging up to debug2 level to see what was going on, and I get >> things

Re: [PERFORM] Curious about dead rows.

Jean-David Beyer <[EMAIL PROTECTED]> writes: > I am doing lots of INSERTs on a table that starts out empty (I did a > TRUNCATE on it). I am not, AFAIK, doing DELETEs or UPDATEs. Autovacuum is > on. I moved logging up to debug2 level to see what was going on, and I get > things like this: > "vl_as

[PERFORM] Curious about dead rows.

I am doing lots of INSERTs on a table that starts out empty (I did a TRUNCATE on it). I am not, AFAIK, doing DELETEs or UPDATEs. Autovacuum is on. I moved logging up to debug2 level to see what was going on, and I get things like this: "vl_as": scanned 3000 of 5296 pages, containing 232944 live r