Re: WAL Bypass for indexes
От | Christopher Kings-Lynne |
---|---|
Тема | Re: WAL Bypass for indexes |
Дата | |
Msg-id | 44307DCC.3050508@calorieking.com обсуждение исходный текст |
Ответ на | Re: WAL Bypass for indexes (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-hackers |
> Martin's proposal at least looks sensible; he just hasn't quite made the > case that it's worth doing. If you're running a system that hardly ever > crashes, you might be willing to accept index rebuilds during crash > recovery, especially for indexes on relatively small, but frequently > updated, tables (which should have reasonably short rebuild times). > Obviously this would have to be configurable per-index, or at least > per-table, and I agree that it likely would never be the default. > But it could be a good tradeoff for some cases. My web system hasn't crashed in years, and last time I upgraded the index rebuild time was maybe 30 mins? So, I think a typical web application doesn't _really_ have that much data, and would greatly benefit from cranking the TPS. Chris
В списке pgsql-hackers по дате отправления: