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

From: Tom Lane
Subject: Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory)
Date: ,
Msg-id: 24692.1103322047@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory)  (Pailloncy Jean-Gerard)
Responses: Re: Memory leak tsearch2 VACUUM FULL VERBOSE ANALYZE  (Pailloncy Jean-Gerard)
List: pgsql-performance

Tree view

Error in VACUUM FULL VERBOSE ANALYZE (not enough memory)  (Pailloncy Jean-Gerard, )
 Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory)  (Josh Berkus, )
  Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory)  (Pailloncy Jean-Gerard, )
   Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory)  (Pailloncy Jean-Gerard, )
    Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory)  (Josh Berkus, )
     Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory)  (Tom Lane, )
      Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory)  (Josh Berkus, )
       Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory)  (Tom Lane, )
      Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory)  (Bruno Wolff III, )
       Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory)  (Tom Lane, )
 Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory)  (Pailloncy Jean-Gerard, )
  Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory)  (Tom Lane, )
   Re: Memory leak tsearch2 VACUUM FULL VERBOSE ANALYZE  (Pailloncy Jean-Gerard, )
    Re: Memory leak tsearch2 VACUUM FULL VERBOSE ANALYZE  (Tom Lane, )
    Re: Memory leak tsearch2 VACUUM FULL VERBOSE ANALYZE  (Tom Lane, )

Pailloncy Jean-Gerard <> writes:
> Update to my case:
> I drop and recreate the index and there was no problem this time.
> Strange...

Well, that time there wasn't actually any work for VACUUM FULL to do.
I think the bloat is probably driven by having to move a lot of rows
in order to shrink the table.  That means creating and deleting a lot
of index entries.

            regards, tom lane


pgsql-performance by date:

From: Christopher Browne
Date:
Subject: Re: Which is more efficient?
From: Bruno Wolff III
Date:
Subject: Re: Seqscan rather than Index