37

I too have a strange problem with PostgreSQL performance for a query.The query that runs below 1s in for certain perod and runs for 20s for some period.but the data volume and every other details remains same for the query that runs for two time period.
If vacuum happen for the table then it should continue in the follow for the entire day right but in the one half its 1s and another half its 20s.How to handle this ?what will be root cause for this