On Mon, Aug 27, 2007 at 10:31:11PM +0200, Kamil Srot wrote:
> The script is very simple one:
Well, I don't see anything obvious, but. . .
> I can easily rewrite it to use the vacuumdb command, but I doubt it'll
> make any difference.
The point is that you don't have to rewrite it. Just run "vacuumdb
-a" and it vacuums _all_ databases.
> Is there a way how to find out the problem is here? I scanned the log
> output of pgsql for wrap around but didn't found aby recent relevant
> entries... I'm pretty sure, I miss something stupid :-(
Are you quite sure you're getting all your logs where you think you
are?
A
--
Andrew Sullivan | ajs@xxxxxxxxxxxxxxx
The plural of anecdote is not data.
--Roger Brinner
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
