Re: problem with large maintenance_work_mem settings and

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: problem with large maintenance_work_mem settings and
Дата
Msg-id 16339.1141589703@sss.pgh.pa.us
обсуждение исходный текст
Ответ на problem with large maintenance_work_mem settings and CREATE INDEX  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Ответы Re: problem with large maintenance_work_mem settings and  (Simon Riggs <simon@2ndquadrant.com>)
Re: problem with large maintenance_work_mem settings and  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Stefan Kaltenbrunner <stefan@kaltenbrunner.cc> writes:
> samples  %        symbol name
> 24915704 96.2170  ltsReleaseBlock
> 387265    1.4955  LogicalTapeRead
> 168725    0.6516  inlineApplySortFunction

Hmm ... the comment in ltsReleaseBlock sez
   /*    * Insert blocknum into array, preserving decreasing order (so that    * ltsGetFreeBlock returns the lowest
availableblock number). This could    * get fairly slow if there were many free blocks, but we don't expect    * there
tobe very many at one time.    */
 

We probably need to tweak things so this doesn't get called during the
"final merge" pass.  Looking at it now.
        regards, tom lane


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

Предыдущее
От: "Markus Bertheau"
Дата:
Сообщение: pg.conf re-reading in signal handler or at next return to main loop?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [PATCHES] LDAP auth