-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Scott Marlowe wrote: > On Nov 10, 2007 1:57 PM, Jean-David Beyer <jeandavid8@xxxxxxxxxxx> 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 dead rows, I did a >> VACUUM FULL ANALYZE before running the program full of INSERTs. This did not >> make any difference. >> >> As far as ROLLBACK are concerned, every one is immediately preceded by a >> message output to the standard error file, and no such messages are produced. > > So, there are NO failed inserts, and no updates? Cause that's what > I'd expect to create the dead rows. > So would I. Hence the original question. - -- .~. Jean-David Beyer Registered Linux User 85642. /V\ PGP-Key: 9A2FC99A Registered Machine 241939. /( )\ Shrewsbury, New Jersey http://counter.li.org ^^-^^ 21:20:01 up 18 days, 14:38, 0 users, load average: 4.38, 4.40, 4.31 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with CentOS - http://enigmail.mozdev.org iD8DBQFHNmeBPtu2XpovyZoRAqxzAJ9wLNf7Y9egSd/COtMjWaqKWfJXowCfdDj7 HEulOz8v4DKtAqWCGTf/22Y= =79AU -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
