The dangers of "-F"
От | Don Baccus |
---|---|
Тема | The dangers of "-F" |
Дата | |
Msg-id | 3.0.1.32.19990622151155.006c92c8@mail.pacifier.com обсуждение исходный текст |
Ответы |
Re: [HACKERS] The dangers of "-F"
|
Список | pgsql-hackers |
I've mentioned in the past that the fsynch following every select, even when no data is modified, is a killer for high-volume web sites that make many short, read-only hits on the database (for page customization, for example). I know that fixing this is on the "to do" list. I've known of the "-F" switch for some time, but the recent round of posts triggered by someone observing lots of disk thrashing and the fact that I'm getting close to going online with my first round of web services based on Postgres motivated me to give it a try. It's very, very nice to have the disk silent when hitting it with a bunch of simultaneous "selects" from different http connections. It really increases throughput, and is much, much kinder to the disk. The difference for lots of short hits is very high. So obviously I'm really looking forward to the day when a read-only select doesn't trigger a write to pg_log (which apparently is the problem?) and an "fsynch the world" operation. In the interim, just how dangerous is it to run with "-F"? Am I risking corruption of the db and a total rebuild, or will I just lose transactions but be left with a consistent database if the machine goes down? - Don Baccus, Portland OR <dhogaza@pacifier.com> Nature photos, on-line guides, and other goodies at http://donb.photo.net
В списке pgsql-hackers по дате отправления: