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 |
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 |