Jean-Gerard, > 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? -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings