From: Hannu Krosing <hannu@tm.ee>
To: Jeremiah Jahn <jeremiah@cs.earlham.edu>
Cc: postgres performance <pgsql-performance@postgresql.org>
Subject: Re: cross table indexes or something?
Date: Thu, 27 Nov 2003 00:32:30 +0200
Message-ID: <1069885949.3176.57.camel@fuji.krosing.net> (raw)
In-Reply-To: <1069877651.22346.13.camel@bluejay.goodinassociates.com>
References: <1069877651.22346.13.camel@bluejay.goodinassociates.com>
Jeremiah Jahn kirjutas K, 26.11.2003 kell 22:14:
> I was wondering if there is something I can do that would act similar to
> a index over more than one table.
>
> I have about 3 million people in my DB at the moment, they all have
> roles, and many of them have more than one name.
>
> for example, a Judge will only have one name, but a Litigant could have
> multiple aliases. Things go far to slow when I do a query on a judge
> named smith.
If you dont need all the judges named smith you could try to use LIMIT.
Have you run ANALYZE ? Why does DB think that there is only one judge
with name like SMITH% ?
-------------
Hannu
P.S.
Always send EXPLAIN ANALYZE output if asking for advice on [PERFORM]
-------------
Hannu
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: hannu@tm.ee, jeremiah@cs.earlham.edu
Subject: Re: cross table indexes or something?
In-Reply-To: <1069885949.3176.57.camel@fuji.krosing.net>
* 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