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