From: Bruce Momjian <pgman@candle.pha.pa.us>
To: scott.marlowe <scott.marlowe@ihs.com>
Cc: Josh Berkus <josh@agliodbs.com>
Cc: Kaarel <kaarel@future.ee>
Cc: pgsql-advocacy@postgresql.org
Cc: pgsql-performance@postgresql.org
Subject: Re: About the default performance
Date: Sun, 20 Jul 2003 22:49:07 -0400 (EDT)
Message-ID: <200307210249.h6L2n7315858@candle.pha.pa.us> (raw)
In-Reply-To: <Pine.LNX.4.33.0307071159080.4748-100000@css120.ihs.com>
I can help with this too.
---------------------------------------------------------------------------
scott.marlowe wrote:
> I'm willing to help too. I'm basically a DBA / developer type, with mild
> C hacking skills (I develop in PHP, so my C coding is quite rusty
> nowadays.)
>
> If nothing else testing on different equipment / OSes.
>
> On Fri, 4 Jul 2003, Josh Berkus wrote:
>
> > Kaarel:
> >
> > (cross-posted back to Performance because I don't want to post twice on the
> > same topic)
> >
> > > The problem is that people often benchmark the so called vanilla
> > > installation of PostgreSQL.
> > <snip>
> > > I remember a discussion in the general list about having multiple
> > > default conf files to choose from. Ala low-end, average and high-end
> > > installations. A tool to read some system information and dynamically
> > > generating a proper configuration file was also mentioned.
> >
> > Yes. So far, only Justin, Kevin B., Shridhar and I have volunteered to do any
> > work on that task -- and all of us have been swamped with 7.4-related stuff.
> >
> > I would like to see, before the end of the year, some if not all of the stuff
> > that Kaarel is posting about. Obviously, my first task is to set up a
> > framework so that everyone can contribute to the project.
> >
> > > I'm not an expert of PostgreSQL by any means I have just been reading
> > > PostgreSQL email lists for only about a month or so. So I believe I have
> > > read that there is a auto-vacuum being worked on? In my opinion this
> > > should be included in the main installation by default. This is just the
> > > kind of job that a machine should do...when a big portion of data has
> > > changed do VACUUM ANALYCE automagically.
> > >
> > > Is these improvements actually being implemented and how far are they?
> >
> > The auto-vacuum daemon (pgavd) is finished. However, it will still require
> > the user to turn it on; we don't want to run potentially RAM-sucking
> > background processes without user invitiation. So obviously that needs to be
> > part of a comprehensive "quick start" guide.
> >
> > So, Kaarel .... you want to write the "quick start" guide for 7.4? All of
> > the detail material is available online, you mainly need to provide narrative
> > and links of the form of ... first, read this: <link>, then do this ...
> >
> > > The technical side of these problems is not for this list of course.
> > > However the "side-effects" (reputation of being slow) of these problems
> > > direclty relate to advocacy and PostgreSQL popularity. Maybe these
> > > problems are already worked on or maybe I'm over exaggerating the
> > > situation but I do believe solving these issues would only benefit
> > > PostgreSQL.
> >
> > You're absolutely correct .... so let's do something about it. From my
> > perspective, the first step is improved docs, becuase we can have those out
> > by 7.4 release.
> >
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: pgman@candle.pha.pa.us, scott.marlowe@ihs.com, josh@agliodbs.com, kaarel@future.ee, pgsql-advocacy@postgresql.org
Subject: Re: About the default performance
In-Reply-To: <200307210249.h6L2n7315858@candle.pha.pa.us>
References: <Pine.LNX.4.33.0307071159080.4748-100000@css120.ihs.com> <200307210249.h6L2n7315858@candle.pha.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox