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

From: Pailloncy Jean-Gerard <pailloncy(at)ifrance(dot)com>
To: josh(at)agliodbs(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:25:29
Message-ID: 07F4E72A-5059-11D9-96E2-000A95DE2550@ifrance.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>> 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

In response to

Responses

Browse pgsql-performance by date

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