Postgres Pro
Downloads
Home   >   mailing lists

Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory) - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory)
Date
Msg-id 200412171015.54670.josh@agliodbs.com
Whole thread Raw
In response to Error in VACUUM FULL VERBOSE ANALYZE (not enough memory)  (Pailloncy Jean-Gerard <pailloncy@ifrance.com>)
Responses Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Pailloncy Jean-Gerard
Date:
Subject: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory)
Next
From: Greg Stark
Date:
Subject: Re: Seqscan rather than Index