Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory)

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Pailloncy Jean-Gerard <pailloncy(at)ifrance(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory)
Date: 2004-12-17 18:15:54
Message-ID: 200412171015.54670.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Stark 2004-12-17 18:24:33 Re: Seqscan rather than Index
Previous Message Pailloncy Jean-Gerard 2004-12-17 17:58:21 Error in VACUUM FULL VERBOSE ANALYZE (not enough memory)