Hi folks!
I've a query with a join of two tables. One table have a 5 millions rows and
child table have a 17 millions rows. The query is executed many times in
application, every 20 seconds aproximately.
The query normally execute in 2-3 seconds but in some time without apparent
pattern the query is hang to 4-6 minutes is too slow to normally
performance.
I've configured 2 things:
1. Each table have indexes. First table have 11 index and second table have
7
2. I configured the VACUUM and ANALYZE run after 20,000 rows inserted.
But apparantly the problem continues
Best Regards!
DRakoROd
-----
Dame un poco de fe, eso me bastará.
Rozvo Ware Solutions
--
View this message in context:
http://www.postgresql-archive.org/The-same-query-is-too-slow-in-some-time-of-execution-tp5951060.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.