Re: [GENERAL] slow queries

From: "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk>
To: Thomas Good <tomg(at)nrnet(dot)org>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] slow queries
Date: 1998-09-18 15:19:20
Message-ID: 199809181519.QAA14702@linda.lfix.co.uk
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.

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP key from public servers; key ID 32B8FAA1
========================================
"Give, and it shall be given unto you; good measure,
pressed down, and shaken together, and running over,
shall men pour into your lap. For by your standard of
measure it will be measured to in return."
Luke 6:38

Browse pgsql-general by date

  From Date Subject
Next Message Anand Surelia 1998-09-18 15:32:19 Foreign Key
Previous Message David Hartwig 1998-09-18 14:37:49 Re: [GENERAL] slow queries