Following up on last month’s Tuning Linux for low PostgreSQL Latency, there’s now been a giant pile of testing done on two filesystems, three patches, and two sets of kernel tuning parameters run. The result so far is some interesting new data, and one more committed improvements in this area that are in PostgreSQL 9.1 […]
Lots of PostegreSQLer also use MySQL.Lots of MySQLer want to use PostgreSQL too. You are MySQLer and want to get more knowledge about PostgreSQL? 2ndQuadrant and me are planning to offer special PostgreSQL trainings forMySQLers / MySQL Administrators. Depending on attendees the training will be in English or German. It is planned to do the […]
One of the challenges when dealing with a new database design is that you don’t know things like how big the tables will end up being until they’re actually populated with a fair amount of data. But if the design has to factor in the eventual scalability concerns, you can’t deploy it to obtain that […]
This week’s flame war on the pgsql-performance list once again revolves around the fact that PostgreSQL doesn’t have the traditional hint syntax available in other databases. There are a mix of technical and pragmatic reasons behind why that is: Introducing hints is a common source of later problems, because fixing a query place once in […]
One of the ugly parts of Linux with PostgreSQL is that the OS will happily cache up to around 5% of memory before getting aggressive about writing it out. I’ve just updated a long list of pgbench runs showing how badly that can turn out, even on a server with a modest 16GB of RAM. […]
One of the more useful bits of PostgreSQL documentation I ever worked on is Tuning Your PostgreSQL Server. When that was written in the summer of 2008, a few months after the release of PostgreSQL 8.3, it was hard to find any similar guide that was both (relatively) concise and current. Since then, myself and […]
For a long time, adding packages to RedHat derived Linux systems has been called “RPM Hell”, for good reason. Particularly before the yum utility came about to help, getting RPM to do the right thing has often been a troublesome task. I was reminded of this again today, while trying to compile a PostgreSQL extension […]
I maintain a number of project whose purpose in life is to make testing portions of PostgreSQL easier. All of these got a decent upgrade over this last week. stream-scaling tests how memory speed increases on servers as more cores are brought into play. It’s fascinating data, enough of it there to start seeing some […]
As the PostgreSQL Elephant continues its march toward yet another release, I’ve been thinking quite a bit about the role users of software should have in its user interface design. Today I proposed something that makes a database parameter people used to have to worry about, and that wasn’t obvious at all how to set, […]
When PostgreSQL 9.0 shipped a few months ago, it included several new replication features. It’s obvious that you can use these features to build clusters of servers for both high availability and read query scaling purposes. What hasn’t been so obvious is how to manage that cluster easily. Getting a number of nodes installed and […]
+39 0574 159 3000
Linux filesystems and PostgreSQL checkpoint benchmarks
/0 Comments/in Greg's PlanetPostgreSQL, PostgreSQL, United States News /by 2ndQuadrant PressFollowing up on last month’s Tuning Linux for low PostgreSQL Latency, there’s now been a giant pile of testing done on two filesystems, three patches, and two sets of kernel tuning parameters run. The result so far is some interesting new data, and one more committed improvements in this area that are in PostgreSQL 9.1 […]
PostgreSQL training for MySQLers
/0 Comments/in International News, PostgreSQL /by susanne.ebrechtLots of PostegreSQLer also use MySQL.Lots of MySQLer want to use PostgreSQL too. You are MySQLer and want to get more knowledge about PostgreSQL? 2ndQuadrant and me are planning to offer special PostgreSQL trainings forMySQLers / MySQL Administrators. Depending on attendees the training will be in English or German. It is planned to do the […]
Data generation and hardware quality
/0 Comments/in Greg's PlanetPostgreSQL, PostgreSQL, United States News /by 2ndQuadrant PressOne of the challenges when dealing with a new database design is that you don’t know things like how big the tables will end up being until they’re actually populated with a fair amount of data. But if the design has to factor in the eventual scalability concerns, you can’t deploy it to obtain that […]
Hinting at PostgreSQL
/8 Comments/in Greg's PlanetPostgreSQL, PostgreSQL, United States News /by 2ndQuadrant PressThis week’s flame war on the pgsql-performance list once again revolves around the fact that PostgreSQL doesn’t have the traditional hint syntax available in other databases. There are a mix of technical and pragmatic reasons behind why that is: Introducing hints is a common source of later problems, because fixing a query place once in […]
Tuning Linux for low PostgreSQL latency
/2 Comments/in Greg's PlanetPostgreSQL, United States News /by 2ndQuadrant PressOne of the ugly parts of Linux with PostgreSQL is that the OS will happily cache up to around 5% of memory before getting aggressive about writing it out. I’ve just updated a long list of pgbench runs showing how badly that can turn out, even on a server with a modest 16GB of RAM. […]
Reducing the postgresql.conf, parameter at a time
/0 Comments/in Greg's PlanetPostgreSQL, PostgreSQL, United States News /by 2ndQuadrant PressOne of the more useful bits of PostgreSQL documentation I ever worked on is Tuning Your PostgreSQL Server. When that was written in the summer of 2008, a few months after the release of PostgreSQL 8.3, it was hard to find any similar guide that was both (relatively) concise and current. Since then, myself and […]
How not to build PostgreSQL 9.0 extensions on RPM platforms
/1 Comment/in Greg's PlanetPostgreSQL, PostgreSQL, United Kingdom News, United States News /by 2ndQuadrant PressFor a long time, adding packages to RedHat derived Linux systems has been called “RPM Hell”, for good reason. Particularly before the yum utility came about to help, getting RPM to do the right thing has often been a troublesome task. I was reminded of this again today, while trying to compile a PostgreSQL extension […]
Updates to PostgreSQL testing tools with benchmark archive
/1 Comment/in Greg's PlanetPostgreSQL, PostgreSQL /by 2ndQuadrant PressI maintain a number of project whose purpose in life is to make testing portions of PostgreSQL easier. All of these got a decent upgrade over this last week. stream-scaling tests how memory speed increases on servers as more cores are brought into play. It’s fascinating data, enough of it there to start seeing some […]
Telling Your Users to Go Fork Themselves
/1 Comment/in Greg's PlanetPostgreSQL, PostgreSQL /by 2ndQuadrant PressAs the PostgreSQL Elephant continues its march toward yet another release, I’ve been thinking quite a bit about the role users of software should have in its user interface design. Today I proposed something that makes a database parameter people used to have to worry about, and that wasn’t obvious at all how to set, […]
Easier PostgreSQL 9.0 clusters with repmgr
/0 Comments/in Greg's PlanetPostgreSQL, International News, United Kingdom News, United States News /by 2ndQuadrant PressWhen PostgreSQL 9.0 shipped a few months ago, it included several new replication features. It’s obvious that you can use these features to build clusters of servers for both high availability and read query scaling purposes. What hasn’t been so obvious is how to manage that cluster easily. Getting a number of nodes installed and […]