The EDB Blog

When Failure is Not an Option – The New EDB Failover Manager

By Gary Carter
EnterpriseDB has just released a critical component for meeting stringent high 9’s enterprise-level High Availability demands with Postgres. As the newest member in our family of integrated tools for Postgres Plus Advanced Server and community PostgreSQL deployments, EDB Failover Manager addresses...

Performance Boosters in Postgres Plus Advanced Server 9.3

By Gary Carter
At EnterpriseDB, we have built our history and reputation advancing community PostgreSQL to meet the demands of the enterprise. With the recent release of our Postgres Plus Advanced Server 9.3, we have continued that tradition. The performance enhancements to partitioning and materialized views...

Advanced PostgreSQL Administration – Part II of New Training Rollout

By Marc Linster
Part II of our new and improved training program continues with a revamped and refreshed on-demand version of our Advanced PostgreSQL Administration training course. The first part of our new initiative to make training programs more dynamic and interactive was the topic of my November 11 post and...

Parallelism Progress

By Robert Haas
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...

New Relic Plugin for Postgres and Postgres Plus Advanced Server

By enterprisedb enterprisedb
We’re unveiling today, through a partnership with application monitoring tools provider New Relic, a plug-in to ease and enhance the user experience for our shared customers. With a New Relic plug-in for PostgreSQL and our Postgres Plus Advanced Server, our shared customers are able to view metrics...

Vaadin 7 Cookbook

By Bobby Bissett
I finally have a chance to look at Vaadin version 7 now, which is already up to v7.0.6 (nice work team!). There is a wealth of information from Vaadin about the changes and migration path, but I'm skipping all that and jumping right to examples as an experiment. Thus, my first blog ever about a...

Dynamic Columns

By Bruce Momjian
Sql has never been good at handling dynamic columns — it can easily process tables with a fixed number of columns, but dynamic column handling has always been a challenge. (Dynamic columns are often used to implement user-defined fields.) One approach has been to define columns for every possible...

Creating Virtual Columns

By Bruce Momjian
Databases store data in table columns, but sometimes it is useful to create non-storage columns for code clarity. For example, you might need to access a combination of columns frequently and don't want to repeatedly perform the combining operation in your application. In this case, a column can be...

Instagram scales with Postgres

By Gary Carter
This engineering blog by Instagram co-founder Mike Krieger is another great example of the robust feature set available today in PostgreSQL to handle some of the most modern of database scalability problems. Note that he highlights not just core features, but tools from the Postgres ecosystem like...

Pg_Upgrade Bug with Invalid Concurrently-Created Indexes

By Bruce Momjian
Postgres, since version 8.2, has supported the ability to create indexes without blocking writes (insert, update, or delete) on the table being indexed. This is done by adding the keyword concurrently to the create index command. (Reads are never blocked by create index.) Implementing this feature...

Monitoring Postgres from the Command Line

By Bruce Momjian
You might already be aware that Postgres updates the process title of all its running processes. For example, this is a Debian Linux ps display for an idle Postgres server: postgres 2544 2543 0 10:47 ? 00:00:00 /u/pgsql/bin/postmaster -i postgres 2546 2544 0 10:47 ? 00:00:00 postgres: checkpointer...

List user privileges in PostgreSQL/PPAS 9.1

By Vibhor Kumar
PostgreSQL has some useful functions which can be use to know about the privilege of a user on a particular Database object. Those functions is available in following link: Functions has_*_privilege in PostgreSQL/PPAS is good to know...

Monitor CPU and MEMORY percentage used by each process in PostgreSQL/PPAS 9.1

By Vibhor Kumar
PostgreSQL has pg_stat_activity view which can be use to get the session details. This view gives following information: 1. datid: database OID 2. datname: database name 3. procpid: process ID 4. usesysid: user OID 5. usename: user name 6. application_name: application name 7. client_addr: client's...

What Are Oids

By Bruce Momjian
Object Identifiers (oids) were added to Postgres as a way to uniquely identify database objects, e.g. rows, tables, functions, etc. It is part of Postgres's object-relational heritage. Because oids where assigned to every data row by default, and were only four-bytes in size, they were increasingly...

Session Timeouts with Vaadin's Refresher Add-on

By Bobby Bissett
The Refresher add-on for Vaadin refreshes the UI without user input, allowing it to display information that has changed asynchronously on the server. It adds an invisible component to the client web page which polls the server for changes. A matching server-side handler is called when the server is polled.

Cluster, Cluster, Schema, Schema

By Bruce Momjian
There are 500k to 1-million words in the English language, so you would think that Postgres would be able to find a unique word for every aspect of the database, but unfortunately, that is not true. There are two cases where Postgres uses a single word to mean two different things, sometimes...