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

From Tom Lane
Subject Re: Performance problem. Could it be related to 8.3-beta4?
Date
Msg-id 6907.1199554931@sss.pgh.pa.us
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?
List pgsql-general
Clodoaldo <clodoaldo.pinto.neto@gmail.com> writes:
>> How did you get 8.3-beta4?

> I built from the source rpm, which i installed in my machine. There is
> something I forgot to mention. I created a patch to change
> XLOG_SEG_SIZE and built with it:
> -#define XLOG_SEG_SIZE  (16*1024*1024)
> +#define XLOG_SEG_SIZE  (1024*1024*1024)

What made you decide that was a good idea??

Please revert that change and see if the performance goes back to
normal.

            regards, tom lane

pgsql-general by date:

Previous
From: Cesar Alvarez
Date:
Subject: Insert returning Npgsql
Next
From: Greg Smith
Date:
Subject: Re: Performance problem. Could it be related to 8.3-beta4?