Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: questions on toast tables
- 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: Fri, 28 Apr 2006 14:17:08 -0600
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
- References:
- questions on toast tables
- From: Warren Little
- Re: questions on toast tables
- From: Tom Lane
- questions on toast tables
- Prev by Date: Re: questions on toast tables
- Next by Date: Re: Backing up large databases
- Previous by thread: Re: questions on toast tables
- Next by thread: Re: questions on toast tables
- Indexes: