Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance problem. Could it be related to 8.3-beta4? - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Performance problem. Could it be related to 8.3-beta4?
Date
Msg-id dcc563d10801060651k1a7cfb9dt9aa449c7e46017db@mail.gmail.com
Whole thread Raw
In response to Re: Performance problem. Could it be related to 8.3-beta4?  (Clodoaldo <clodoaldo.pinto.neto@gmail.com>)
Responses Re: Performance problem. Could it be related to 8.3-beta4?  (Clodoaldo <clodoaldo.pinto.neto@gmail.com>)
List pgsql-general
Tree view 
On Jan 6, 2008 5:06 AM, Clodoaldo <clodoaldo.pinto.neto@gmail.com> wrote:
>
> Then I rebuilt and reinstalled postgresql with the xlog_seg_size set
> to the default 16MB and did initdb. Now the time is 7,642 sec.
>
> I'm lost. It looks like 1GB xlog_seg_size is indeed faster than 16MB
> but again it is slower than the production server which uses the
> default xlog_seg_size.

How fast was it the second time you ran it?

pgsql-general by date:

Previous
From: "Usama Dar"
Date:
Subject: Re: large table vacuum issues
Next
From: Clodoaldo
Date:
Subject: Re: Performance problem. Could it be related to 8.3-beta4?