Hello All,
Thank you very much for your help. You have really helped me out!
The query is now as fast as the others.
The indexes ix_companyarticledb_article and ix_companyarticledb_company are
removed.
The parameter for default_statistics_target was set to 1000
ANALYZE was performed on
Hello,
Things to Try Before You Post
-> I went through these steps and they did not bring any difference.
Information You Need To Include
Postgres version
"PostgreSQL 10.6 on x86_64-pc-linux-gnu, compiled by gcc (Debian
6.3.0-18+deb9u1) 6.3.0 20170516, 64-bit"
Full Table and Index Schema
The
Hi,
thank you for your reply.
Yes, I will go through this page.
Regards,
Kim
Op ma 25 feb. 2019 om 17:16 schreef Justin Pryzby :
> On Mon, Feb 25, 2019 at 03:41:18AM -0700, Kim wrote:
> > Is there any way how I can make the queries fast for new participants?
> This
> > is a big problem,
