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

From: "H(dot)J(dot) Sanders" <hjs(at)rmax(dot)nl>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Feature Request --- was: PostgreSQL Performance Tuning
Date: 2007-04-27 15:03:09
Message-ID: HAEGJCMBOJKEJADLOGEGGEPMCHAA.hjs@rmax.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance


Hello.

Just my 2 cents, and not looking to the technical aspects:

setting up PSQL is the weakest point of PSQL as we have experienced ourself,
once it is running it is great.

I can imagine that a lot of people of stops after their first trials after
they have
experienced the troubles and performance of a standard set up.

This is ofcourse a lost user forever.

So anything that could be done to get an easier and BETTER setup would
strongly enhance PSQL.

My 2 cents.

Henk Sanders

-----Oorspronkelijk bericht-----
Van: pgsql-performance-owner(at)postgresql(dot)org
[mailto:pgsql-performance-owner(at)postgresql(dot)org]Namens Tom Lane
Verzonden: vrijdag 27 april 2007 16:37
Aan: Carlos Moreno
CC: PostgreSQL Performance
Onderwerp: Re: [PERFORM] Feature Request --- was: PostgreSQL Performance
Tuning

Carlos Moreno <moreno_pg(at)mochima(dot)com> writes:
> Tom Lane wrote:
>> But
>> the fundamental problem remains that we don't know that much about
>> how the installation will be used.

> Notice that the second part of my suggestion covers this --- have
> additional switches to initdb

That's been proposed and rejected before, too; the main problem being
that initdb is frequently a layer or two down from the user (eg,
executed by initscripts that can't pass extra arguments through, even
assuming they're being invoked by hand in the first place).

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Stone 2007-04-27 15:30:33 Re: Feature Request --- was: PostgreSQL Performance Tuning
Previous Message Rich Shepard 2007-04-27 14:50:18 Re: Preferred Installation/Data Directories

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Stone 2007-04-27 15:30:33 Re: Feature Request --- was: PostgreSQL Performance Tuning
Previous Message Mark Lewis 2007-04-27 14:36:52 Re: Feature Request --- was: PostgreSQL Performance Tuning