> 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 anyt
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
Hi,
I operate a database server with postgres 7.3.2, 2 Xeon CPU's and 1 GB
Ram. The database-files reside on a local SCSI-HD, the system runs on
SuSE Enterprise Server 8.0.
The size of the dumped database is about 300 MB, the database is
vacuumed (-a -z) every night an reindexed every week.
Th
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 can’t 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, PostgreS
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 = A.
> 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 p
> 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
tr
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))
LEF
