Re: [PERFORM] Need help to decide Mysql vs Postgres

2005-05-25 Thread Philip Hallstrom
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

Re: [PERFORM] Weird performance drop after VACUUM

2005-08-26 Thread Philip Hallstrom
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