Re: Are bitmap index scans slow to start?

Поиск
Список
Период
Сортировка
От Carlo Stonebanks
Тема Re: Are bitmap index scans slow to start?
Дата
Msg-id 024301ce1572$3fea5560$bfbf0020$@sympatico.ca
обсуждение исходный текст
Ответ на Re: Are bitmap index scans slow to start?  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-performance

<< 

I had thought you were saying that any one ETL procedure into one database used 14 concurrent threads.  But really, each ETL procedure is single-threaded, and there can be up to 5 (or theoretically up to 14) of them running at a time into different databases?
>>

 

Sorry, just caught this.

 

Your first interpretation was correct. Each DB runs an ETL that can have up to 14 concurrent threads. I don’t think the number should be that high, but the engineering team insists the load time is better than fewer threads running faster.

В списке pgsql-performance по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Server stalls, all CPU 100% system time
Следующее
От: Ao Jianwang
Дата:
Сообщение: SELECT is slow on smaller table?