pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Is any effect other process performance after vaccumdb finished ? 2+ messages / 2 participants [nested] [flat]
* Is any effect other process performance after vaccumdb finished ? @ 2011-05-27 01:58 Junghwe Kim <junghwe.kim76@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: Junghwe Kim @ 2011-05-27 01:58 UTC (permalink / raw) To: pgsql-performance Hi. First extremely thanks for your works about postgresql . I wonder that after executing 'vaccumdb -z' some other process can not read their own msg queue during 2 ~ 3 minuts. vaccum executed every hour. and The processes have not any relations between postgreql. Is it possible ? ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Is any effect other process performance after vaccumdb finished ? @ 2011-05-27 03:31 Craig Ringer <craig@postnewspapers.com.au> parent: Junghwe Kim <junghwe.kim76@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Craig Ringer @ 2011-05-27 03:31 UTC (permalink / raw) To: Junghwe Kim <junghwe.kim76@gmail.com>; +Cc: pgsql-performance On 27/05/2011 9:58 AM, Junghwe Kim wrote: > Hi. > > First extremely thanks for your works about postgresql . > > I wonder that after executing 'vaccumdb -z' some other process can not > read their own msg queue during 2 ~ 3 minuts. The most likely cause is checkpoint activity. Enable checkpoint logging and examine your server logs. > vaccum executed every hour. and The processes have not any relations > between postgreql. Instead of running vacuum from cron or some other scheduler, turn on autovacuum and set it to run aggressively. You will reduce the impact of vacuum if you run it *often* (every few minutes if not more frequently) and do so using autovacuum. Best results will be had on PostgreSQL 8.4 or above. Please read this if you need to follow up, so you include enough information that a more complete answer can be given: http://wiki.postgresql.org/wiki/Guide_to_reporting_problems -- Craig Ringer Tech-related writing at http://soapyfrogs.blogspot.com/ ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2011-05-27 03:31 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2011-05-27 01:58 Is any effect other process performance after vaccumdb finished ? Junghwe Kim <junghwe.kim76@gmail.com> 2011-05-27 03:31 ` Craig Ringer <craig@postnewspapers.com.au>
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