On Sep 9, 2015, at 3:43 AM, anil7385 <anilnk7385@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
