nixternal wrote about boost library for c++.

with it he was able to find the answer to title question in miliseconds (he didn't specify how many, but let's assume that is was less than 10 ms).

so i decided to check how fast can i do it in postgresql …

Continue reading how many 1sts of any month were sundays – since 1901-01-01?

just lately we found interesting case about shared_buffers settings.

the database in question is rather simple:

• 3 tables
• a bit over 60 gigabytes
• around 150 million rows

the server we run it on is not really fancy:

• 2, single core, 3ghz xeons
• 16 gb of ram
• 6x 72gb, scsi, 15krpm discs in low-end hardware raid 10.

Continue reading shared buffers and their impact on performance