Postgres Pro
Downloads
Home   >   mailing lists

Re: order of clauses - Mailing list pgsql-general

From Dan Wilson
Subject Re: order of clauses
Date
Msg-id 002d01c0984d$c8877c40$533987cf@corp.peoplesoft.com
Whole thread Raw
In response to Re: order of clauses  (Michael Fork <mfork@toledolink.com>)
Responses Re: order of clauses  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Tree view 
: SELECT a.x/b.y FROM vals a, (SELECT y FROM vals WHERE y > 0) b WHERE (a.x
: / b.y) > 1;

How much of a performance hit is there when using a select in the FROM
clause?  Is it even noticeable?  How much better is it to create a static
view?

-Dan

pgsql-general by date:

Previous
From: edmund@lillypad.ecclestoad.co.uk
Date:
Subject: Storing double-byte strings in text fields.
Next
From: "[Bad-Knees]"
Date:
Subject: initdb: pg_encoding failed