On Sep 9, 2015, at 3:43 AM, anil7385 <anilnk7385(at)gmail(dot)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.