On Fri, 20 Sep 2002, Shridhar Daithankar wrote: > In select test where approx. 15 rows where reported with query on index field, > mysql took 14 sec. and psotgresql took 17.5 sec. Not bad but other issues > eclipse the result..
I don't know about anyone else but I find this aspect strange. That's 1 second (approx.) per row retrieved. That is pretty dire for an index scan. The data/index must be very non unique. -- Nigel J. Andrews ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
