| From: | David Fetter <david(at)fetter(dot)org> |
|---|---|
| To: | Igor Neyman <ineyman(at)perceptron(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: excluding tables from VACUUM ANALYZE |
| Date: | 2008-10-30 14:04:17 |
| Message-ID: | 20081030140417.GQ18097@fetter.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Oct 30, 2008 at 09:17:00AM -0400, Igor Neyman wrote:
> This question didn't get any "traction on "admin" list, so I'll try
> here:
>
> I want to analyze the entire database with the exception of several
> tables. When I run "VACUUM ANALYZE" (or "vacuumdb -z") on the
> database, how can
Why are you doing this in the first place? Autovacuum works just
great for modern PostgreSQL versions, and if you're not using one of
those, you should be planning your migration, not propping up the old
one :)
Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2008-10-30 14:11:13 | Re: Are there plans to add data compression feature to postgresql? |
| Previous Message | David Fetter | 2008-10-30 14:02:45 | Re: Schema Upgrade Howto |