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
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>
In response to
pgsql-performance by date
|Next:||From: Josh Berkus||Date: 2003-12-10 17:18:02|
|Subject: Re: TRUNCATE veeeery slow compared to DELETE in 7.4|
|Previous:||From: Mark Kirkwood||Date: 2003-12-10 05:56:38|
|Subject: Solaris Performance (Again)|
pgsql-hackers by date
|Next:||From: Florian G. Pflug||Date: 2003-12-10 13:57:08|
|Subject: Re: Strange permission problem regarding pg_settings|
|Previous:||From: Andreas Pflug||Date: 2003-12-10 13:34:48|
|Subject: Re: Cannot add an column of type serial or bigserial|