Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] Avoiding tuple construction/deconstruction during joining - Mailing list pgsql-hackers

From PFC
Subject Re: [PERFORM] Avoiding tuple construction/deconstruction during joining
Date
Msg-id opsnovnhx0th1vuj@localhost
Whole thread Raw
In response to Avoiding tuple construction/deconstruction during joining  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
    I have asked him for the data and played with his queries, and obtained
massive speedups with the following queries :

http://boutiquenumerique.com/pf/miroslav/query.sql
http://boutiquenumerique.com/pf/miroslav/query2.sql
http://boutiquenumerique.com/pf/miroslav/materialize.sql

    Note that my optimized version of the Big Joins is not much faster that
the materialized view without index (hash joins are damn fast in postgres)
but of course using an index...

pgsql-hackers by date:

Previous
From: Christopher Browne
Date:
Subject: Re: Real-Time Vacuum Possibility
Next
From: PFC
Date:
Subject: Re: [PERFORM] Avoiding tuple construction/deconstruction during joining