Yes, casting the result improved the time response a lot. Thank you! Reimer > -----Mensagem original----- > De: pgsql-performance-owner@xxxxxxxxxxxxxx > [mailto:pgsql-performance-owner@xxxxxxxxxxxxxx]Em nome de Tom Lane > Enviada em: quinta-feira, 11 de janeiro de 2007 16:31 > Para: carlos.reimer@xxxxxxxxxxxxx > Cc: pgsql-performance@xxxxxxxxxxxxxx > Assunto: Re: [PERFORM] Improving SQL performance > > > "Carlos H. Reimer" <carlos.reimer@xxxxxxxxxxxxx> writes: > > I know that the problem with the following SQL is the "LOG.CODCEP = > > ENDE.CODCEP||CODLOG" condition, but what can I > > do to improve the performance? > > Seems the problem is not using an index for tt_log. Do you have an > index on tt_log.codcep? If so, maybe you need to cast the result of > the concatenation to char(8) to get it to use the index. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > >
