From: | Alvaro Nunes Melo <al_nunes(at)atua(dot)com(dot)br> |
---|---|
To: | PostgreSQL - SQL <pgsql-sql(at)postgresql(dot)org> |
Subject: | Similar tables, different indexes performance |
Date: | 2004-12-13 17:17:49 |
Message-ID: | 1102958269.5855.29.camel@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance pgsql-sql |
Hi,
I know that it's not very polite thing re-send a question, but I don't
have any idea about why can this be happening. I have two almost
identical tables, with equivalent indexes, but their performances are
very different. In this case, I'm sending the queries, explains,
tables'structures and record counts. I think this is the place where I
can most probably get help about performance issues.
Thanks in advance,
--
+---------------------------------------------------+
| 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 |
---|---|---|
text/plain | 5.1 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Vivek Khera | 2004-12-13 17:19:24 | Re: Off-list Re: Alternatives to Dell? |
Previous Message | Bruno Wolff III | 2004-12-13 16:49:52 | Re: INSERT question |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2004-12-13 18:03:03 | Re: Similar tables, different indexes performance |
Previous Message | Tom Lane | 2004-12-13 17:00:25 | Re: Unresolved external: tgetent |