| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andy Hallam | 2001-10-30 10:21:44 | Re: Turn on mylog debugging |
| Previous Message | Tille, Andreas | 2001-10-30 09:42:16 | Re: Serious performance problem |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hannu Krosing | 2001-10-30 10:20:57 | Re: Serious performance problem |
| Previous Message | Dave Page | 2001-10-30 10:02:00 | Re: DROP/CREATE |