| From: | Warren Little <warren(dot)little(at)meridiascapital(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: questions on toast tables |
| Date: | 2006-04-28 20:17:08 |
| Message-ID: | 1146255429.16696.10.camel@wlittle.meridias.local |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Tom,
I'll run the vacuum over the weekend and see how that goes.
And, yes, large pdf documents (4-24mb a piece).
thanks
On Fri, 2006-04-28 at 16:03 -0400, Tom Lane wrote:
> Warren Little <warren(dot)little(at)meridiascapital(dot)com> writes:
> > 3) I know that once upon a time the table had a bytea column, but that
> > was dropped. Do I need to do a full vacuum on that table to get rid of
> > the related toast data?
>
> Yup. (I take it it was a pretty darn bulky bytea column, too)
>
> regards, tom lane
--
Warren Little
Chief Technology Officer
Meridias Capital Inc
1018 W Atherton Dr
Salt Lake City, UT 84123
ph: 866.369.7763
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rafael Martinez | 2006-04-28 21:56:18 | Re: Backing up large databases |
| Previous Message | Tom Lane | 2006-04-28 20:03:55 | Re: questions on toast tables |