Archiwizowane October, 2010

Finally, on 25th of October, Tom Lane committed patch which does: Allow new values to be added to an existing enum type.   After much expenditure of effort, we've got this to the point where the performance penalty is pretty minimal in typical cases.   Andrew ...

On 24th of October, Peter Eisentraut committed addition to his previous patch, which adds: Support suffix matching of host names in pg_hba.conf   A name starting with a dot can be used to match a suffix of the actual host name (e.g., .example.com matches ...

Today some guy on IRC asked question, which I didn't fully understand, but which could (probably) be summarized: how to group data into 5 minute intervals, based on some timestamp column. Well, it seems trivial (as long as you know how ...

Some time ago Joshua Tolley described how to reduce bloat from tables without locking (well, some locks are there, but very short, and not really intrusive). Side note: Joshua: big thanks, great idea. Based on his idea and some our research, i ...

Before I'll start let me say that I am fan of what Oleg and Teodor did - their work is great, and I do appreciate their time and ideas. But - I simply don't like the idea of using FTS (Full ...

On 15th of October Peter Eisentraut committed patch (his own) which adds: Support host names in pg_hba.conf   Peter Eisentraut, reviewed by KaiGai Kohei and Tom Lane

On 10th of October, Tom Lane committed patch by Deal Rasheed, which adds triggers on views: Support triggers on views.   This patch adds the SQL-standard concept of an INSTEAD OF trigger, which is fired instead of performing a physical insert/update/delete. The trigger function ...

On 26th of September, Peter Eisentraut committed patch which adds: Add ALTER TYPE ... ADD/DROP/ALTER/RENAME ATTRIBUTE   Like with tables, this also requires allowing the existence of composite types with zero attributes.   reviewed by KaiGai Kohei

Ostatnio dostałem linka do prostej "info-grafiki" pokazującej jakie są przyczyny utraty klientów. Najważniejszą jest: obsługa klienta. W/g wspomnianej grafiki, obsługa klienta odpowiada za 68% przypadków gdy tracisz klienta. WOW. To sporo. Zacząłem się nad tym trochę zastanawiać. W różnych badaniach wychodzi, że ...

Foreign keys are known for couple of things, but speeding up your system is not one of them. But sometimes, having them in place lets you make queries significantly faster. How? Let me show you example I have seen lately (well, ...