View Single Post

   
  #2 (permalink)  
Old 04-12-2008, 08:27 AM
Jonah H. Harris
 
Posts: n/a
Default 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

Reply With Quote