Re: Compressing WAL
От | Bruce Momjian |
---|---|
Тема | Re: Compressing WAL |
Дата | |
Msg-id | 200504110112.j3B1Cf018664@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Compressing WAL ("Jim C. Nasby" <decibel@decibel.org>) |
Ответы |
Re: Compressing WAL
Re: Compressing WAL |
Список | pgsql-performance |
Jim C. Nasby wrote: > Maybe better for -hackers, but here it goes anyway... > > Has anyone looked at compressing WAL's before writing to disk? On a > system generating a lot of WAL it seems there might be some gains to be > had WAL data could be compressed before going to disk, since today's > machines are generally more I/O bound than CPU bound. And unlike the > base tables, you generally don't need to read the WAL, so you don't > really need to worry about not being able to quickly scan through the > data without decompressing it. I have never heard anyone talk about it, but it seems useful. I think compressing the page images written on first page modification since checkpoint would be a big win. Is this a TODO? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
В списке pgsql-performance по дате отправления: