On 03/21/2017 04:27 PM, DrakoRod wrote:
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
Well without seeing the query, the EXPLAIN ANALYZE of the query, the
table schema(including indexes), the Postgres version, Postgres log info
from the 'problem' times, system resource values and so on, there is
really no way to answer this.
For a longer version of the above see:
https://wiki.postgresql.org/wiki/Guide_to_reporting_problems
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.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
