Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL caching

From: Vitaly Belman <vitalib(at)012(dot)net(dot)il>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL caching
Date: 2004-05-26 18:00:34
Message-ID: 3115838500.20040526210034@012.net.il (view raw or flat)
Thread:
Lists: pgsql-performance
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(at)hotmail(dot)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.

In response to

Responses

pgsql-performance by date

Next:From: Dennis BjorklundDate: 2004-05-26 19:03:56
Subject: Re: performance very slow
Previous:From: Frank FinnerDate: 2004-05-26 17:46:32
Subject: Re: performance very slow

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group