Nigel J. Andrews wrote: > 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. >
Yeah, I'd agree that is strange. Can we see EXPLAIN ANALYZE for that query. Also, in one of your ealier posts you mentioned a slowdown after raising shared buffers from the default 64 to 30000. You might have driven the machine into swapping. Maybe try something more like 10000 - 15000. HTH, Joe ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html