During a single query write of approximately 300,000 rows with 30 columns all indexed, I noticed that only one core was maxed at a time.
Is there any way to calculate indexes multithreaded for single inserts?
Take the 2-minute tour
×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
|
|
Unfortunately, no. PostgreSQL backends are single-threaded, and a single connection can use only one backend. There's work to enhance this, but it's a seriously difficult and big job because of PostgreSQL's process-based architecture. The only real option is to split the insert its self into multiple concurrent connections, each doing part of the work. |
|||||||||
|
