| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | vacuumlo - use a cursor |
| Date: | 2012-11-12 22:14:57 |
| Message-ID: | 50A174E1.9000503@dunslane.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 | Content-Type | Size |
|---|---|---|
| vacuumlo-cursor.patch | text/x-patch | 4.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2012-11-12 22:17:17 | Re: Further pg_upgrade analysis for many tables |
| Previous Message | Jeff Janes | 2012-11-12 21:54:28 | Re: Further pg_upgrade analysis for many tables |