Archiwizowane December, 2008

Yesterday Tom Lane committed enormous patch, which had commit log: Support window functions a la SQL:2008. Hitoshi Harada, with some kibitzing from Heikki and Tom. ... and that would be all. I will write more about it, its use cases, and some ...

After nearly 3 weeks of functioning, I just uploaded update to explain.depesz.com. New things are not really spectacular - I added help with proper explanation on what each color means and contact form in case somebody had ideas on what to ...

On 4th of December Peter Eisentraut committed patch by Pavel Stehule (with Peters tweaks) which adds default values for function arguments: Default values for function arguments Pavel Stehule, with some tweaks by Peter Eisentraut

Yeah. This one patch alone is worth upgrading to 8.4. On 3rd of December Heikki Linnakangas committed his patch. Commit message: Introduce visibility map. The visibility map is a bitmap with one bit per heap page, where a set bit indicates that all ...

Long time ago I wrote small program to filter EXPLAIN ANALYZE output, and add summary of time. A bit later (I guess, I don't recall exact time line, it could have been earlier) Michael Glaesemann started explain-analyze.info - cool tool for ...

Today, on #postgresql on IRC, guy (can't contact him now to get his permission to name him), said: I have a table called problematic_hostnames. It contains a list of banned hostnames in column "hostname" (varchar). I would like to display the ...