I have a table with an tsearch2 full text index on PG 7.4.2. And a query against the index is really slow. I try to do a "VACUUM FULL VERBOSE ANALYZE pkpoai.metadata" and I got an error. I monitor memory usage with top, and pg backend uses more and more memory and hits the limit of 1GB of RAM use.
What is your VACUUM_MEM set to in postgresql.conf?
vacuum_mem = 131072 I have 1 GB of RAM. There was only one running backend.
Cordialement, Jean-Gérard Pailloncy
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
