Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-performance by date

Next:From: Michael StoneDate: 2007-04-27 15:30:33
Subject: Re: Feature Request --- was: PostgreSQL Performance Tuning
Previous:From: Mark LewisDate: 2007-04-27 14:36:52
Subject: Re: Feature Request --- was: PostgreSQL PerformanceTuning

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group