From: CoL <col@mportal.hu>
To: pgsql-performance@postgresql.org
Subject: Re: Looking for ideas on how to speed up warehouse loading
Date: Fri, 23 Apr 2004 01:05:20 +0200
Message-ID: <c69j1e$27jc$1@news.hub.org> (raw)
In-Reply-To: <40883FAB.3070109@earthlink.net>
References: <40883FAB.3070109@earthlink.net>
hi,
Sean Shanny wrote, On 4/22/2004 23:56:
>
> SELECT t1.id, t2.url FROM referral_temp t2 LEFT OUTER JOIN d_referral t1
> ON t2.url = t1.referral_raw_url ORDER BY t1.id
index on url (text) has no sense. Try to use and md5 (char(32) column)
which contains the md5 hash of url field. and join these ones. You can
have a better index on this char 32 field.
do not forget to analyze the tables after data load, and you can fine
tune you postgresql.conf, default_statistics_target for better index
info, and others.
check this info pages:
http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.htmlhttp://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
C.
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: col@mportal.hu
Subject: Re: Looking for ideas on how to speed up warehouse loading
In-Reply-To: <c69j1e$27jc$1@news.hub.org>
* 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