When I first started playing with MongoDB I accidentially posted my posts in a category that got them put up on Planet PostgreSQL. I remember getting some pretty pissed off emails and comments. Beyond just my mistake such that the posting was on the incorrect blog, people seemed pretty pissed off about NoSQL in general…. Read more »
Posts Categorized: PostgreSQL
The folks over at NoSQLDatabases.com have posted an interview they did with me on our implementation of MongoDB at Shutterfly. Good folks, great blog. Here is a link to the article. I talk a lot about what we have done at Shutterfly, In particular one item I discuss is ORM’s and the promise of not… Read more »
I came across this old article I wrote for the NOCOUG newsletter in 2002 about using OS snapshots for backups. This technique is still very much a valid and widely used technique to perform backups. The idea is simple: – Stop I/O temporarily – Snapshot the filesystem (OS snapshot, rsync, whatever) – Release I/O -… Read more »
I added a couple of fixes to the code and released it as 1.0. We have been using it here at hi5 for some time w/o problems. Thanks everyone who has helped with feedback. Also thanks to Devrim GUNDUZ for his help. The latest version can be downloaded on pgfoundry.
At Hi5, we currently use pg_reorg1.0.3 in order to organize data in a clustered fashion. I posted previously about the strategy. Our version is slightly modified, the modifications I made to the C code essentially allow pg_reorg to spin/wait for locks on the objects to be released before proceeding. The good news is the folks… Read more »
I got the opportunity to test out some of the new Fusion-io Solid State ioDrive, and I thought I would post some results. Fusion-io has created a SSD product called ioDrive that is based on PCIe cards vs replacing SAS or SATA drives with SSD directly. This approach allows for much lower latency because of… Read more »
I moved the pgstat (previously named pgd) project to pgfoundry. Thank you to the folks over there approving the project. I added a column for ‘active’ processes from pg_stat_activity as well as some fixes requested by Devrim that I really should have had done from the start. Thanks for the contribution. Downloads can be found… Read more »
Since the economy is not exactly rocking these days, I suspect there are a lot of companies out there trying to save a buck or two on infrastructure. Databases are not exactly cheap, so anything that an engineer or DBA can do to save cycles is a win. So how do you stretch your existing… Read more »
The debate about the optimum shared_buffers size in PostgreSQL is clearly far from over. However, I have not seen any results where the buffer cache and the FS cache were tuned in unison. Because PostgreSQL knows what buffers are in use, and knows when to flush the dirty buffers it is ideal to use as… Read more »
If you’re using the pgd pgstat utility I posted about previously, you can graph the output with very little effort using gnuplot. In my case I use pgd pgstat for capturing output for various PostgreSQL performance tests, and of course graphing that output is important.