Re: [HACKERS] increasing the default WAL segment size

Поиск
Список
Период
Сортировка
От Jim Nasby
Тема Re: [HACKERS] increasing the default WAL segment size
Дата
Msg-id ed647eac-d911-c2cb-5ba0-ae3a25b90f4f@BlueTreble.com
обсуждение исходный текст
Ответ на Re: [HACKERS] increasing the default WAL segment size  (Kuntal Ghosh <kuntalghosh.2007@gmail.com>)
Ответы Re: [HACKERS] increasing the default WAL segment size  (Kuntal Ghosh <kuntalghosh.2007@gmail.com>)
Re: [HACKERS] increasing the default WAL segment size  (Beena Emerson <memissemerson@gmail.com>)
Re: [HACKERS] increasing the default WAL segment size  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On 2/24/17 6:30 AM, Kuntal Ghosh wrote:
> * You're considering any WAL file with a power of 2 as valid. Suppose,
> the correct WAL seg size is 64mb. For some reason, the server
> generated a 16mb invalid WAL file(maybe it crashed while creating the
> WAL file). Your code seems to treat this as a valid file which I think
> is incorrect. Do you agree with that?

Detecting correct WAL size based on the size of a random WAL file seems 
like a really bad idea to me.

I also don't see the reason for #2... or is that how initdb writes out 
the correct control file?
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)



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

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: [HACKERS] Partitioned tables and relfilenode
Следующее
От: Kyotaro HORIGUCHI
Дата:
Сообщение: Re: [HACKERS] Restricting maximum keep segments by repslots