Increasing checkpoint_segments - Any bad thing might happen?
От | Yan Cheng CHEOK |
---|---|
Тема | Increasing checkpoint_segments - Any bad thing might happen? |
Дата | |
Msg-id | 528940.67520.qm@web65704.mail.ac4.yahoo.com обсуждение исходный текст |
Ответы |
Re: Increasing checkpoint_segments - Any bad thing might
happen?
|
Список | pgsql-general |
I realize that, when I have 1 threads perform frequent read, and another 3 threads to perform frequent write. I will getthe following error log *sometimes* 2010-05-07 17:16:10 MYT LOG checkpoints are occurring too frequently (22 seconds apart) 2010-05-07 17:16:10 MYT HINT Consider increasing the configuration parameter "checkpoint_segments". 2010-05-07 17:31:37 MYT LOG checkpoints are occurring too frequently (29 seconds apart) 2010-05-07 17:31:37 MYT HINT Consider increasing the configuration parameter "checkpoint_segments". My observation is, even the above logging happen, "write" operation is success when I exam the content of database. What happen is that, the read operation fail. read thread is spawned after 3 write threads, and read thread will only be considered as "success", only when its read resultis same as what is being written by the 3 threads. The read threads will perform retry for every 200ms, lasted for4 seconds. I was thinking, what is the consequent of increasing "checkpoint_segments", say, from 3 to 6. Any bad thing might happen? Thanks and Regards Yan Cheng CHEOK
В списке pgsql-general по дате отправления: