Postgres Pro
Downloads
Home   >   mailing lists

vacuum with multiple jobs and a partitioned table - Mailing list pgsql-admin

From Wells Oliver
Subject vacuum with multiple jobs and a partitioned table
Date
Msg-id CAOC+FBX8FzUjzeWo9GgRf8Tf5JNpQmgfzELvNbUBToG=JRokkg@mail.gmail.com
Whole thread Raw
List pgsql-admin
Tree view
I can do: vacuumdb -j 8 mydb

This will go about vacuuming tables and use 8 jobs to do it. Good stuff.

If I have a table which has partitions is there some way of using one command to vacuum its partitions using multiple jobs so it does it concurrently?

--

pgsql-admin by date:

Previous
From: Matt Gibbins
Date:
Subject: Re: Unable to drop extension dblink
Next
From: Rajesh Kumar
Date:
Subject: Unique index