Re: _mdfd_getseg can be expensive

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: _mdfd_getseg can be expensive
Дата
Msg-id 20160701020851.4ln3bdjwjhfmivje@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: _mdfd_getseg can be expensive  (Peter Geoghegan <pg@heroku.com>)
Ответы Re: _mdfd_getseg can be expensive  (Peter Geoghegan <pg@heroku.com>)
Список pgsql-hackers
On 2016-06-30 18:34:20 -0700, Peter Geoghegan wrote:
> On Thu, Jun 30, 2016 at 6:23 PM, Andres Freund <andres@anarazel.de> wrote:
> > I plan to, once the tree opens again. Likely needs some considerable
> > updates for recent changes.
> 
> Offhand, do you think that CREATE INDEX calls to smgrextend() could be
> appreciably affected by this bottleneck? If that's a very involved or
> difficult question, then no need to answer now.

If you have a big enough index (maybe ~150GB+), sure. Before that,
probably not.

It's usually pretty easy to see in cpu profiles whether this issue
exists.

Andres



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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Is a UDF binary portable across different minor releases and PostgreSQL distributions?
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: OpenSSL 1.1 breaks configure and more