> 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