| From: | Craig Ringer <craig(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Peter Kroon <plakroon(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: w7 vs linux |
| Date: | 2012-11-23 10:42:43 |
| Message-ID: | 50AF5323.10401@2ndQuadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 11/23/2012 05:39 PM, Peter Kroon wrote:
> Is pgsql faster on linux?
> Currently I've made an installation on W7 and the converted queries
> are about 3 times slower then on mssql.
> There's still some optimization to do tho...but the current results
> don't look to good.
In my experience it's somewhat faster on Linux, but I haven't compared
extensively on the same hardware.
It's known to be necessary to set shared_buffers lower on Windows for
reasons not yet firmly established.
Since you have provided no information about the configuration or
hardware, your question isn't much better than "is A faster than B".
What's A? What's B?
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2012-11-23 10:45:09 | Re: ERROR: query has no destination for result data |
| Previous Message | Bartosz Dmytrak | 2012-11-23 10:41:51 | Re: ERROR: query has no destination for result data |