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
Re: problem with large maintenance_work_mem settings and |
Список | 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 по дате отправления: