From: | Markus Wagner <wagner(at)imsd(dot)uni-mainz(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | optimizing record matching |
Date: | 2001-10-25 11:41:48 |
Message-ID: | 01102513414801.25924@magnus |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
we have a very large table (about 1 million entries), and we have an "add"
operation that will check a new entry for equality or similarity with all of
the existing entries. The generated SQL queries look like that:
SELECT pid FROM rec WHERE (((f_lname_PC = '2C38D2E44501ED31778E0EFDFD5200CD'
OR f_lname_PH = 'CB85F68FFDDECD7CC39AF5BC2FBC0BBC') OR (f_lname_PC IS NULL OR
f_lname_PH IS NULL)) AND (f_fname_PC = '3A160A9BFF2EA5A0918F5F6667A411A7' OR
f_fname_PH = '5152F1177F0BD28FB51501597669962E') AND f_bd =
'9E6E0D70A9B76BB6990477FCF100557E' AND f_bm =
'4BE74390684A423853B68B9F05A4BAA0' AND f_by =
'15FF84F58774D638B1C4EC82B413EBA9');
We have set indices for each of the fields (f_*), but the matching process
doesn't seem to become faster.
Are there any things we could improve, e. g. special index types or things
like that?
Thanks,
Markus
From | Date | Subject | |
---|---|---|---|
Next Message | steve boyle | 2001-10-25 12:06:36 | Re: Importing Access 97 Database into 7.1.3 |
Previous Message | Aaron Rouse | 2001-10-25 11:10:42 | Re: Importing Access 97 Database into 7.1.3 |