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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
