it doesn't swap near the spikes, so I don't think
this is the problem. I posted a vmstat sample in another reply, where
you can see an example of what happens.
Regards,
Anders K. Pedersen
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
any suggestions are
very welcome.
Regards,
Anders K. Pedersen
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Shridhar Daithankar wrote:
On 28 Aug 2003 at 1:07, Anders K. Pedersen wrote:
We're running a set of Half-Life based game servers that lookup user
privileges from a central PostgreSQL 7.3.4 database server (I recently
ported the MySQL code in Adminmod to PostgreSQL to be able to do
Tom Lane wrote:
Anders K. Pedersen [EMAIL PROTECTED] writes:
Currently there's only a few users in the database for testing purposes,
and most of the time the user lookup's take 2-3 ms (I have syslog'ing of
queries and duration turned on), but several times per hour the duration
for one
by itself. I have experienced similar issues when another
process (cron job in my case) caused brief swapping to occur.
OK. I may have to try to put the database on a separate server.
Regards,
Anders K. Pedersen
---(end of broadcast)---
TIP 8: explain