This is normal. My personal workstation has been up for 16
days, and it shows 65 megs used for swap. The linux kernel
looks for things that haven't been accessed in quite a while
and tosses them into swap to free up the memory for other uses.
This isn't PostgreSQL's fault, or anything
Josh,
Le jeudi 15 Juillet 2004 20:09, Josh Berkus a écrit :
I suggest you check this first. Check the performance tuning guide..
http://www.varlena.com/varlena/GeneralBits/Tidbits/index.php
That is a starters. As Josh suggested, increase checkpoint segments if
you
have
disk
I lost the email that had the fix for this
and now I need it again can someone or tom let me know what the fix was,
I cant find it in any of my emails or archived on the internet
This is what I got
Two servers, one debian, one fedora
Debain dual 3ghz, 1 gig ram, ide, PostgreSQL
Hi,
I have a query, which runs fast for one id (query 1)
and slow for other id (query 2)
though both plans and cost are same except
these two qeries return different number of rows.
explain analyze
SELECT *
FROM user U LEFT JOIN user_timestamps T USING
(user_id), user_alias A
WHERE U.user_id =
The database grows very slowly. The main load comes from SELECT's and
not from INSERT's or UPDATE's, but the performance gets slower day by day...
I have no idea where to search for the speed break!
Lets start with an example. Please send us an EXPLAIN ANALYZE of a
couple of the poorly
We're looking into getting an Adaptec 2200S or the Megaraid 320 2x
which have better processors, and hopefully better performance. We
feel that the use of the AIC7930 as the CPU on the ZCR just doesn't
cut it and a faster raid controller would work better. Does anyone out
there have any
Pg Performers,
This might be a out of the ordinary question, or perhaps I have been out
of the loop for a while but does PostgreSQL (or any other database) have
support for lazy index updates. What I mean by lazy index updates is
index updating which occur at a regular interval rather than per
Litao Wu [EMAIL PROTECTED] writes:
SELECT *
FROM user U LEFT JOIN user_timestamps T USING
(user_id), user_alias A
WHERE U.user_id = A.user_id AND A.domain_id=7551070;
Ick. Try changing the join order, perhaps
SELECT *
FROM (user U JOIN user_alias A ON (U.user_id = A.user_id))
LEFT