Page 1 of 1

queries for cluster/vacum/analyse/update cache

PostPosted: Sat Sep 27, 2008 6:25 am
by bubu0068
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.

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

PostPosted: Sat Sep 27, 2008 11:51 am
by WhiteRider
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.

highfalutin