Re: [GENERAL] slow queries - Mailing list pgsql-general

From Howie
Subject Re: [GENERAL] slow queries
Date
Msg-id Pine.LNX.3.96.980921001225.26960I-100000@brap-eth0.toodarkpark.org
Whole thread Raw
In response to Re: [GENERAL] slow queries  (Thomas Good <tomg@admin.nrnet.org>)
List pgsql-general
On Fri, 18 Sep 1998, Thomas Good wrote:

> On Fri, 18 Sep 1998, David Hartwig wrote:
>
> > I would like to see it!   I was not aware that table aliasing could
> > have any impact on performance.
>
> [SNIP]
> I was a bit amazed myself.  Federico Passaro, on the SQL list,
> helped me out some time ago when a query was failing.
> His code worked so well that I filed it away for a rainy day...
> this week I decided to try it and see if it helped hasten my
> slooooowest query.  It did.
> [SNIP]

seems that by creating a view ( with the query i mentioned before ), my
queries were sped up by roughly 10 seconds... odd odd odd.

---
Howie <caffeine@toodarkpark.org>   URL: http://www.toodarkpark.org
[[NSNotificationCenter defaultCenter] addObserver:systemAdministrator
  selector:@selector(disableUserAccount:) name:@"UserIsWhining" object:aLuser];




pgsql-general by date:

Previous
From: Anand Surelia
Date:
Subject: Timestamp
Next
From: "Michael Ansley"
Date:
Subject: Win32 libpq libraries