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
I generally write bash one liners for this kind of thing:
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
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 syste
