for table in $(psql -U postgres --tuples-only -c "SELECT schemaname || '.' || tablename FROM pg_tables WHERE tablename NOT IN ('table1', 'table2')") ; do psql -U postgres -c "VACUUM ANALYZE $table"; done
This is nice because you can bring all kinds of awk/sed/grep to bear on your problems.
On Thu, Oct 30, 2008 at 9:17 AM, Igor Neyman <ineyman@xxxxxxxxxxxxxx> 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 I exclude specific tables from being analyzed?
Is there any place in system dictionary, where the table could be marked , so it's not processed (skipped) by "vacuum analyze"?Igor
