From: | Alvaro Nunes Melo <al_nunes(at)atua(dot)com(dot)br> |
---|---|
To: | Pgsql-Performance <pgsql-performance(at)postgresql(dot)org> |
Subject: | Very different index usage on similar tables |
Date: | 2004-12-11 17:01:24 |
Message-ID: | 1102784484.4166.8.camel@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hi,
I have two similar tables in a database, one stores persons and the
other stores telephones. They have a similar number of records (around
70.000), but a indexed search on the persons' table is way faster than
in the telephones' table. I'm sending the explains atacched, and I
believe that the problem can be in the fact the the explain extimates a
worng number of rows in the telefones' explain. I'm sending the explains
atacched, and the table and columns' names are in Portuguese, but if it
makes easier for you guys I can translate them in my next posts.
The in dex in the telephone table is multicolumn, I'd tried to drop it
and create a single-column index, but the results were quite the same.
Thanks,
--
+---------------------------------------------------+
| Alvaro Nunes Melo Atua Sistemas de Informacao |
| al_nunes(at)atua(dot)com(dot)br www.atua.com.br |
| UIN - 42722678 (54) 327-1044 |
+---------------------------------------------------+
Attachment | Content-Type | Size |
---|---|---|
explains | text/plain | 3.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-12-11 18:06:23 | Re: LIMIT causes SEQSCAN in subselect |
Previous Message | Michael Fuhr | 2004-12-11 16:25:39 | Re: [GENERAL] Query is not using index when it should |