queries for cluster/vacum/analyse/update cache

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

queries for cluster/vacum/analyse/update cache

Postby bubu0068 » Sat Sep 27, 2008 6:25 am

i would like to automatised the housekeeping
the sql command line is simply :
"CLUSTER ;" for cluster (all table)?
"VACUM ;" for vacum (all table)?
"ANALYSE;" for analyse (all table) ?
i suppose update cache is an series of queries ? can we have this queries ? or can we update cache with a command line like "pokertracker3.exe .....updatecache.exe" for exemple?

Thank you, and sorry for my bad english.
bubu0068
 
Posts: 2
Joined: Thu Mar 06, 2008 2:13 pm

Re: queries for cluster/vacum/analyse/update cache

Postby WhiteRider » Sat Sep 27, 2008 11:51 am

The cluster vacuum analyse are not simple postgres functions, PT3 does things differently.
If you enable logging and run housekeeping you will be able to find the SQL being used by looking in the log file.
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 17 guests

cron
highfalutin