On Sep 9, 2015, at 3:43 AM, anil7385 <anilnk7...@gmail.com> wrote: > > Hi, > We have a table which consists of 3 millions of records and when we try to > delete them and run VACUUM VERBOSE ANALYZE on it in production environment , > it takes 6/7 hours to process.
You make it sound like you are deleting all records. If that's true, why not TRUNCATE? It'll be a lot faster, and also leave you with no need to vacuum. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance