On Wed, 2008-12-31 at 21:45 +0200, Heikki Linnakangas wrote: > > Can I fix? > > Yes please.
Fix attached. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support
Index: src/backend/commands/vacuumlazy.c =================================================================== RCS file: /home/sriggs/pg/REPOSITORY/pgsql/src/backend/commands/vacuumlazy.c,v retrieving revision 1.114 diff -c -r1.114 vacuumlazy.c *** src/backend/commands/vacuumlazy.c 17 Dec 2008 09:15:02 -0000 1.114 --- src/backend/commands/vacuumlazy.c 1 Jan 2009 17:45:29 -0000 *************** *** 183,190 **** * number of pages. Otherwise, the time taken isn't worth it. */ possibly_freeable = vacrelstats->rel_pages - vacrelstats->nonempty_pages; ! if (possibly_freeable >= REL_TRUNCATE_MINIMUM || ! possibly_freeable >= vacrelstats->rel_pages / REL_TRUNCATE_FRACTION) lazy_truncate_heap(onerel, vacrelstats); /* Vacuum the Free Space Map */ --- 183,192 ---- * number of pages. Otherwise, the time taken isn't worth it. */ possibly_freeable = vacrelstats->rel_pages - vacrelstats->nonempty_pages; ! if (vacrelstats->tuples_deleted > 0 && ! (possibly_freeable >= REL_TRUNCATE_MINIMUM || ! (possibly_freeable >= vacrelstats->rel_pages / REL_TRUNCATE_FRACTION && ! possibly_freeable > 0))) lazy_truncate_heap(onerel, vacrelstats); /* Vacuum the Free Space Map */
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
