pg_shard is a sharding extension for PostgreSQL. It shards and replicates your PostgreSQL tables for horizontal scale and high availability. The extension also seamlessly distributes your SQL statements, without requiring any changes to your application.
PostGIS is the cornerstone of most open source GIS applications. Combining it with the power of other open source applications, mobile devices, and cloud computing , you can bring quick data collection, data analyzation, and open data to a wide audience.
This presentation will take a look at the performance changes in the development version of PostgreSQL. A selection of features, some proposed and some already committed, are evaluated using synthetic open source workloads. One of the workloads used is the former OSDL's Database Test 3 that consists of business oriented ad-hob queries with concurrent data modification.
Some of these proposed features include:
The optimizer is the "brain" of the database, interpreting SQL queries and determining the fastest method of execution. This talk uses the explain command to show how the optimizer interprets queries and determines optimal execution. The talk will assist developers and administrators in understanding how Postgres optimally executes their queries and what steps they can take to understand and perhaps improve its behavior.
What can you do with this PostGIS thing? This talk covers some basic and notsobasic ways to use PostGIS/PostgreSQL to process spatial data, to build infrastructures, and to do crazy things with data.