Re: [HACKERS] Horrible CREATE DATABASE Performance in High Sierra

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] Horrible CREATE DATABASE Performance in High Sierra
Дата
Msg-id 8950.1507136247@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] Horrible CREATE DATABASE Performance in High Sierra  (Brent Dearth <brent.dearth@gmail.com>)
Ответы Re: [HACKERS] Horrible CREATE DATABASE Performance in High Sierra  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Brent Dearth <brent.dearth@gmail.com> writes:
> Is there an issue tracker I could be looking at to follow along on the
> progress on this issue?

This email thread is pretty much it ...

Current status is that I've filed a bug report with Apple and am waiting
to see their response before deciding what to do next.  If they fix the
issue promptly then there's little need for us to do anything.

If you want to help move things along, it would be useful to run some
experiments and see if there's a way to ameliorate the problem short of
the brute-force answer of disabling copy_file()'s pg_flush_data() call.
One thing that occurs to me is that even a 64KB file copy buffer is pretty
small on any modern machine.  If we were to up that to, say, 1MB, does
that help any?  See COPY_BUF_SIZE in src/backend/storage/file/copydir.c.
        regards, tom lane


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

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

Предыдущее
От: Emre Hasegeli
Дата:
Сообщение: Re: [HACKERS] [PATCH] Improve geometric types
Следующее
От: Sean Chittenden
Дата:
Сообщение: [HACKERS] Re: [PATCH] BUG #13416: Postgres >= 9.3 doesn'tuse optimized shared memory on Solaris anymore