Whether or not you made it our CHAR(10) conference last month, you can now relive part of the experience by downloading the conference slides. Some of those were posted live during the conference, some showed up later, but almost everything is there now. Sadly, Nic Ferrier’s entertaining presentation about how WooMe (acquired by Zoosk) was scaled […]
Heads in the cloud at CHAR(10)
/0 Comments/in Greg's PlanetPostgreSQL, International News, PostgreSQL /by 2ndQuadrant PressWhether or not you made it our CHAR(10) conference last month, you can now relive part of the experience by downloading the conference slides. Some of those were posted live during the conference, some showed up later, but almost everything is there now. Sadly, Nic Ferrier’s entertaining presentation about how WooMe (acquired by Zoosk) was scaled […]
Installing Greenplum Single Node Edition on Ubuntu 10.4 (Lucid)
/0 Comments/in Greenplum /by Marco NenciariniOfficially Greenplum Database Single Node Edition (SNE) is only installable on Red Hat Enterprise Linux (RHEL) and SUSE Linux Enteprise Server (SLES), but while surfing the web I have seen many requests on how to install it on Debian/Ubuntu. Here I’m trying to give you some advices.
Installing PostGIS on Greenplum Single Node Edition
/3 Comments/in Greenplum /by Gabriele BartoliniOne of the main reasons users switch from other relational databases to PostgreSQL is the advanced support for geographic objects included in the PostGIS extension. Being PostgreSQL specialists at 2ndQuadrant, we have tried to investigate if it was possible (and how) to install PostGIS on the Greenplum Single Node edition. Let’s see how Marco Nenciarini, […]
Some ideas about low-level resource pooling in PostgreSQL
/0 Comments/in Gianni's PlanetPostgreSQL, PostgreSQL /by Gianni CiolliLast week at the CHAR(10) conference we had a workshop on “Cloud Databases”. To put it simply: what to do when the use case requirements exceed the resources available in the database server. This was a main topic of the whole conference, and several solutions have been illustrated during the day. A common theme has […]
PostgreSQL, FreeBSD, and Free Dog Food
/in Greg's PlanetPostgreSQL, PostgreSQL /by 2ndQuadrant PressThis week I did something I’d prefer to never repeat: I left the country, did something useful, and made it back again in the same day. The occasion was the FreeBSD Developer Summit, held just before BSDCan–the convention that happens in Ottawa the week before PGCon every year. So I get to head right back […]
How to install multiple PostgreSQL servers on RedHat Linux
/0 Comments/in Gabriele's PlanetPostgreSQL, PostgreSQL /by Gabriele BartoliniIf you have a Linux server of the RedHat family (inclusing CentOS and Fedora), you might envy the way Debian/Ubuntu distributions handle PostgreSQL clusters management. Although it is not easy to install different PostgreSQL versions on the same RedHat Linux server using RPMs, it is much simpler to install several instances of PostgreSQL (servers) and, […]
The Return of XFS on Linux
/2 Comments/in Greg's PlanetPostgreSQL, PostgreSQL /by 2ndQuadrant PressIf you’re running Linux, and particularly if you’re running a database on Linux, it’s been hard to recommend any filesystem other than plain old ext3 in recent years. Some of the alternatives that looked interesting at one point–jfs, ReiserFS–are completely abandoned at this point. The one that has been almost viable for some time now […]
AMD, Intel, and PostgreSQL
/0 Comments/in Greg's PlanetPostgreSQL, PostgreSQL /by 2ndQuadrant PressA few weeks ago I presented an updated 2010 version of my talk on database hardware benchmarking at PG East. CPU and memory performance are particularly important for a PostgreSQL database, because every individual query runs as a single process. Therefore, the speed of your fastest core determines how fast any one query can execute […]
Installing Greenplum Single Node Edition on Amazon’s EC2
/2 Comments/in Gabriele's PlanetPostgreSQL, Greenplum /by Gabriele BartoliniI have been thinking for a while now about adding Greenplum support to an open-source application for web analytics that I wrote a few years ago, which is called htMiner and uses PostgreSQL. In order to do this, I need a multi-CPU environment. While still waiting to get our new servers installed here in our […]
PGEast, Hardware Benchmarking, and the PG Performance Farm
/0 Comments/in Greg's PlanetPostgreSQL, PostgreSQL, United States News /by 2ndQuadrant PressToday is the deadline for the special room rate at the hotel hosting this month’s PostgreSQL Conference East 2010. If you’ve been procrastinating booking a spot at the conference, as of tomorrow that will start costing you. My talk is on Database Hardware Benchmarking and is scheduled for late afternoon on the first day, Thursday […]