pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedPerformance Solaris vs Linux
4+ messages / 4 participants
[nested] [flat]
* Performance Solaris vs Linux
@ 2007-08-17 06:50 Fredrik Bertilsson <frebe73@gmail.com>
2007-08-18 03:08 ` Re: Performance Solaris vs Linux Alvaro Herrera <alvherre@commandprompt.com>
2007-08-18 10:13 ` Re: Performance Solaris vs Linux Chris Mair <chris@1006.org>
2007-08-21 15:49 ` Re: Performance Solaris vs Linux Julius Stroffek <Julius.Stroffek@Sun.COM>
0 siblings, 3 replies; 4+ messages in thread
From: Fredrik Bertilsson @ 2007-08-17 06:50 UTC (permalink / raw)
To: pgsql-performance
Hi,
we are using Postgres on both Solaris servers and Linux servers, and
Postgres are much slower on Solaris servers. We have tested with different
versions of Solaris and Postgres, but the fact remains: Postgres seems to be
much faster on Linux server. Does anybody else has the same experience?
Best regards,
Fredrik B
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Performance Solaris vs Linux
2007-08-17 06:50 Performance Solaris vs Linux Fredrik Bertilsson <frebe73@gmail.com>
@ 2007-08-18 03:08 ` Alvaro Herrera <alvherre@commandprompt.com>
2 siblings, 0 replies; 4+ messages in thread
From: Alvaro Herrera @ 2007-08-18 03:08 UTC (permalink / raw)
To: Fredrik Bertilsson <frebe73@gmail.com>; +Cc: pgsql-performance
Fredrik Bertilsson escribió:
> Hi,
> we are using Postgres on both Solaris servers and Linux servers, and
> Postgres are much slower on Solaris servers. We have tested with different
> versions of Solaris and Postgres, but the fact remains: Postgres seems to be
> much faster on Linux server. Does anybody else has the same experience?
You haven't specified where the slowness is. Is it that connection
establishing is slower? Are queries slower? Is the hardware
comparable? Are the filesystems configured similarly?
--
Alvaro Herrera http://www.amazon.com/gp/registry/DXLWNGRJD34J
"Find a bug in a program, and fix it, and the program will work today.
Show the program how to find and fix a bug, and the program
will work forever" (Oliver Silfridge)
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Performance Solaris vs Linux
2007-08-17 06:50 Performance Solaris vs Linux Fredrik Bertilsson <frebe73@gmail.com>
@ 2007-08-18 10:13 ` Chris Mair <chris@1006.org>
2 siblings, 0 replies; 4+ messages in thread
From: Chris Mair @ 2007-08-18 10:13 UTC (permalink / raw)
To: Fredrik Bertilsson <frebe73@gmail.com>; +Cc: pgsql-performance
Fredrik Bertilsson wrote:
> Hi,
> we are using Postgres on both Solaris servers and Linux servers, and
> Postgres are much slower on Solaris servers. We have tested with
> different versions of Solaris and Postgres, but the fact remains:
> Postgres seems to be much faster on Linux server. Does anybody else has
> the same experience?
>
> Best regards,
> Fredrik B
I had some performance problems on Solaris a while ago which let to
this interesting thread:
http://archives.postgresql.org/pgsql-performance/2006-04/thrd4.php#00035
executive summary:
- write cache might be (unexpectedly) off by default on sun gear
- set explicitly "wal_sync_method = fsync"
- some other settings (see thread)
Bye,
Chris.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Performance Solaris vs Linux
2007-08-17 06:50 Performance Solaris vs Linux Fredrik Bertilsson <frebe73@gmail.com>
@ 2007-08-21 15:49 ` Julius Stroffek <Julius.Stroffek@Sun.COM>
2 siblings, 0 replies; 4+ messages in thread
From: Julius Stroffek @ 2007-08-21 15:49 UTC (permalink / raw)
To: Fredrik Bertilsson <frebe73@gmail.com>; +Cc: pgsql-performance
Hi Frederick,
There is an article about tunning the performance of PostgreSQL on
Solaris at
http://tweakers.net/reviews/649/9
which is not quite exactly of what you wanted but it might help you.
I think that Solaris has disk cache turned off by default which linux
does not have
due to possible data loss in case of a power failure.
Regards,
Julo
Fredrik Bertilsson wrote:
> Hi,
> we are using Postgres on both Solaris servers and Linux servers, and
> Postgres are much slower on Solaris servers. We have tested with
> different versions of Solaris and Postgres, but the fact remains:
> Postgres seems to be much faster on Linux server. Does anybody else
> has the same experience?
>
> Best regards,
> Fredrik B
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2007-08-21 15:49 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-08-17 06:50 Performance Solaris vs Linux Fredrik Bertilsson <frebe73@gmail.com>
2007-08-18 03:08 ` Alvaro Herrera <alvherre@commandprompt.com>
2007-08-18 10:13 ` Chris Mair <chris@1006.org>
2007-08-21 15:49 ` Julius Stroffek <Julius.Stroffek@Sun.COM>
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