Re: dbt-2 tuning results with postgresql-8.3.5 - Mailing list pgsql-performance

From Mark Wong
Subject Re: dbt-2 tuning results with postgresql-8.3.5
Date
Msg-id 70c01d1d0902052104s3f6b46afu4c40257d99c38d4f@mail.gmail.com
Whole thread Raw
In response to Re: dbt-2 tuning results with postgresql-8.3.5  (Mark Wong <markwkm@gmail.com>)
Responses Re: dbt-2 tuning results with postgresql-8.3.5  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-performance
On Thu, Jan 22, 2009 at 10:10 PM, Mark Wong <markwkm@gmail.com> wrote:
> On Thu, Jan 22, 2009 at 7:44 PM, Greg Smith <gsmith@gregsmith.com> wrote:
>> On Thu, 22 Jan 2009, Mark Wong wrote:
>>
>>> I'm also capturing the PostgreSQL parameters as suggested so we can
>>> see what's set in the config file, default, command line etc.  It's
>>> the "Settings" link in the "System Summary" section on the report web
>>> page.
>>
>> Those look good, much easier to pick out the stuff that's been customized. I
>> note that the Linux "Settings" links seems to be broken though.
>
> Oh fudge, I think I see where my scripts are broken.  We're running
> with a different Linux kernel now than before so I don't want to grab
> the parameters yet.  I'll switch to the previous kernel to get the
> parameters after the current testing is done, and fix the scripts in
> the meantime.

Sorry for the continuing delays.  I have to make more time to spend on
this part.  One of the problems is that my scripts are listing the OS
of the main driver system, as opposed to the db system.  Mean while,
I've attached the sysctl output from kernel running on the database
system, 2.6.27-gentoo-r2..

Regards,
Mark

Attachment

pgsql-performance by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: bitmap heap scan recheck on full text search with gin index
Next
From: Greg Smith
Date:
Subject: Re: dbt-2 tuning results with postgresql-8.3.5