Re: Speed question - new view using preview view components

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Speed question - new view using preview view components
Date: 2010-03-22 08:07:31
Message-ID: 20100322080731.GA30841@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

In response to richard terry :
> I wondered if when creating a new view from multiple tables, and then also
> joining to some fields of an existing view, if one pays much of a speed
> penalty when the data is retrieved, as opposed to just completely using all
> tables.

Depends.

The upcoming release 9.0 contains a new feature called 'join removal'.

http://akretschmer.blogspot.com/2010/02/join-removal-short-performance-test.html

Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Greg Stark 2010-03-22 15:56:29 Re: PostgreSQL questions
Previous Message Lew 2010-03-21 19:59:41 Re: DESIGN OF A SELECT QUERY