Archiwizowane August, 2009

After very long discussions, on 10th of August, Tom Lane committed patch by Robert Haas: Log Message: ----------- Extend EXPLAIN to support output in XML or JSON format.   There are probably still some adjustments to be made in the details of the output, but this ...

On 3rd of August, Tatsuo Ishii committed patch by ITAGAKI Takahiro: Log Message: ----------- Multi-threaded version of pgbench contributed by ITAGAKI Takahiro, reviewed by Greg Smith and Josh Williams.   Following is the proposal from ITAGAKI Takahiro:   Pgbench is a famous tool to measure postgres performance, but ...

This post has been updated with new code that uses temporary table - the code is at the end of post! There was this question on Stack Overflow. For future reference: guy asked how to do session variables - i.e. something he ...

Robert Haas wrote, and Tom Lane committed (on 2nd of August) patch which adds interesting capability: Log Message: ----------- Add ALTER TABLE ... ALTER COLUMN ... SET STATISTICS DISTINCT   Robert Haas Log message is rather terse, so what does it exactly do?

On 1st of August Tom Lane committed patch from Itagaki Takahiro: Improve unique-constraint-violation error messages to include the exact values being complained of.   In passing, also remove the arbitrary length limitation in the similar error detail message for foreign key violations.   Itagaki Takahiro and later added ...

On 29th of July ( I know, there is a long backlog in waiting for 8.5 series. I'm working on it :), Tom Lane committed patch by Dean Rasheed: Support deferrable uniqueness constraints.   The current implementation fires an AFTER ROW trigger for ...