vmstat 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
ning on
a machine 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)--
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 pe
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 this).
t results, and I've been running this for
a while now, and I will report the results shortly.
Regards,
Anders K. Pedersen
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
ve been unable to locate the problem, so any suggestions are
very welcome.
Regards,
Anders K. Pedersen
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
