Re: [HACKERS] Serious performance problem - Mailing list pgsql-general

From Jean-Michel POURE
Subject Re: [HACKERS] Serious performance problem
Date
Msg-id 4.2.0.58.20011030110619.00a515e0@pop.freesurf.fr
Whole thread Raw
Responses Re: [HACKERS] Serious performance problem  ("Tille, Andreas" <TilleA@rki.de>)
List pgsql-general
> > CREATE TABLE foo AS
> > SELECT Hauptdaten_Fall.MeldeKategorie, Count(Hauptdaten_Fall.ID) AS Anz
> > FROM Hauptdaten_Fall WHERE (((Hauptdaten_Fall.IstAktuell)=20))
> > GROUP BY Hauptdaten_Fall.MeldeKategorie ORDER BY
> > Hauptdaten_Fall.MeldeKategorie;
>Sorry, this is NO solution of my problem.

Allo Andreas,

For every problem there is a solution. That is what software optimization
is all about. Do you make use of PL/pgSQL stored queries in your database?
If not, you will probably end up with terrible nested queries that will
eat-up server time and power.

Best regards,
Jean-Michel POURE

pgsql-general by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: resend: Chinese sort order problem
Next
From: Gunnar Lindholm
Date:
Subject: how do the pro's do this? (still a newbie)