By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,903 Members | 1,067 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,903 IT Pros & Developers. It's quick & easy.

VACUUMING questions...

P: n/a
Hello all,
I have a few somewhat simple questions....

Does the postmaster vacuum it's internal (pg_*) tables?
if not
what is the best way to vacuum them without having to vacuum the
entire db?
and how often is this recommended to be done?

Thanks,

-Joe

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 23 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Joe Maldonado wrote:
Hello all,
I have a few somewhat simple questions....

Does the postmaster vacuum it's internal (pg_*) tables? if not
what is the best way to vacuum them without having to vacuum the
entire db?
and how often is this recommended to be done?


No, and I'd vacuum full template1.

How often? Depends on how much activity you've got on your system
tables. If you look at the output on vacuum verbose you can see how much
work it has to do.
--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 23 '05 #2

P: n/a
Richard Huxton wrote:
Joe Maldonado wrote:
Hello all,
I have a few somewhat simple questions....

Does the postmaster vacuum it's internal (pg_*) tables? if not
what is the best way to vacuum them without having to vacuum the
entire db?
and how often is this recommended to be done?

No, and I'd vacuum full template1.


I'm not sure what you mean by No. If I fun a vacuum command from psql
inside one of my databases, then all the pg_ tables will get vacuumed.
Also, vacuum full on template1 is only going to help with the small
handful of shared tables. Most of the pg_ tables are not shared, so
vacuuming them inside template1 is not going to help the their
performance inside a particular DB.

How often? Depends on how much activity you've got on your system
tables. If you look at the output on vacuum verbose you can see how
much work it has to do.

You can also run pg_autovacuum which does monitor activity for you and
does vacuum system tables.

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #3

P: n/a
Matthew T. O'Connor wrote:
Richard Huxton wrote:
Joe Maldonado wrote:
Hello all,
I have a few somewhat simple questions....

Does the postmaster vacuum it's internal (pg_*) tables? if not
what is the best way to vacuum them without having to vacuum the
entire db?
and how often is this recommended to be done?


No, and I'd vacuum full template1.

I'm not sure what you mean by No.


I'd read the question as asking if they got dealt with automatically,
without sysadmin involvement.

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.