Thanks much for responding guys. I have tried both, building multi column
indexes and GIST, with no improvement. I have reduced the window from 180
days to 30 days and below are the numbers
Composite index - takes 30 secs
With Btree indexing - takes 9 secs
With GIST - takes >30 secs with kind
Hi,
First, sorry to compare Post with other database system, but I know nothing
about Oracle...
This customer have an application made with a framework thats generates the
SQL statements (so, We can't make any query optimizations) .
We did the following tests:
1) Postgresql 9.3 and Oracle 10 in
