Re: Feature Request --- was: PostgreSQL Performance Tuning

From: Sebastian Hennebrueder <usenet(at)laliluna(dot)de>
To:
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Feature Request --- was: PostgreSQL Performance Tuning
Date: 2007-05-04 16:40:13
Message-ID: 463B61ED.20409@laliluna.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

david(at)lang(dot)hm schrieb:
> On Tue, 1 May 2007, Carlos Moreno wrote:
>
>>> large problem from a slog perspective; there is no standard way even
>>> within Linux to describe CPUs, for example. Collecting available disk
>>> space information is even worse. So I'd like some help on this
>>> portion.
>>>
>>
>> Quite likely, naiveness follows... But, aren't things like
>> /proc/cpuinfo ,
>> /proc/meminfo, /proc/partitions / /proc/diskstats standard, at the very
>> least across Linux distros? I'm not familiar with BSD or other Unix
>> flavours, but I would expect these (or their equivalent) to exist in
>> those,
>> no?
>>
>> Am I just being naive?
>
> unfortunantly yes.
>
> across different linux distros they are fairly standard (however
> different kernel versions will change them)
>
> however different kernels need drasticly different tools to get the
> info from them.
>
> David Lang
>
Before inventing a hyper tool, we might consider to provide 3-5 example
szenarios for common hardware configurations. This consumes less time
and be discussed and defined in a couple of days. This is of course not
the correct option for a brandnew 20 spindle Sata 10.000 Raid 10 system
but these are probably not the target for default configurations.

If we carefully document these szenario they would we a great help for
people having some hardware "between" the szenarios.

Sebastian Hennebrueder

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message shawn 2007-05-04 16:54:09 DataArchitect Version 4.0 now available
Previous Message Tom Lane 2007-05-04 16:09:51 Re: Query not using index despite high statistics

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2007-05-04 17:10:16 Re: Query performance problems with partitioned tables
Previous Message Paul Smith 2007-05-04 16:10:48 Re: Index not being used in sorting of simple table