Re: Postgres performance comments from a MySQL user

From: Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar>
To: jim(at)nasby(dot)net
Cc: Kaarel <kaarel(at)future(dot)ee>, Justin Clift <justin(at)postgresql(dot)org>, Jay O'Connor <joconnor(at)cybermesa(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres performance comments from a MySQL user
Date: 2003-06-13 11:42:51
Message-ID: 200306130842.52119.martin@bugs.unl.edu.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Jue 12 Jun 2003 18:52, Jim C. Nasby wrote:
> On Thu, Jun 12, 2003 at 10:15:32AM -0300, Martin Marques wrote:
> > You can't expect to have a good DB server if you didn't take the time
> > to read the performance tips on the PostgreSQL Administration Guide,
> > and gone through the postgresql.conf file.
> > The same goes for any server, httpd, MTA, etc. For small load a
> > default Apache, or default Postfix will work OK, but on heavy load
> > you have to make tuning, or the system will fall to pieces.
>
> Is there a performance section in the *Admin* guide? I only see one in
> the user's guide.

Section 3.4 and 3.5 (really all 3) should be read after installing
PostgreSQL to get better performance.
I can't remember well, but I think Bruce Momjian wrote something about
performace tips.

--
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-----------------------------------------------------------------
Martín Marqués | mmarques(at)unl(dot)edu(dot)ar
Programador, Administrador, DBA | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christoph Haller 2003-06-13 12:04:51 Re: query plan and parenthesis
Previous Message Jan Poslusny 2003-06-13 11:41:58 Re: query plan and parenthesis