Re: index bloat

From: "David Esposito" <pgsql-general(at)esposito(dot)newnetco(dot)com>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: index bloat
Date: 2005-07-08 14:37:20
Message-ID: 200507081437.j68EbKrV027836@relay1.nnco.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: Friday, July 08, 2005 9:52 AM
>
> "David Esposito" <pgsql-general(at)esposito(dot)newnetco(dot)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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marc G. Fournier 2005-07-08 14:57:18 Re: mail change for list?
Previous Message Bruno Wolff III 2005-07-08 14:12:58 Re: Why UPDATE gl SET gl.glnum = gl.glnum; cause error when UPDATE gl SET glnum = glnum; is OK ?