pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (14+ messages)  latest in thread

Message-ID: <1069885949.3176.57.camel@fuji.krosing.net>
Permalink:  ../1069885949.3176.57.camel@fuji.krosing.net/
Also on:    postgresql.org/message-id/1069885949.3176.57.camel@fuji.krosing.net

 · 

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