Hi,
I have the same issue. After doing "VACCUME ANALYZE"
performance of the query dropped.
Here is the query
explain select * from conversion_table c where
c.conversion_date BETWEEN '2005-06-07' and
'2005-08-17'
Before "VACCUME ANALYZE"
"Index Scan using conversion_table_pk on
keyword_conversi
Thanks for the prompt reply !! Actually migration is inevitable. We have a
totally messed up schema, not normalized and stuff like that. So the goal
of
the migration is to get a new and better normalized schema. That part is
done already. Now the decision point is, should we go with postgres or