| From: | "Martins Zarins" <mark(at)vestnesis(dot)lv> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | VACUUM problems |
| Date: | 2001-08-24 09:07:44 |
| Message-ID: | 3B864390.1648.FC72935@localhost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2001-08-24 11:44:17 | Re: dumpOneFunc(): procedural language for function listall not found |
| Previous Message | Ashish Lahori | 2001-08-24 08:47:32 | dumpOneFunc(): procedural language for function listall not found |