Re: index bloat - Mailing list pgsql-general

From David Esposito
Subject Re: index bloat
Date
Msg-id 200507081437.j68EbKrV027836@relay1.nnco.com
Whole thread Raw
In response to Re: index bloat  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Sure thing ... I turned on VERBOSE so I'll let it run for the next few days
(the weekend is kind of a bad time since activity on the database is low)
but by monday or tuesday I should have a few nightly runs to post to the
list ..

Thanks,
Dave

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Friday, July 08, 2005 9:52 AM
>
> "David Esposito" <pgsql-general@esposito.newnetco.com> writes:
> > Hmm, how are you getting 1/6? The ballpark seems to be
> about 50% or more for
> > those first 4 ...
>
> Ooops, I got confused about which column was which.
>
> Could we see the results of "vacuum verbose" on this table?  Even
> better, verbose output from two successive nightly runs?
>
>             regards, tom lane
>


pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Why UPDATE gl SET gl.glnum = gl.glnum; cause error when UPDATE gl SET glnum = glnum; is OK ?
Next
From: "Marc G. Fournier"
Date:
Subject: Re: mail change for list?