Hello,
thanks for the response. I did not get the response to my email even though I am subscribed to the pgsql-performance mail list. Let's hope that I get the next one :)
Increasing work_mem did not have great impact on the performance. But I will try to update the PostgreSQL version to see if it speeds up things.
However is there way to keep query time constant as the database size grows. Should I use partitioning or partial indexes?
Best Regards,
Tommi Kaksonen