PgSql

Recent vendor SSL renegotiation patches break PostgreSQL
On Wed, Feb 3, 2010 at 6:24 AM, Chris Campbell <chris_campbell(a)mac.com> wrote: The flurry of patches that vendors have recently been making to OpenSSL to address the potential man-in-the-middle attack during SSL renegotiation have disabled SSL renegotiation altogether in the OpenSSL libraries. Applications tha... 25 Feb 2010 10:16

[HACKERS] Partial Page Writes documentaiton mention
Our manual mentions that you can turn off partial page writes if your file system guarantees full page writes. We used to mention ReiserFS 4 as an example, but I have changed that example to mention ZFS, because ZFS is now more popular. -- Bruce Momjian <bruce(a)momjian.us> http://momjian.us Enterpr... 3 Feb 2010 14:00

use of dblink_build_sql_insert() induces a server crash
On 02/03/2010 04:49 AM, Rushabh Lathia wrote: Testcase: create table foo (a int ); postgres=# SELECT dblink_build_sql_insert('foo','1 2',2,'{\"0\", \"a\"}','{\"99\", \"xyz\"}'); HINT: Use the escape string syntax for escapes, e.g., E'\r\n'. server closed the connection unexpectedly Thanks for... 3 Feb 2010 15:09

Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb)
On Fri, Jan 29, 2010 at 1:56 PM, Greg Stark <gsstark(a)mit.edu> wrote: On Tue, Jan 19, 2010 at 3:25 PM, Tom Lane <tgl(a)sss.pgh.pa.us> wrote: That function *seriously* needs documentation, in particular the fact that it's a no-op on machines without the right kernel call.  The name you've chosen is very bad ... 14 Feb 2010 19:39

Make TOAST_TUPLES_PER_PAGE configurable per table.
Jesper Krogh <jesper(a)krogh.cc> wrote: Ultimately I would like an infinite amount of configurabillity There was some discussion of this previously. I was thinking of doing something with it, but Laurent indicated off-list he was working on it, so I left it to him. Besides reading these threads, you might... 2 Feb 2010 16:11

[HACKERS] Database-Role settings behaviour and docs mismatch
In the docs it says "It is also possible to tie a session default to a specific database rather than to a role; see ALTER DATABASE. If there is a conflict, database-role-specific settings override role-specific ones, which in turn override database-specific ones." Whereas in process_settings() the sequence is ... 2 Feb 2010 16:10

Allow parentheses around the query expression that follows a WITH clause
"IP" <ireneusz.pastusiak(a)poczta.fm> writes: I've got a question related to new feature in 8.5alpha, i.e. "Allow parentheses around the query expression that follows a WITH clause". What does that mean in fact? I can't see any difference between 8.4.2 and 8.5alpha3 on Solaris x86. That entry should not be in the a... 2 Feb 2010 16:10

pgsql: Write a WAL record wheneverwe perform an operation without
Fujii Masao wrote: The cause of the problem seems to be the new heap created by rebuild_relation() and copy_heap_data(), i.e., new VACUUM FULL. Since it's not a temporary heap, its rd_istemp is off. OTOH it needs to be synced after physical copy from old heap. Why does it need to be synced? ISTM the b... 2 Feb 2010 16:10

pgsql: Write a WAL record whenever we perform an operation without
On Mon, Feb 1, 2010 at 6:33 PM, Heikki Linnakangas <heikki.linnakangas(a)enterprisedb.com> wrote: Hmm. The "unlogged" record is written here: ... void heap_sync(Relation rel) {        char reason[NAMEDATALEN + 30];        /* temp tables never need fsync */        if (rel->rd_istemp)     ... 2 Feb 2010 16:11

[HACKERS] New VACUUM FULL crashes on temp relations
TRAP: FailedAssertion("!(typeNamespace == typ->typnamespace)", File: "pg_type.c", Line: 658) Test case attached, repeated, consistent failure on CVS HEAD. Crash occurs with either CLUSTER or VACUUM FULL. Passed on without further investigation. -- Simon Riggs www.2ndQuadrant.com ... 2 Feb 2010 16:09