vacuumlo - use a cursor - Mailing list pgsql-hackers

From Andrew Dunstan
Subject vacuumlo - use a cursor
Date
Msg-id 50A174E1.9000503@dunslane.net
Whole thread Raw
Responses Re: vacuumlo - use a cursor  (Bruce Momjian <bruce@momjian.us>)
Re: vacuumlo - use a cursor  (Josh Kupershmidt <schmiddy@gmail.com>)
List pgsql-hackers
vacuumlo is rather simpleminded about dealing with the list of LOs to be
removed - it just fetches them as a straight resultset. For one of my
our this resulted in an out of memory condition. The attached patch
tries to remedy that by using a cursor instead. If this is wanted I will
add it to the next commitfest. The actualy changes are very small - most
of the patch is indentation changes due to the introduction of an extra
loop.

cheers

andrew

Attachment

pgsql-hackers by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Further pg_upgrade analysis for many tables
Next
From: Simon Riggs
Date:
Subject: Re: Further pg_upgrade analysis for many tables