On 29 Apr 2004 at 15:35, Kenneth Marshall wrote: > Did you try to cluster based on the index? > > --Ken
Yes, This speeds up the index scan a little (12%). This to me just reinforces the overhead that subsequently having to go and fetch the data tuple actually has on the performance. Cheers, Gary. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org