Robert

Author Archive: Robert Haas
Robert Haas, Chief Architect, Database Server

Robert is Chief Architect, Database Server, employed at EnterpriseDB as well as a PostgreSQL Committer. PostgreSQL Contributor and Committer. Expert in OLTP query tuning, schema design, triggers and stored procedures, and internals development. Experienced UNIX/Linux system administrator. Full-life-cycle web developer: needs analysis, application design, database schema design, user interface design, development, testing, user training and acceptance testing, maintenance.

Robert Haas, Apr 01, 2015
PostgreSQL has three shutdown modes: smart, fast, and immediate.  For many years, the default has been "smart", but Bruce Momjian has just committed a patch to change the default to "fast" ...
Robert Haas, Mar 18, 2015
Amit Kapila and I have been working very hard to make parallel sequential scan ready to commit to PostgreSQL 9.5.  It is not all there yet, but we are making very good progress.  I'm very grateful to everyone in the PostgreSQL community who has helped us with review and ...
Robert Haas, Feb 12, 2015
A very popular standalone NoSQL database solution came under criticism about their security posture this week. It’s not the kind of publicity a database company – or any company for that matter – relishes. Although the vulnerability seems to have been less a problem with the core database than with insecure default ...
Robert Haas, Dec 22, 2014
It's been over a year since I last blogged about parallelism, so I think I'm past due for an update, especially because some exciting things are happening. First, Amit Kapila has published a
Robert Haas, Aug 06, 2014
Database performance and hardware selection are complicated topics, and a great deal has been written on that topic over the years by many very smart people, like Greg Smith, who wrote a whole book about PostgreSQL ...
Robert Haas, Jun 10, 2014
Last week, Linus Torvalds merged a Linux kernel commit from Mel Gorman disabling vm.zone_reclaim_mode by default.   I mentioned that this change might be in the works when
Robert Haas, May 13, 2014
When your database gets corrupted, one of the most important things to do is figure out why that happened, so that you can try to ensure that it doesn't happen again.  After all, there's little point in going to a lot of trouble to restore a ...
Robert Haas, Apr 16, 2014
Last month, ZDNet published an interview with MongoDB CEO Max Schireson which took the position that the document databases, such as MongoDB, are better-suited to today's applications than traditional relational databases; ...
Robert Haas, Apr 02, 2014
In addition to talking about PostgreSQL at LSF/MM and Collab, I also learned a few things about the Linux kernel that I had not known before, some of which could have implications for PostgreSQL performance.  These are issues which I haven't heard ...
Robert Haas, Mar 31, 2014
Last week, I attended the Linux Storage, Filesystems, and Memory Management summit (LSF/MM) on Monday and Tuesday, and the Linux Collaboration Summit (aka Collab) ...