| From: | Holger Marzen <holger(at)marzen(dot)de> |
|---|---|
| To: | Mark kirkwood <markir(at)slingshot(dot)co(dot)nz> |
| Cc: | lockhart(at)fourpalms(dot)org, Christian Cabanero <chumpboy(at)yahoo(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: SQL Server performing much better?!?! |
| Date: | 2002-03-24 20:25:56 |
| Message-ID: | Pine.LNX.4.44.0203242120250.23350-100000@bluebell.marzen.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 25 Mar 2002, Mark kirkwood wrote:
> Agreed...I currently work with Solaris and its generally quite good...
> but there seems to be a definite performance problem with Postgresql on
> Solaris (see a previous thread with title "Solaris Performance").
Solaris is slow when writing to ufs filesystem in default configuration.
I guess that postgresql writes out temporary data. The writes can
probably be speed up when writing to tempfs or by disabling the journal.
Writing data can probably speed up with the mount option "nologging".
Reading data can probably speed up with the mount option "noatime".
Can someone try this?
--
PGP/GPG Key-ID:
http://blackhole.pca.dfn.de:11371/pks/lookup?op=get&search=0xB5A1AFE1
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Emberson | 2002-03-24 21:44:25 | Re: Large Object Location in 7.3 |
| Previous Message | Bruce Momjian | 2002-03-24 19:32:16 | Re: Large Object Location in 7.3 |