Magnus,
"don't bother reporting a bug
unless you're on the latest in a branch, and at least make sure you're
on one of the maojr releases listed on www.postgresql.org"?
Seems reasonable?
absolutely. Should be standard practice.
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald A
Tom Lane wrote:
> PFC <[EMAIL PROTECTED]> writes:
>>> What version of PostgreSQL are you using?
>
>> I think newbies should be pushed a bit to use the latest versions,
>
> How about pushed *hard* ? I'm constantly amazed at the number of people
> who show up in the lists saying they installe
Greg,
> I'd like to see people have a really simple set of questions to get them
> past the completely undersized initial configuration phase, then ship them
> toward resources to help educate about the parts that could be problematic
> for them based on what they do or don't know. I don't see an
On Tue, 26 Jun 2007, Josh Berkus wrote:
I find it extremely inconsistent that you want to select "middle-of-the-road"
defaults for some values and ask users detailed questions for other values.
Which are we trying to do, here?
I'd like to see people have a really simple set of questions to get
Greg,
> Your max_connections concern is one fact that haunts the idea of just
> giving out some sample configs for people. Lance's tool asks outright the
> expectation for max_connections which I think is the right thing to do.
...
> I think people are stuck with actually learning a bit about wor
On Tue, 26 Jun 2007, Josh Berkus wrote:
The problem is that there are no "safe, middle-of-the-road" values for some
things, particularly max_connections and work_mem.
Your max_connections concern is one fact that haunts the idea of just
giving out some sample configs for people. Lance's tool
Greg,
> We've hashed through this area before, but for Lance's benefit I'll
> reiterate my dissenting position on this subject. If you're building a
> "tool for dummies", my opinion is that you shouldn't ask any of this
> information. I think there's an enormous benefit to providing something
>
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> On Fri, 22 Jun 2007, Sabin Coanda wrote:
>
>> Instead of (or in addition to) configure dozens of settings, what do you
>> say about a feedback adjustable control based on the existing system
>> statistics and parsing logs (e.g
>> ht
On Fri, 22 Jun 2007, Sabin Coanda wrote:
Instead of (or in addition to) configure dozens of settings, what do you
say about a feedback adjustable control based on the existing system
statistics and parsing logs
Take a look at the archive of this list for the end of April/Early May.
There's a
On Fri, 22 Jun 2007, Adam Tauno Williams wrote:
Just as an aside; how come the installation/setup "Tutorial" section -
http://www.postgresql.org/docs/8.2/interactive/tutorial-start.html -
doesn't mention setting some rough reasonable defaults in
postgresql.conf or even a reference to the paramet
On Fri, 22 Jun 2007, Sabin Coanda wrote:
Instead of (or in addition to) configure dozens of settings, what do you
say about a feedback adjustable control based on the existing system
statistics and parsing logs (e.g
http://pgfouine.projects.postgresql.org/index.html ) ?
something like this w
""Campbell, Lance"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL
PROTECTED]
Below is a link to the HTML JavaScript configuration page I am creating:
http://www.webservices.uiuc.edu/postgresql/
I had many suggestions. Based on the feedback I received, I put together the
i
On Fri, 2007-06-22 at 02:32 -0400, Greg Smith wrote:
> On Thu, 21 Jun 2007, Scott Marlowe wrote:
>
> > Generally I agree, however, how about a first switch, for beginner /
> > intermediate / advanced.
>
> You're describing a perfectly reasonable approach for a second generation
> tool in this a
On Thu, 21 Jun 2007, Scott Marlowe wrote:
Generally I agree, however, how about a first switch, for beginner /
intermediate / advanced.
You're describing a perfectly reasonable approach for a second generation
tool in this area. I think it would be very helpful for the user
community to get
Greg Smith wrote:
On Tue, 19 Jun 2007, Josh Berkus wrote:
I don't think the "mostly reads / mostly writes" question covers
anything,
nor is it likely to produce accurate answers. Instead, we need to
ask the
users to characterize what type of application they are running:
T1) Please character
> ""Campbell, Lance"" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> Now I am at the difficult part, what parameters to calculate and how to
> calculate them. Everything below has to do with PostgreSQL version 8.2:
>
>
> The parameters I would think we should calculate are:
> ma
Campbell, Lance wrote:
> Now I am at the difficult part, what parameters to calculate and how to
> calculate them. Everything below has to do with PostgreSQL version 8.2:
>
>
>
> The parameters I would think we should calculate are:
>
> max_connections
>
> shared_buffers
>
> work_mem
>
> m
At 4:35p -0400 on 19 Jun 2007, Lance Campbell wrote:
The parameters I would think we should calculate are:
max_connections
shared_buffers
work_mem
maintenance_work_mem
effective_cache_size
random_page_cost
From an educational/newb standpoint, I notice that the page
currently spews out a confi
On Tue, 19 Jun 2007, Josh Berkus wrote:
I don't think the "mostly reads / mostly writes" question covers anything,
nor is it likely to produce accurate answers. Instead, we need to ask the
users to characterize what type of application they are running:
T1) Please characterize the general type
Campbell, Lance writes:
max_connections
Shouldn't that come straight from the user?
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
On Tue, 19 Jun 2007, Josh Berkus wrote:
"What OS Are You Using", of course, needs to have Linux, Solaris, BSD, OSX
and Windows. At some point, this tool will also need to generate for the
user any shmem settings that they need to make on the OS.
I also noticed that on FreeBSD (6.2) at least t
Lance,
> The parameters I would think we should calculate are:
>
> max_connections
>
> shared_buffers
>
> work_mem
>
> maintenance_work_mem
>
> effective_cache_size
>
> random_page_cost
Actually, I'm going to argue against messing with random_page_cost. It's a
cannon being used when a slingshot
PFC <[EMAIL PROTECTED]> writes:
>> What version of PostgreSQL are you using?
> I think newbies should be pushed a bit to use the latest versions,
How about pushed *hard* ? I'm constantly amazed at the number of people
who show up in the lists saying they installed 7.3.2 or whatever random
Now I am at the difficult part, what parameters to calculate and how to
calculate them. Everything below has to do with PostgreSQL version 8.2:
The parameters I would think we should calculate are:
max_connections
shared_buffers
work_mem
maintenance_work_mem
effective_cache_size
random_p
On Tue, Jun 19, 2007 at 10:49:01AM -0700, Y Sidhu wrote:
> On 6/19/07, Francisco Reyes <[EMAIL PROTECTED]> wrote:
> >
> >Campbell, Lance writes:
> >
> >> Francisco and Richard,
> >> Why ask about disk or raid? How would that impact any settings in
> >> postgresql.conf?
> >
> >If the user has 2 dis
> there are three catagories of memory useage
>
> 1. needed by other software
> 2. available for postgres
> 3. needed by the OS
There's actually only two required memory questions:
M1) How much RAM do you have on this machine?
M2) Is this:
() Dedicated PostgreSQL Server?
() Serve
On Tue, 19 Jun 2007, Campbell, Lance wrote:
Memory
There are many different ways to ask about memory. Rather than ask a
series of questions I went with a single question, #2. If it is better
to ask about the memory in a series of questions then please give me the
questions you would ask and w
On Tue, 19 Jun 2007, Y Sidhu wrote:
On 6/19/07, Francisco Reyes <[EMAIL PROTECTED]> wrote:
Campbell, Lance writes:
> Francisco and Richard,
> Why ask about disk or raid? How would that impact any settings in
> postgresql.conf?
If the user has 2 disks and says that he will do a lot of u
Campbell, Lance writes:
For the "6) Are your searches:"
How about having "many simple"
---(end of broadcast)---
TIP 6: explain analyze is your friend
On 6/19/07, Campbell, Lance <[EMAIL PROTECTED]> wrote:
Below is a link to the HTML JavaScript configuration page I am creating:
http://www.webservices.uiuc.edu/postgresql/
I had many suggestions. Based on the feedback I received, I put together
the initial list of questions. This list o
Below is a link to the HTML JavaScript configuration page I am creating:
http://www.webservices.uiuc.edu/postgresql/
I had many suggestions. Based on the feedback I received, I put
together the initial list of questions. This list of questions can be
change.
Memory
There are many dif
lto:[EMAIL PROTECTED] On Behalf Of D'Arcy J.M.
Cain
Sent: Tuesday, June 19, 2007 12:32 PM
To: Francisco Reyes
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] PostgreSQL Configuration Tool for Dummies
On Tue, 19 Jun 2007 12:58:26 -0400
Francisco Reyes <[EMAIL PROTECTED]> wrote:
>
On Tue, 19 Jun 2007 12:58:26 -0400
Francisco Reyes <[EMAIL PROTECTED]> wrote:
> Campbell, Lance writes:
> > 3) I suggested JavaScript because most people that get started with
> > PostgreSQL will go to the web in order to find out about issues relating
>
> Why not c?
Why not whatever and instal
PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Y Sidhu
Sent: Tuesday, June 19, 2007 12:49 PM
To: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] PostgreSQL Configuration Tool for Dummies
On 6/19/07, Francisco Reyes <[EMAIL PROTECTED]> wrote:
Campbell, Lance writes:
> Fran
On 6/19/07, Francisco Reyes <[EMAIL PROTECTED]> wrote:
Campbell, Lance writes:
> Francisco and Richard,
> Why ask about disk or raid? How would that impact any settings in
> postgresql.conf?
If the user has 2 disks and says that he will do a lot of updates he could
put pg_xlog in the second d
Campbell, Lance writes:
Francisco and Richard,
Why ask about disk or raid? How would that impact any settings in
postgresql.conf?
If the user has 2 disks and says that he will do a lot of updates he could
put pg_xlog in the second disk.
---(end of broadcast)---
What version of PostgreSQL are you using?
I think newbies should be pushed a bit to use the latest versions, maybe
with some advice on how to setup the apt sources (in debian/ubuntu) to get
them.
How much memory will be available to PostgreSQL?
How many connections will be made to Po
Campbell, Lance wrote:
Francisco and Richard,
Why ask about disk or raid? How would that impact any settings in
postgresql.conf?
Well, random_page_cost will depend on how fast your disk system can
locate a non-sequential page. If you have a 16-disk RAID-10 array that's
noticably less time th
://webservices.uiuc.edu
-Original Message-
From: Francisco Reyes [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 19, 2007 11:58 AM
To: Campbell, Lance
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] PostgreSQL Configuration Tool for Dummies
Campbell, Lance writes:
> 3
Campbell, Lance writes:
3) I suggested JavaScript because most people that get started with
PostgreSQL will go to the web in order to find out about issues relating
Why not c?
It could then go into contrib.
Anyways.. language is likely the least important issue..
As someone mentioned.. once t
Campbell, Lance wrote:
Please think simple. I stress the word simple. The real challenge here
is getting the formulas correct. Someone mentioned to not focus on the
values but just get something out there for everyone to help tweak. I
agree!
What questions do you think should be asked in ord
Please read the whole email before replying:
I love the feedback I have received but I feel that somehow I did not
communicate the intent of this mini project very well. So let me
outline a few basics and who the audience was intended for.
Mini project title:
Initial Configuration Tool
42 matches
Mail list logo
