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