PostgreSQL Archives - Page 15 of 15 - 2ndQuadrant

Some ideas about low-level resource pooling in PostgreSQL

July 6, 2010/0 Comments/in Gianni's PlanetPostgreSQL, PostgreSQL /by Gianni Ciolli

Last 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

May 14, 2010/in Greg's PlanetPostgreSQL, PostgreSQL /by 2ndQuadrant Press

This 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

May 10, 2010/0 Comments/in Gabriele's PlanetPostgreSQL, PostgreSQL /by Gabriele Bartolini

If 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

April 22, 2010/2 Comments/in Greg's PlanetPostgreSQL, PostgreSQL /by 2ndQuadrant Press

If 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

April 14, 2010/0 Comments/in Greg's PlanetPostgreSQL, PostgreSQL /by 2ndQuadrant Press

A 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 […]

PGEast, Hardware Benchmarking, and the PG Performance Farm

March 11, 2010/0 Comments/in Greg's PlanetPostgreSQL, PostgreSQL, United States News /by 2ndQuadrant Press

Today 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 […]

Trade-offs in Hot Standby Deployments

February 24, 2010/0 Comments/in Greg's PlanetPostgreSQL, PostgreSQL /by 2ndQuadrant Press

The new Hot Standby feature in the upcoming PostgreSQL 9.0 allows running queries against standby nodes that previously did nothing but execute a recovery process. Two common expectations I’ve heard from users anticipating this feature is that it will allow either distributing short queries across both nodes, or allow running long reports against the standby […]

Measuring PostgreSQL Checkpoint Statistics

January 29, 2010/1 Comment/in Greg's PlanetPostgreSQL, PostgreSQL /by 2ndQuadrant Press

Checkpoints can be a major drag on write-heavy PostgreSQL installations. The first step toward identifying issues in this area is to monitor how often they happen, which just got an easier to use interface added to the database recently.

Read 2ndQuadrant’s response to the COVID – 19 emergency here

Some ideas about low-level resource pooling in PostgreSQL

PostgreSQL, FreeBSD, and Free Dog Food

How to install multiple PostgreSQL servers on RedHat Linux

The Return of XFS on Linux

AMD, Intel, and PostgreSQL

PGEast, Hardware Benchmarking, and the PG Performance Farm

Trade-offs in Hot Standby Deployments

Measuring PostgreSQL Checkpoint Statistics

Support & Services

Products

Postgres Learning Center

About Us