Bottlenecks with large number of relation segment files

Поиск
Список
Период
Сортировка
От Amit Langote
Тема Bottlenecks with large number of relation segment files
Дата
Msg-id CA+HiwqEmgaVoMwSFcXOoxNB-bnGHaEwEPwrs5R+do5Uzt2G-3Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: [GENERAL] Bottlenecks with large number of relation segment files  (KONDO Mitsumasa <kondo.mitsumasa@lab.ntt.co.jp>)
Список pgsql-hackers
Hello,

I am looking the effect of having large number of relation files under
$PGDATA/base/ (for example, in cases where I choose lower segment size
using --with-segsize). Consider a case where I am working with a large
database with large relations, for example a database similar in size
to what "pgbench -i -s 3500" would be.

May the routines in fd.c become bottleneck with a large number of
concurrent connections to above database, say something like "pgbench
-j 8 -c 128"? Is there any other place I should be paying attention
to?

--
Amit Langote


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

Предыдущее
От: "Etsuro Fujita"
Дата:
Сообщение: Re: query_planner() API change
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Re: ALTER SYSTEM SET command to change postgresql.conf parameters (RE: Proposal for Allow postgresql.conf values to be changed via SQL [review])