Re: dbt-2 tuning results with postgresql-8.3.5

From: Mark Wong <markwkm(at)gmail(dot)com>
To: Greg Smith <gsmith(at)gregsmith(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>, Selena Deckelmann <selenamarie(at)gmail(dot)com>, Gabrielle Roth <gorthx(at)gmail(dot)com>
Subject: Re: dbt-2 tuning results with postgresql-8.3.5
Date: 2009-02-06 05:04:46
Message-ID: 70c01d1d0902052104s3f6b46afu4c40257d99c38d4f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Jan 22, 2009 at 10:10 PM, Mark Wong <markwkm(at)gmail(dot)com> wrote:
> On Thu, Jan 22, 2009 at 7:44 PM, Greg Smith <gsmith(at)gregsmith(dot)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 Content-Type Size
sysctl-2.6.27-gentoo-r2 application/octet-stream 22.7 KB

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2009-02-06 08:22:00 Re: dbt-2 tuning results with postgresql-8.3.5
Previous Message Oleg Bartunov 2009-02-06 04:22:17 Re: bitmap heap scan recheck on full text search with gin index