Re: [PERFORM] tuning questions

2003-12-08 Thread Tom Lane
Jack Coates <[EMAIL PROTECTED]> writes: > Theories at this point, in no particular order: > a) major differences between my 7.3.4 from source (compiled with no > options) and dev's 7.3.2-1PGDG RPMs. Looking at the spec file doesn't > reveal anything glaring to me, but is there something I'm missin

Re: [PERFORM] autovacuum daemon stops doing work after about an hour

2003-12-08 Thread Vivek Khera
> "MTO" == Matthew T O'Connor <[EMAIL PROTECTED]> writes: MTO> Yeah, FreeBSD testing would have been nice, but I don't have access to MTO> any FreeBSD boxes so. FWIW, with the fflush() added after that sleep, and the fix to the long long computation of sleep time to keep it from overflowi

Re: [PERFORM] tuning questions

2003-12-08 Thread Jack Coates
On Fri, 2003-12-05 at 17:22, Jack Coates wrote: ... > That's it, I'm throwing out this whole test series and starting over > with different hardware. Database server is now a dual 2GHz Xeon with > 2GB RAM & 2940UW SCSI, OS and PG's logs on 36G drive, PG data on 9GB > drive. Data is importing now an

Re: [PERFORM] Help tracking down problem with inserts slowing

2003-12-08 Thread Tom Lane
Steve Wampler <[EMAIL PROTECTED]> writes: > Thanks, Tom. Are there any reasons why it would not appear?: Oh, I shoulda read the code more carefully. I was looking at the bottom of lazy_scan_index, where the printout is done, and failed to notice the test at the top: /* * If the index i

Re: [PERFORM] Help tracking down problem with inserts slowing

2003-12-08 Thread Steve Wampler
On Sun, 2003-12-07 at 09:52, Tom Lane wrote: > Steve Wampler <[EMAIL PROTECTED]> writes: > > Hmmm, I have a feeling that's not as obvious as I thought... I can't > > identify the index (named 'id_index') in the output of vacuum verbose. > > In 7.2, the index reports look like > Index %s: Pa