On Wednesday 27 June 2007 23:46:25 Vincenzo Romano wrote: > Hi all. > I understand this can be a ridiculous question for most you. > > The very same query on the very same db shows very variable > timings. I'm the only one client on an unpupolated server so I'd > expect a rather constant timing. > > INstead for a while the query become very slooow and the CPU > reached 60 to 70% and the time needed is about 1.5 minutes0. > Again with just me on it. > Normally the same query rises the usage to a mere 5% to 7% with > timing with the tenth of a second. > > I have disable both the autovacuum and the "stats_start_collector" > in the > attempt to disable possibe reasons for slow down. No luck in this. > > Do you have any hint? What's really weird is that after some time the timings get back to normal. With no explicit action. Then, later, timings get worse again. I fear it can be a "DBA problem" but but still have no clue. -- Vincenzo Romano -- Maybe Computer will never become as intelligent as Humans. For sure they won't ever become so stupid. [VR-1988]
