> Thanks every one for helping me. I have upgraded to 7.4.1 on redhat 8 ( > rh 9 require a lot of lib's) and set the configuration sent by Chris. > Now the query results in 6.3 sec waooo. I m thinking that why the 7.1 > process aggregate slowly. Anyway.
I'm glad we could help you Saleem :) We knew PostgreSQL wasn't that slow :P Chris ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
