problem in select

From: frank_lupo <frank_lupo(at)email(dot)it>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: problem in select
Date: 2002-09-13 16:32:36
Message-ID: H2DXYC$C1486F01702A693A464B90676F9A802C@email.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

This selection is more fast in ingres vs postgres
Ingres 6.4 0.04 sec
Postgres 7.2 0.42 sec
select titolo,id,anno from ircalend where anno=2002 and id in(select distinct(idcalend) from ircalend_3) order by anno,titolo
because ?

Bye !!
Frank Lupo (Wolf) !!

--
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f

Sponsor:
Se avete deciso di andare in vacanza solo adesso non preoccupatevi da oliviero.it trovate zaini e valigie da riempire con tutto quello che più amate portarvi in vacanza.
Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=731&d=13-9

Responses

Browse pgsql-general by date

  From Date Subject
Next Message king 2002-09-13 16:46:55 sum(if command
Previous Message frank_lupo 2002-09-13 16:13:43 postgres crash