pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedtemplate1 vacuuming consuming much time compared to another production DBs
3+ messages / 2 participants
[nested] [flat]
* template1 vacuuming consuming much time compared to another production DBs
@ 2013-04-22 11:31 pradeep singh <pradeepsingh1988@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: pradeep singh @ 2013-04-22 11:31 UTC (permalink / raw)
To: pgsql-performance
Hi,
I am using postgresql 8.1 DB.
I have a large DB and i run the vacuum every hour with "vocuumdb
--analyze -a" option.
Some times template1 consumes much time in comparison to my own DB.I
think at these times the load on OS is higher. But from iostat logs i
can see that the load on the partition where DB resides is not too
much.
I would like to know why such thing happens?
What are the processing that is carried out with the template1 vacuuming.
When the entries in template1 is updated and inserted?
What should be the frequency of template1 vacuuming?
Is template1 is updated as frequent as my own DB is updated?
Thanks,
Pradeep
--
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] 3+ messages in thread
* Re: template1 vacuuming consuming much time compared to another production DBs
@ 2013-04-22 12:08 Andrew Dunstan <andrew@dunslane.net>
parent: pradeep singh <pradeepsingh1988@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Andrew Dunstan @ 2013-04-22 12:08 UTC (permalink / raw)
To: pradeep singh <pradeepsingh1988@gmail.com>; +Cc: pgsql-performance
On 04/22/2013 07:31 AM, pradeep singh wrote:
> Hi,
>
>
> I am using postgresql 8.1 DB.
Why are you using a release of Postgres that is way out of date and
unsupported?
cheers
andrew
--
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] 3+ messages in thread
* Re: template1 vacuuming consuming much time compared to another production DBs
@ 2013-04-23 01:49 pradeep singh <pradeepsingh1988@gmail.com>
parent: Andrew Dunstan <andrew@dunslane.net>
0 siblings, 0 replies; 3+ messages in thread
From: pradeep singh @ 2013-04-23 01:49 UTC (permalink / raw)
To: ; +Cc: pgsql-performance
I am using this DB since last 3 or 4 years. And suddenly we can't update it.
We are planning it at the end of year. Recently we faced the template1
wraparound issue. So we added template1 also for vacuuming. We are
vacuuming the DB each hour with 'vacuumdb --analyze -a' options.
Now the vacuuming of template1 consumes time. And the queries become slow.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2013-04-23 01:49 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-04-22 11:31 template1 vacuuming consuming much time compared to another production DBs pradeep singh <pradeepsingh1988@gmail.com>
2013-04-22 12:08 ` Andrew Dunstan <andrew@dunslane.net>
2013-04-23 01:49 ` pradeep singh <pradeepsingh1988@gmail.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