From: Anto Aravinth [mailto:anto.aravinth....@gmail.com]
Sent: 28 June 2018 11:34
To: pgsql-generallists.postgresql.org
Subject: Index Gin Creation is taking long time..
Hello,
I'm trying to create an index:
create index search_idx on so2 using gin (to_tsvector('english',posts));
Looks like its running atleast for 8hours :( Totally I have 47M records in so2.
Not sure why its taking so long time.
Any idea or tips to debug while the index creation is going on?
Thanks,
Anto.
· Try increasing maintenance_work_mem and restarting?
https://www.postgresql.org/docs/10/static/gin-tips.html
· “top -p <pid>” can show you if you are CPU or I/O bound.
· “perf top -p <pid>” on the backend that is doing the index creation
is a good way to see where it is spending time.
Good luck!
Steven.
This email is confidential. If you are not the intended recipient, please
advise us immediately and delete this message.
The registered name of Cantab- part of GAM Systematic is Cantab Capital
Partners LLP.
See - http://www.gam.com/en/Legal/Email+disclosures+EU for further information
on confidentiality, the risks of non-secure electronic communication, and
certain disclosures which we are required to make in accordance with applicable
legislation and regulations.
If you cannot access this link, please notify us by reply message and we will
send the contents to you.
GAM Holding AG and its subsidiaries (Cantab – GAM Systematic) will collect and
use information about you in the course of your interactions with us.
Full details about the data types we collect and what we use this for and your
related rights is set out in our online privacy policy at
https://www.gam.com/en/legal/privacy-policy.
Please familiarise yourself with this policy and check it from time to time for
updates as it supplements this notice.
