Re: Checkpoint cost, looks like it is WAL/CRC

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Checkpoint cost, looks like it is WAL/CRC
Дата
Msg-id Pine.OSF.4.61.0507081634050.187984@kosh.hut.fi
обсуждение исходный текст
Ответ на Re: Checkpoint cost, looks like it is WAL/CRC  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Thu, 7 Jul 2005, Tom Lane wrote:

> We still don't know enough about the situation to know what a solution
> might look like.  Is the slowdown Josh is seeing due to the extra CPU
> cost of the CRCs, or the extra I/O cost, or excessive locking of the
> WAL-related data structures while we do this stuff, or ???.  Need more
> data.

I wonder if a different BLCKSZ would make a difference either way. Say, 
1024 bytes instead of the default 8192.

- Heikki


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Checkpoint cost, looks like it is WAL/CRC
Следующее
От: Dennis Bjorklund
Дата:
Сообщение: Re: SQL99 - Nested Tables