Re: problem with huge joins

From: Kolus Maximiliano <Kolus(dot)maximiliano(at)bcr(dot)com(dot)ar>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: problem with huge joins
Date: 2003-10-31 16:17:45
Message-ID: A56C8EE648A74A4F9653B071E9F7142002086090@bcrweb.bcr.intranet.com.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> > Total runtime: 317046.69 msec

Total runtime: 216001.94 msec

A lot better! Thanks!

> The hash indexes are a waste of time for this :-(

Which kind should I use?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Ayers 2003-10-31 16:25:34 Re: ALTER Table (another)
Previous Message Vivek Khera 2003-10-31 15:53:49 Re: database speed