Checkpoint in PostgreSQL 9.2

A checkpoint is a point in the transaction log sequence at which all data files have been updated to reflect the information in the log. All data files will be flushed to disk. Refer to for more details about what happens during a checkpoint.

The CHECKPOINT command forces an immediate checkpoint when the command is issued, without waiting for a regular checkpoint scheduled by the system (controlled by the settings in Checkpoints not intended for use during normal operation.

If executed during recovery, the CHECKPOINT command will force a restart point rather than writing a new checkpoint.

Only super users can call CHECKPOINT.

MongoDB: To create a collection Explicitly by using for loop condition:-

 To create a collection Explicitly by using for loop condition:-

MongoDB Enterprise >  for(var i=1; i<=20; i++) db.users.insert({ "Name" : " Test User" + i, "Age" : 50+i, "Gender" : "F", "Country" : "India"});
WriteResult({ "nInserted" : 1 })
MongoDB Enterprise >

MongoDB Enterprise > db.users.find();

{ "_id" : ObjectId("5b7e476f4b924fa09c9684a2"), "Name" : " Test User1", "Age" : 11, "Gender" : "F", "Country" : "India" }

{ "_id" : ObjectId("5b7e476f4b924fa09c9684a3"), "Name" : " Test User2", "Age" : 12, "Gender" : "F", "Country" : "India" }

{ "_id" : ObjectId("5b7e476f4b924fa09c9684a4"), "Name" : " Test User3", "Age" : 13, "Gender" : "F", "Country" : "India" }

{ "_id" : ObjectId("5b7e476f4b924fa09c9684a5"), "Name" : " Test User4", "Age" : 14, "Gender" : "F", "Country" : "India" }

{ "_id" : ObjectId("5b7e476f4b924fa09c9684a6"), "Name" : " Test User5", "Age" : 15, "Gender" : "F", "Country" : "India" }

{ "_id" : ObjectId("5b7e476f4b924fa09c9684a7"), "Name" : " Test User6", "Age" : 16, "Gender" : "F", "Country" : "India" }

{ "_id" : ObjectId("5b7e476f4b924fa09c9684a8"), "Name" : " Test User7", "Age" : 17, "Gender" : "F", "Country" : "India" }

{ "_id" : ObjectId("5b7e476f4b924fa09c9684a9"), "Name" : " Test User8", "Age" : 18, "Gender" : "F", "Country" : "India" }

{ "_id" : ObjectId("5b7e476f4b924fa09c9684aa"), "Name" : " Test User9", "Age" : 19, "Gender" : "F", "Country" : "India" }

{ "_id" : ObjectId("5b7e476f4b924fa09c9684ab"), "Name" : " Test User10", "Age" : 20, "Gender" : "F", "Country" : "India" }

{ "_id" : ObjectId("5b7e476f4b924fa09c9684ac"), "Name" : " Test User11", "Age" : 21, "Gender" : "F", "Country" : "India" }

{ "_id" : ObjectId("5b7e476f4b924fa09c9684ad"), "Name" : " Test User12", "Age" : 22, "Gender" : "F", "Country" : "India" }

{ "_id" : ObjectId("5b7e476f4b924fa09c9684ae"), "Name" : " Test User13", "Age" : 23, "Gender" : "F", "Country" : "India" }

{ "_id" : ObjectId("5b7e476f4b924fa09c9684af"), "Name" : " Test User14", "Age" : 24, "Gender" : "F", "Country" : "India" }

{ "_id" : ObjectId("5b7e476f4b924fa09c9684b0"), "Name" : " Test User15", "Age" : 25, "Gender" : "F", "Country" : "India" }

{ "_id" : ObjectId("5b7e476f4b924fa09c9684b1"), "Name" : " Test User16", "Age" : 26, "Gender" : "F", "Country" : "India" }

{ "_id" : ObjectId("5b7e476f4b924fa09c9684b2"), "Name" : " Test User17", "Age" : 27, "Gender" : "F", "Country" : "India" }

{ "_id" : ObjectId("5b7e476f4b924fa09c9684b3"), "Name" : " Test User18", "Age" : 28, "Gender" : "F", "Country" : "India" }

{ "_id" : ObjectId("5b7e476f4b924fa09c9684b4"), "Name" : " Test User19", "Age" : 29, "Gender" : "F", "Country" : "India" }

{ "_id" : ObjectId("5b7e476f4b924fa09c9684b5"), "Name" : " Test User20", "Age" : 30, "Gender" : "F", "Country" : "India" }

Type "it" for more

MongoDB Enterprise >