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: Pages %u; Tuples %.0f.
and should appear in the part of t
On Fri, Dec 05, 2003 at 09:54:52PM -0500, Robert Treat wrote:
>...
> A vacuum verbose could give you a good indication if you need to reindex,
> compare the # of pages in the index with the # in the table.
Hmmm, I have a feeling that's not as obvious as I thought... I can't
identify the index (
On Fri, Dec 05, 2003 at 09:54:52PM -0500, Robert Treat wrote:
> On Friday 05 December 2003 16:51, Steve Wampler wrote:
> > I need some help tracking down a sudden, massive slowdown
> > in inserts in one of our databases.
> >
> > PG: 7.2.3 (RedHat 8.0)
> >
> > Background. We currently run nearly i
On Friday 05 December 2003 16:51, Steve Wampler wrote:
> I need some help tracking down a sudden, massive slowdown
> in inserts in one of our databases.
>
> PG: 7.2.3 (RedHat 8.0)
>
> Background. We currently run nearly identical systems
> at two sites: Site A is a 'lab' site used for development