SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-12-2008, 07:27 AM
| ||||
| ||||
 Re: COMMIT NOWAIT Performance Option Jonah H. Harris wrote: > On 2/28/07, Bruce Momjian <bruce@momjian.us> wrote: > > Am am not comfortable starting and having something fail later. > > Then do you have some other idea for protecting pages from being torn > without storing an entire backup copy or performing a block-level > consistency check? We have several methods suggested to check the blocks, like CRC. My point was that, whatever check method we use, we should be prepared to check on startup, or at least make it the default for a crash restart. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly      |
|
04-12-2008, 07:27 AM
| |||
| |||
| Re: COMMIT NOWAIT Performance Option On 2/28/07, Bruce Momjian <bruce@momjian.us> wrote: > We have several methods suggested to check the blocks, like CRC. My > point was that, whatever check method we use, we should be prepared to > check on startup, or at least make it the default for a crash restart. Sounds like it should be a guc. I most certainly wouldn't check the entire database, especially if it was over a gigabyte. -- Jonah H. Harris, Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: 732.331.1301 33 Wood Ave S, 3rd Floor | jharris@enterprisedb.com Iselin, New Jersey 08830 | http://www.enterprisedb.com/ ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match |
|
04-12-2008, 07:27 AM
| ||||
| ||||
| Re: COMMIT NOWAIT Performance Option Jonah H. Harris wrote: > On 2/28/07, Bruce Momjian <bruce@momjian.us> wrote: > > We have several methods suggested to check the blocks, like CRC. My > > point was that, whatever check method we use, we should be prepared to > > check on startup, or at least make it the default for a crash restart. > > Sounds like it should be a guc. I most certainly wouldn't check the > entire database, especially if it was over a gigabyte. Keep in mind if you don't check it on startup, you will be checking it for every read, which for rare crashes, might not be wise. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend |
Linear Mode
