pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedVACUUM VERBOSE ANALYZE taking long time to process.
2+ messages / 2 participants
[nested] [flat]
* VACUUM VERBOSE ANALYZE taking long time to process.
@ 2015-09-09 10:43 anil7385 <anilnk7385@gmail.com>
2015-09-15 23:52 ` Re: VACUUM VERBOSE ANALYZE taking long time to process. Ben Chobot <bench@silentmedia.com>
0 siblings, 1 reply; 2+ messages in thread
From: anil7385 @ 2015-09-09 10:43 UTC (permalink / raw)
To: pgsql-performance
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.
our understanding is that ,there are other processes running in the prod
environment which may acquire lock on this table and due to this vacuum
keeps waiting continuously for getting lock and due to this it takes long
time to finish .
can any body suggest me a solution by which we can reduce the time to 1 to 2
hours ?
please reply me on this with your suggestions .
--
View this message in context: http://postgresql.nabble.com/VACUUM-VERBOSE-ANALYZE-taking-long-time-to-process-tp5865303.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: VACUUM VERBOSE ANALYZE taking long time to process.
2015-09-09 10:43 VACUUM VERBOSE ANALYZE taking long time to process. anil7385 <anilnk7385@gmail.com>
@ 2015-09-15 23:52 ` Ben Chobot <bench@silentmedia.com>
0 siblings, 0 replies; 2+ messages in thread
From: Ben Chobot @ 2015-09-15 23:52 UTC (permalink / raw)
To: anil7385 <anilnk7385@gmail.com>; +Cc: pgsql-performance
On Sep 9, 2015, at 3:43 AM, anil7385 <anilnk7385@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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2015-09-15 23:52 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-09-09 10:43 VACUUM VERBOSE ANALYZE taking long time to process. anil7385 <anilnk7385@gmail.com>
2015-09-15 23:52 ` Ben Chobot <bench@silentmedia.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox