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

vacuum schema

P: n/a
Is there a way to vacuum all tables in a schema? Or will I need to
write a script to do it?

-Josh

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

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


P: n/a
Are you looking for something different than vacuumdb?

http://www.postgresql.org/docs/7.4/s...-vacuumdb.html

-tfo

On Oct 18, 2004, at 3:23 PM, Josh Close wrote:
Is there a way to vacuum all tables in a schema? Or will I need to
write a script to do it?

-Josh

---------------------------(end of
broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #2

P: n/a
On Mon, 18 Oct 2004 15:35:53 -0500, Thomas F. O'Connell
<tf*@sitening.com> wrote:
Are you looking for something different than vacuumdb?

http://www.postgresql.org/docs/7.4/s...-vacuumdb.html

-tfo


I think so. As far as I can tell, you can either vacuum a whole db, or
individual tables. But not a whole schema.

-Josh

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 23 '05 #3

P: n/a
Ah, yes. You're right.

Presumably you could use the hidden query from \dn in psql to get the
tables necessary for a script. That's the next best thing I can think
of.

-tfo

On Oct 18, 2004, at 6:02 PM, Josh Close wrote:
On Mon, 18 Oct 2004 15:35:53 -0500, Thomas F. O'Connell
<tf*@sitening.com> wrote:
Are you looking for something different than vacuumdb?

http://www.postgresql.org/docs/7.4/s...-vacuumdb.html

-tfo


I think so. As far as I can tell, you can either vacuum a whole db, or
individual tables. But not a whole schema.

-Josh

---------------------------(end of
broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 23 '05 #4

P: n/a
On Tue, 19 Oct 2004 00:48:34 -0500, Thomas F. O'Connell
<tf*@sitening.com> wrote:
Ah, yes. You're right.

Presumably you could use the hidden query from \dn in psql to get the
tables necessary for a script. That's the next best thing I can think
of.


I wrote a script to do the vacumming. I just have a config file where
you can list the tables you want vacuumed.

Can you use those tables via normal sql? It would be nice to do that via sql.

-Josh

---------------------------(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 #5

P: n/a
Sure. The system tables can be accessed via SQL.

I frequently use the output of psql's hidden queries to glean more
information about postgres internals for needs like yours where
postgres has the information but not the interface to accomplish a
specific task.

-tfo

On Oct 19, 2004, at 12:50 PM, Josh Close wrote:
On Tue, 19 Oct 2004 00:48:34 -0500, Thomas F. O'Connell
<tf*@sitening.com> wrote:
Ah, yes. You're right.

Presumably you could use the hidden query from \dn in psql to get the
tables necessary for a script. That's the next best thing I can think
of.


I wrote a script to do the vacumming. I just have a config file where
you can list the tables you want vacuumed.

Can you use those tables via normal sql? It would be nice to do that
via sql.

-Josh

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.