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

From: Pailloncy Jean-Gerard <jg(at)rilk(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: Josh Berkus <josh(at)agliodbs(dot)com>
Subject: Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory)
Date: 2004-12-17 18:32:24
Message-ID: FED87045-5059-11D9-96E2-000A95DE2550@rilk.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

The classic output from top (during all other index vacuum):
PID UID PRI NICE SIZE RES STATE WAIT TIME CPU COMMAND
20461 503 14 0 13M 75M sleep semwai 5:27 2.05% postgres

When backend hits the tsearch2 index, SIZE/RES grows until it reachs
1GB, where I got the error.
PID UID PRI NICE SIZE RES STATE WAIT TIME CPU COMMAND
20461 503 -5 0 765M 824M sleep biowai 4:26 33.20% postgres

Cordialement,
Jean-Gérard Pailloncy

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2004-12-17 18:36:52 Re: Seqscan rather than Index
Previous Message Pailloncy Jean-Gerard 2004-12-17 18:25:29 Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory)