VACUUM problems - Mailing list pgsql-admin

From Martins Zarins
Subject VACUUM problems
Date
Msg-id 3B864390.1648.FC72935@localhost
Whole thread Raw
Responses Re: VACUUM problems  (Tom Lane <tgl@sss.pgh.pa.us>)
Query  (Vida Luz Arista <vlal@ideay.net.ni>)
List pgsql-admin
hello, All !

I'm freshman to this list.

Before version 7.1 there was restriction on SQL tuple length 8-32Kb.
Now I'm using 7.1.2 where iz no such limitations. I have created
some documents database. Theare is table with full text of
documents. Some rows are up to 400Kb lenght. The database is
working just fine, but vacuum crashes all the time after procesing
that full text table. When I deleted all the records from that full text
table, vacuum did correctly.
Right now I'm generating the same table but the text is split into
multiple records each ~8K. I think - it will work.

Maybe that's a bug in vacuum or maybe some misconfiguration (I'm
using default config).
If anyone had similar problems, pls share your ideas and
comments about solution.


Mark

pgsql-admin by date:

Previous
From: Ashish Lahori
Date:
Subject: dumpOneFunc(): procedural language for function listall not found
Next
From: Peter Eisentraut
Date:
Subject: Re: dumpOneFunc(): procedural language for function listall not found