[GENERAL] The same query is too slow in some time of execution

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.