pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: PFC <lists@boutiquenumerique.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
To: pgsql-hackers@postgresql.org
Cc: Miroslav Ć ulc <miroslav.sulc@startnet.cz>
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Avoiding tuple construction/deconstruction during joining
Date: Tue, 15 Mar 2005 18:17:31 +0100
Message-ID: <opsnovnhx0th1vuj@localhost> (raw)
In-Reply-To: <14577.1110821062@sss.pgh.pa.us>
References: <42345D24.8070104@startnet.cz>
	<14577.1110821062@sss.pgh.pa.us>


	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...



view thread (6+ messages)  latest in thread

Message-ID: <opsnovnhx0th1vuj@localhost>
Permalink:  ../opsnovnhx0th1vuj@localhost/
Also on:    postgresql.org/message-id/opsnovnhx0th1vuj@localhost

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: lists@boutiquenumerique.com, tgl@sss.pgh.pa.us, pgsql-hackers@postgresql.org, miroslav.sulc@startnet.cz
  Subject: Re: [PERFORM] Avoiding tuple construction/deconstruction during joining
  In-Reply-To: <opsnovnhx0th1vuj@localhost>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox