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
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
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
> "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
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
