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