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

Reply via email to