Re: [ADMIN] Errors while vacuuming large tables

2002-10-15 Thread Jeff Boes
On Mon, 14 Oct 2002 11:13:46 -0400, Jeff Boes wrote: > ERROR: cannot open segment 1 of relation table_D (target block > 2337538109): No such file or directory > > and for table B: > > NOTICE: Child itemid in update-chain marked as unused - can't continue > repair_frag > ERROR: cannot open se

Re: [ADMIN] Errors while vacuuming large tables

2002-10-14 Thread Tom Lane
Jeff Boes <[EMAIL PROTECTED]> writes: > We expire rows by a datestamp from a few fairly large tables in our > schema (running 7.2.1). > Recently, we get this message quite often on > table A: > ERROR: Parent tuple was not found Please update to 7.2.3 and see if things get better. Also, if you

[ADMIN] Errors while vacuuming large tables

2002-10-14 Thread Jeff Boes
We expire rows by a datestamp from a few fairly large tables in our schema (running 7.2.1). Table A: 140 Krows, 600 MB Table B: 100 Krows, 2.7 GB Table C: 140 Krows, 2.7 GB Table D: 3.2 Mrows, 500 MB so that something like 15-20% of each table is deleted at a crack (done on a weekend, of course)