Depesz - depesz.com - select * from depesz;
General Information:
Latest News:
OmniPITR v1.2.0 released 23 Aug 2013 | 09:51 pm
Title: OmniPITR v1.2.0 released It's been a while since last release, but the new one finally arrived, and has some pretty cool goodies For starters, you can now skip creation of xlog backups – which ...
Waiting for 9.4 – WITH CHECK OPTION support for auto-updatable VIEWs 30 Jul 2013 | 04:33 pm
On 18th of July, Stephen Frost committed patch: WITH CHECK OPTION support for auto-updatable VIEWs For simple views which are automatically updatable, this patch allows the user to specify what leve...
Waiting for 9.4 – Add SQL Standard WITH ORDINALITY support for UNNEST (and any other SRF) 30 Jul 2013 | 04:12 am
On 29th of July, Greg Stark committed patch: Add SQL Standard WITH ORDINALITY support for UNNEST (and any other SRF) Author: Andrew Gierth, David Fetter Reviewers: Dean Rasheed, Jeevan Chalke, Steph...
Waiting for 9.4 – Implement the FILTER clause for aggregate function calls. 23 Jul 2013 | 04:20 pm
On 17th of July, Noah Misch committed patch: Implement the FILTER clause for aggregate function calls. This is SQL-standard with a few extensions, namely support for subqueries and outer references ...
Waiting for 9.4 – Add support for REFRESH MATERIALIZED VIEW CONCURRENTLY. 22 Jul 2013 | 06:41 pm
On 16th of July, Kevin Grittner committed patch: Add support for REFRESH MATERIALIZED VIEW CONCURRENTLY. This allows reads to continue without any blocking while a REFRESH runs. The new data appears...
Waiting for 9.4 – ALTER TABLE … ALTER CONSTRAINT for FKs 30 Jun 2013 | 06:50 pm
On 28th of June, Simon Riggs committed patch: ALTER TABLE ... ALTER CONSTRAINT for FKs Allow constraint attributes to be altered, so the default setting of NOT DEFERRABLE can be altered to DEFERRABL...
Bloat removal by tuples moving 21 Jun 2013 | 06:33 pm
Looong time ago, I wrote a piece about removing bloat by moving rows away from the end of table, and vacuuming it. This is/was very slow, and was optimized (to some extent) by Nathan Thom, but his blo...
Sprzedam Toyote GT86, prawie nówka, 4 miesiące, bezwypadkowa 18 Jun 2013 | 06:57 pm
Mam do sprzedania (lub do oddania, zależnie jak na to spojrzeć) toyotę GT86. Produkcja 2012, rejestracja 2013 (chyba luty). Przejechane ~ 3000 kilometrów, bezwypadkowa. Wersja: manualna zmiana biegów,...
Explaining the unexplainable – part 5 30 May 2013 | 04:51 pm
In previous posts in this series, I talked about how to read EXPLAIN output, and what each line (operation/node) means. Now, in the final post, I will try to explain how it happens that Pg chooses “Op...
Explaining the unexplainable – part 4 19 May 2013 | 07:56 pm
In this, hopefully 2nd to last, post in the series, I will cover the rest of usually happening operations that you can see in your explain outputs. Unique Name seems to be clear about what's going on ...
