I am using postgresql for a web site. The development environment
is on a Linux system and works fine. The production machine
is a Sun BSDI system. After implementing the stuf on the
production machine the provider got many performance dificulties.
Apparently simple queries keep on collecting CPU time (up to a minute)
where the linux machine handles the same query in less than
a single CPU second. On Linux the amount of CPU time used in independent
of the load of the machine. On de BSDI system it seems to accumulate
when the load increases (which in turn increases the load ...).
Anybody got a clue on what this can be (and how to solve it).
Cheers
Arjen
------------------------------
