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 по дате отправления: