Re: [HACKERS] [PATCHES] Trivial patch to double vacuum speed

2006-09-04 Thread Hannu Krosing
Ühel kenal päeval, E, 2006-09-04 kell 16:51, kirjutas Joshua D. Drake: > > I don't have a concrete proposal to make, but I do think that the > > current patch-queue process is not suited to the project as it stands > > today. Maybe if this issue-tracking stuff gets off the ground, we > > could let

Re: [HACKERS] [PATCHES] Trivial patch to double vacuum speed

2006-09-04 Thread Joshua D. Drake
Gavin Sherry wrote: On Mon, 4 Sep 2006, Joshua D. Drake wrote: I don't have a concrete proposal to make, but I do think that the current patch-queue process is not suited to the project as it stands today. Maybe if this issue-tracking stuff gets off the ground, we could let developers place AC

Re: [HACKERS] [PATCHES] Trivial patch to double vacuum speed

2006-09-04 Thread Gavin Sherry
On Mon, 4 Sep 2006, Joshua D. Drake wrote: > > > I don't have a concrete proposal to make, but I do think that the > > current patch-queue process is not suited to the project as it stands > > today. Maybe if this issue-tracking stuff gets off the ground, we > > could let developers place ACK or

Re: [HACKERS] [PATCHES] Trivial patch to double vacuum speed

2006-09-04 Thread Tom Lane
"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > How about *requiring* test cases that prove the patch? There are lots and lots of things that can't really be tested with pg_regress-based tests, and in any case a test does not prove the absence of bugs; particularly not a test devised by the code a

Re: [HACKERS] [PATCHES] Trivial patch to double vacuum speed

2006-09-04 Thread Bruce Momjian
Joshua D. Drake wrote: > > > I don't have a concrete proposal to make, but I do think that the > > current patch-queue process is not suited to the project as it stands > > today. Maybe if this issue-tracking stuff gets off the ground, we > > could let developers place ACK or NAK flags on patches

Re: [HACKERS] [PATCHES] Trivial patch to double vacuum speed

2006-09-04 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Alvaro Herrera wrote: > >> This rush to apply patches just because no one seems to be capable of > >> keeping up with them not being reviewed, is starting to get a bit > >> worrisome. > > > When things are placed in the patches queue,

Re: [HACKERS] [PATCHES] Trivial patch to double vacuum speed

2006-09-04 Thread Joshua D. Drake
I don't have a concrete proposal to make, but I do think that the current patch-queue process is not suited to the project as it stands today. Maybe if this issue-tracking stuff gets off the ground, we could let developers place ACK or NAK flags on patches they've looked at, and have some rule

Re: [HACKERS] [PATCHES] Trivial patch to double vacuum speed

2006-09-04 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Alvaro Herrera wrote: >> This rush to apply patches just because no one seems to be capable of >> keeping up with them not being reviewed, is starting to get a bit >> worrisome. > When things are placed in the patches queue, I need to get feedback if > t

Re: [HACKERS] [PATCHES] Trivial patch to double vacuum speed

2006-09-04 Thread Bruce Momjian
Alvaro Herrera wrote: > > > I see the no-index case now: > > > > > > + if (nindexes) > > > + LockBuffer(buf, BUFFER_LOCK_SHARE); > > > + else > > > + LockBufferForCleanup(buf); > > > > > > Let's see what Greg says, or revert. >

Re: [HACKERS] [PATCHES] Trivial patch to double vacuum speed on tables with no indexes

2006-09-04 Thread Alvaro Herrera
Gregory Stark wrote: > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > Tom Lane wrote: > >> Bruce Momjian <[EMAIL PROTECTED]> writes: > >> > Patch applied. Thanks. > >> > >> Wait a minute. This patch changes the behavior so that > >> LockBufferForCleanup is applied to *every* heap page, not

Re: [HACKERS] [PATCHES] Trivial patch to double vacuum speed on tables with no indexes

2006-09-04 Thread Gregory Stark
Bruce Momjian <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Bruce Momjian <[EMAIL PROTECTED]> writes: >> > Patch applied. Thanks. >> >> Wait a minute. This patch changes the behavior so that >> LockBufferForCleanup is applied to *every* heap page, not only the ones >> where there are remov

Re: [HACKERS] [PATCHES] Trivial patch to double vacuum speed

2006-09-04 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Patch applied. Thanks. > > Wait a minute. This patch changes the behavior so that > LockBufferForCleanup is applied to *every* heap page, not only the ones > where there are removable tuples. It's not hard to imagine scenarios > w

Re: [HACKERS] [PATCHES] Trivial patch to double vacuum speed on tables with no indexes

2006-09-04 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Patch applied. Thanks. Wait a minute. This patch changes the behavior so that LockBufferForCleanup is applied to *every* heap page, not only the ones where there are removable tuples. It's not hard to imagine scenarios where that results in severe sy

Re: [HACKERS] [PATCHES] Trivial patch to double vacuum speed

2006-09-04 Thread Bruce Momjian
Patch applied. Thanks. --- Gregory Stark wrote: > > Tom Lane <[EMAIL PROTECTED]> writes: > > > The reason the patch is so short is that it's a kluge. If we really > > cared about supporting this case, more wide-ranging

Re: [HACKERS] [PATCHES] Trivial patch to double vacuum speed on tables with no indexes

2006-08-28 Thread Alvaro Herrera
Gregory Stark wrote: > > Tom Lane <[EMAIL PROTECTED]> writes: > > > The reason the patch is so short is that it's a kluge. If we really > > cared about supporting this case, more wide-ranging changes would be > > needed (eg, there's no need to eat maintenance_work_mem worth of RAM > > for the de

Re: [HACKERS] [PATCHES] Trivial patch to double vacuum speed on tables with no indexes

2006-08-28 Thread Gregory Stark
Tom Lane <[EMAIL PROTECTED]> writes: > The reason the patch is so short is that it's a kluge. If we really > cared about supporting this case, more wide-ranging changes would be > needed (eg, there's no need to eat maintenance_work_mem worth of RAM > for the dead-TIDs array); and a decent respec

Re: [HACKERS] [PATCHES] Trivial patch to double vacuum speed on tables with no indexes

2006-08-27 Thread Tom Lane
Gregory Stark <[EMAIL PROTECTED]> writes: > Tom Lane <[EMAIL PROTECTED]> writes: >> How often does that case come up in the real world, for tables that are >> large enough that you'd care about vacuum performance? > I would have had the same objection if it resulted in substantially more > complex

Re: [HACKERS] [PATCHES] Trivial patch to double vacuum speed on tables with no indexes

2006-08-27 Thread Gregory Stark
Tom Lane <[EMAIL PROTECTED]> writes: > stark <[EMAIL PROTECTED]> writes: >> There isn't really any need for the second pass in lazy vacuum if the table >> has no indexes. > > How often does that case come up in the real world, for tables that are > large enough that you'd care about vacuum perfor

Re: [HACKERS] [PATCHES] Trivial patch to double vacuum speed on tables with no indexes

2006-08-27 Thread Tom Lane
stark <[EMAIL PROTECTED]> writes: > There isn't really any need for the second pass in lazy vacuum if the table > has no indexes. How often does that case come up in the real world, for tables that are large enough that you'd care about vacuum performance? regards, tom lan