From: Vitaly Belman <vitalib@012.net.il>
To: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL caching
Date: Wed, 26 May 2004 21:00:34 +0300
Message-ID: <3115838500.20040526210034@012.net.il> (raw)
In-Reply-To: <200405260917.35537.josh@agliodbs.com>
References: <20792805375.20040521203337@012.net.il>
<40B3C792.3020106@outputservices.com>
<1673440625.20040526173356@012.net.il>
<200405260917.35537.josh@agliodbs.com>
Hello Josh,
JB> Not that you can't improve the query, just that it might not fix
JB> the problem.
Yes, I'm aware it might be slower than the Linux version, but then, as
you said, I still can improve the query (as I did with your help now).
But true, if there's something awfully wrong with Win32 port
performance, I might be doing some overwork...
JB> Therefore ... your detailed feedback is appreciated, especially if you can
JB> compare stuff to the same database running on a Linux, Unix, or BSD machine.
I can't easily install Linux right now.. But I am considering using it
through VMWare. Do you think it would suffice as a comprasion?
From what I saw (e.g
http://usuarios.lycos.es/hernandp/articles/vpcvs.html) the performance
are bad only when it's coming to graphics, otherwise it looks pretty
good.
Regards,
Vitaly Belman
ICQ: 1912453
AIM: VitalyB1984
MSN: tmdagent@hotmail.com
Yahoo!: VitalyBe
Wednesday, May 26, 2004, 7:17:35 PM, you wrote:
JB> Vitaly,
>> I am using the newer 7.5dev native Windows port. For this reason I
>> don't think that IN will cause any trouble (I read that this issue was
>> resolved in 7.4).
JB> Well, for performance, all bets are off for the dev Windows port. Last I
JB> checked, the Win32 team was still working on *stability* and hadn't yet even
JB> looked at performance. Not that you can't improve the query, just that it
JB> might not fix the problem.
JB> Therefore ... your detailed feedback is appreciated, especially if you can
JB> compare stuff to the same database running on a Linux, Unix, or BSD machine.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: vitalib@012.net.il, josh@agliodbs.com
Subject: Re: PostgreSQL caching
In-Reply-To: <3115838500.20040526210034@012.net.il>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox