The idea of ‘horizontal scalability’ was discussed in great detail at PGCon 2014 in Ottawa this year. It is great to see the community discussing ideas on how PostgreSQL can incorporate horizontally scalable features into the core of the database. Although premature, there is talk of using and extending the Foreign Data Wrapper infrastructure and enhancing the partitioning feature in Postgres to provide sharding.

Organizations today are increasingly using public cloud resources, and specifically cloud databases, for a range of mission-critical workloads.

Training is a core part of what EnterpriseDB provides to the user community. And as that community grows and evolves, we always try to revise and revamp our courses to fit users’ needs.

PostgreSQL has advanced significantly in features and capabilities in recent releases, prompting companies worldwide to accelerate their adoption of PostgreSQL. With this rising interest come more and more queries from users of Oracle, DB2 and SQL Server exploring PostgreSQL (commonly called Postgres) for their individual needs.

TL;DR: Reduce planned database down times by about 97%, by using Postgres Hibernator. DBAs are often faced with the task of performing some maintenance on their database server(s) which requires shutting down the database. The maintenance may involve anything from a database minor-version upgrade, to a hardware upgrade. One ugly side-effect of restarting the database server/service is that all the...

February marks an important development in EnterpriseDB’s expansion in India, where the use of open source software has been rising as technology buyers seek solutions with low upfront deployment costs. At a cost that is 80% or more less than traditional alternatives, Postgres represents significant savings.

With our most recent release of Postgres Plus Advanced Server 9.3, EnterpriseDB also made some nifty new updates to our enterprise-class database management console, Postgres Enterprise Manager.

A special presentation of EnterpriseDB’s Introduction to PostgreSQL Administration next month will be led by PostgreSQL community leader and Global Development Group co-founder Bruce Momjian. The three-day live virtual event will be Feb. 5-7 and will provide a solid foundation for working with PostgreSQL for enterprise software specialists and experienced database administrators.

Postgres' parameters have an associated context, which determines when that parameter can be changed. You can see the context of every parameter using the following query. A sample output is also shown.

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.