Re: Performance problem. Could it be related to 8.3-beta4?

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: Clodoaldo <clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Greg Smith" <gsmith(at)gregsmith(dot)com>, "PostgreSQL General ML" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Performance problem. Could it be related to 8.3-beta4?
Date: 2008-01-06 14:51:46
Message-ID: dcc563d10801060651k1a7cfb9dt9aa449c7e46017db@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Jan 6, 2008 5:06 AM, Clodoaldo <clodoaldo(dot)pinto(dot)neto(at)gmail(dot)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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Goboxe 2008-01-06 18:58:38 Re: Using syslog on pg for Windows
Previous Message Usama Dar 2008-01-06 12:55:41 Re: large table vacuum issues