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) ...
Robert Haas, Mar 18, 2014
A few weeks ago, Josh Berkus wrote a blog post on Why HStore2/jsonb is the most important patch of 9.4.  Everybody's going to have their own opinion on these kinds of questions, but for what it's ...
Robert Haas, Mar 13, 2014
Yesterday, Heikki Linnakangas committed this patch: commit a3115f0d9ec1ac93b82156535dc00b10172a4fe7 Author: Heikki Linnakangas Date:   Wed Mar 12 22:46:04 ...
Robert Haas, Mar 10, 2014
In two weeks, I'm headed to LSF/MM and the Linux Collaboration Summit, by invitation of some Linux kernel hackers, to discuss how the Linux kernel can better ...
Robert Haas, Mar 04, 2014
There's a persistent belief among some users of PostgreSQL that VACUUM and VACUUM FULL do the same thing, but that VACUUM FULL does it better.  If VACUUM is the moral equivalent of running the Dust Buster across the room a few times, VACUUM FULL must be the equivalent of hiring a professional cleaning crew to shampoo the ...
Robert Haas, Oct 17, 2013
For the last several months, I have been spending a large percentage of my time trying to bring parallelism to PostgreSQL.  Previous blog posts on the future direction of PostgreSQL development have often mentioned this as a priority, although the top spot has usually been reserved for materialized views, a ...

Follow EnterpriseDB

Stay informed on product announcements, event information, industry news, and more!

Subscribe to the EDB blog 

Follow us on Twitter