Re: UFS Logging on Solaris 8 - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: UFS Logging on Solaris 8
Date
Msg-id 20030523190358.GE28360@libertyrms.info
Whole thread Raw
In response to UFS Logging on Solaris 8  ("Fernando Papa" <fpapa@claxson.com>)
Responses Query Output Formatting - Y/N Depending On Count  ("Cameron B. Prince" <cprince@rideware.com>)
List pgsql-general
On Thu, May 22, 2003 at 05:19:33PM -0300, Fernando Papa wrote:

> 1) Do you have any experience/problems with this filesystem?

No.

> 2) performance could be better than "plain" UFS?

Not really, and it may be slower.

> 3) We have 4 physical 18GB Disk. We are thinking about the layout: One
> physiscal disk for O.S. and the other disk for Database. And the two
> other disks will be mirror (with DiskSuite). This could be good for
> start?

One for OS, "one for Database" as in the binary?  Put the binary on
the OS's disk.  Put WAL on its own disk (or at least, on a different
disk than the data storage areas).  The performance is much better
that way.

> I know, solaris is not the best platform to run postgresql, but I'ts the
> only we have now.

Some people report that Linux is actually faster than Solaris on the
various SPARCs.  I have my doubts, but I haven't tried.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


pgsql-general by date:

Previous
From: Erik Price
Date:
Subject: Re: tablemeta-data
Next
From: "Guillaume Houssay"
Date:
Subject: Postgresql on SUN Server