From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | zzzzz <zzzzz(at)indycobra(dot)com> |
Cc: | pgsql-advocacy(at)postgresql(dot)org |
Subject: | Re: Performance MSSql vs PostgreSql |
Date: | 2006-05-11 16:57:55 |
Message-ID: | 44636D13.5090609@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy |
ZZZZ,
> Default for both MSSQL and PostgreSql no performance turning was done
> to the configurations
Try setting work_mem to 8096, or 16192.
> I'm not using the server time but the clients time from the start of the
> query and time to return the resulting dataset to Foxpro. The code is
> on Channel 9, Its just a simple loop to see have fast it runs.
Aha, so this could be an ODBC driver speed difference as well. I
wouldn't be surprised.
> I was not looking at the server response time but what the client/user
> will experience. To me how the fast the server does something kinda
> meaningless if User can't see the added speed because one of the other
> layers is slowing things down.
Certainly.
>> Finally, given your overall times I see that stuff is *very* slow on
>> VMware. I'd expect that query to return in milleseconds on both
>> databases!
>>
>
> I stated the test setup on channel 9 this is all running on my HP zd7000
> laptop 3.2 gigahertz p4, 54000 rpm hard drive. My development
> environment runs in VMware 5.0 it slows things down a bit but not allot.
Yes, so that's part of things. I think the bigger part is ODBC and
FoxPro overhead. I'd be interested to see the time just on the database
server.
--Josh
From | Date | Subject | |
---|---|---|---|
Next Message | Jim C. Nasby | 2006-05-12 00:00:53 | Re: Banners on postgresql.org not running on pgsql? |
Previous Message | zzzzz | 2006-05-11 15:01:16 | Re: Performance MSSql vs PostgreSql |