Re: [HACKERS] Serious performance problem

> > 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