Re: [GENERAL] slow queries

From: "Wim Ceulemans" <wim(dot)ceulemans(at)pophost(dot)eunet(dot)be>
To: <pgsql-general(at)postgreSQL(dot)org>
Subject: Re: [GENERAL] slow queries
Date: 1998-09-18 17:47:35
Message-ID: 003801bde32c$6b7ea510$67faa8c0@aladdin.nice.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>Thomas Good wrote:
> >I have a query that looks up a patient's placement (which ward)
> >in one table and then looks up diagnostic and demographic data
> >in another...takes 53 seconds. Ouch.
> >
> >However, when I use table aliasing...the query output is on the
> >screen *before* I submit the query. ;-)
> >
> >I'll send syntax, if you like.
>
>Please do, to the list. I have never heard of 'table aliasing' and would
>like to know more.
>

I'm also very interested in this table aliasing.

Regards
Wim

Browse pgsql-general by date

  From Date Subject
Next Message Anand Surelia 1998-09-18 17:56:42 Re:Foreign Keys
Previous Message Postgres 1998-09-18 16:48:09 improving performance with more -B buffers?