Skip site navigation (1) Skip section navigation (2)

Re: Solaris Performance (Again)

From: Jeff <threshar(at)torgo(dot)978(dot)org>
To: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Solaris Performance (Again)
Date: 2003-12-10 13:53:23
Message-ID: 20031210085323.749a549f.threshar@torgo.978.org (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performance
On Wed, 10 Dec 2003 18:56:38 +1300
Mark Kirkwood <markir(at)paradise(dot)net(dot)nz> wrote:

> The major performance killer appeared to be mounting the filesystem
> with the logging option. The next most significant seemed to be the
> choice of sync_method for Pg - the default (open_datasync), which we
> initially thought should be the best - appears noticeably slower than
> fdatasync.
> 

Some interesting stuff, I'll have to play with it. Currently I'm pleased
with my solaris performance.

What version of PG?

If it is before 7.4 PG compiles with _NO_ optimization by default and
was a huge part of the slowness of PG on solaris. 


-- 
Jeff Trout <jeff(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/

In response to

Responses

pgsql-performance by date

Next:From: Josh BerkusDate: 2003-12-10 17:18:02
Subject: Re: TRUNCATE veeeery slow compared to DELETE in 7.4
Previous:From: Mark KirkwoodDate: 2003-12-10 05:56:38
Subject: Solaris Performance (Again)

pgsql-hackers by date

Next:From: Florian G. PflugDate: 2003-12-10 13:57:08
Subject: Re: Strange permission problem regarding pg_settings
Previous:From: Andreas PflugDate: 2003-12-10 13:34:48
Subject: Re: Cannot add an column of type serial or bigserial

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group