> And the patch that was applied gives the same result. > > What is more, I am not seeing the reported speedup - in fact > I am seeing no speedup worth mentioning. > > This is on XP-Pro, with default postgres settings. The test > sets were somewhat larger than thos Magnus used - basically > TPC-H lineitems and orders tables (6m and 1.5m rows respectively).
First, that was Merlin and not me :-) Second, it didn't really show any improvement for him either in his normal test. But when he re-ran it with just the count(*) test it showed improvement. Did you run a count(*) test or some other test? //Magnus ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org