From: | DrakoRod <drakoflames(at)hotmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | The same query is too slow in some time of execution |
Date: | 2017-03-21 23:27:20 |
Message-ID: | 1490138840922-5951060.post@n3.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2017-03-21 23:45:48 | Re: The same query is too slow in some time of execution |
Previous Message | Steve Atkins | 2017-03-21 22:36:37 | Re: mysql_config_editor feature suggestion |