Is this fixed? ---------------------------------------------------------------------------
Tom Lane wrote: > "˙ffffce˙ffffac" "˙ffffbd˙ffffaa" <[EMAIL PROTECTED]> writes: > > --- Alvaro Herrera <[EMAIL PROTECTED]> wrote: > >> Huh, so what kind of operations did you execute > >> within the transaction? > > > There are 1600 tables in database 'db1', I wrote a > > pl/pgsql function "update_tables" like > > > " > > FOR table IN SELECT relname FROM pg_class > > LOOP > > ... > > DROP INDEX ON ... ; > > ALTER TABLE DROP CONSTRAINT ...; > > ... > > CREATE INDEX xxx ON TABLE xxx; > > ... > > ALTER TABLE xxx ADD PRIMARY KEY... > > ALTER TABLE xxx ADD ... > > ... > > END LOOP > > Okay, so it was the number-of-deleted-files issue and not the > number-of-subtransactions issue. Still says we have to allow > commit records to be bigger than 64K ... > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
