Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Serious performance problem

From: Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>
To: "Tille, Andreas" <TilleA(at)rki(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [HACKERS] Serious performance problem
Date: 2001-10-30 10:17:51
Message-ID: 4.2.0.58.20011030110619.00a515e0@pop.freesurf.fr (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
> > 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

In response to

Responses

pgsql-hackers by date

Next:From: Hannu KrosingDate: 2001-10-30 10:20:57
Subject: Re: Serious performance problem
Previous:From: Dave PageDate: 2001-10-30 10:02:00
Subject: Re: DROP/CREATE

pgsql-general by date

Next:From: Andy HallamDate: 2001-10-30 10:21:44
Subject: Re: Turn on mylog debugging
Previous:From: Tille, AndreasDate: 2001-10-30 09:42:16
Subject: Re: Serious performance problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group