PgSql

UUID - Data type inefficient
The new data type, UUID, is stored as a string -char(16)-: ------------ struct pg_uuid_t { unsigned char data[UUID_LEN]; }; #define UUID_LEN 16 ------------ but this it's very inefficient as you can read here [1]. The ideal would be use bit(128), but today isn't possible. One possible solution w... 10 Jul 2008 13:25

initdb in current cvs head broken?
I am trying to generate a patch with respect to the current CVS head. So ai rsynced the tree, then did cvs up and installed the db. However, when I did initdb on a data directory it is stuck: It is stuck after printing creating template1 creating template1 database in /home/postgres/data/base/1 ... I did stra... 10 Jul 2008 12:22

Follow-up on replication hooks for PostgreSQL
On 7/10/08, Robert Hodges <robert.hodges(a)continuent.com> wrote: This is a quick update on a promise I made early in June to suggest requirements as well as ways to add replication hooks that would support logical replication, as opposed to the physical replication work currently underway based on NTT's cod... 12 Jul 2008 06:25

WITH RECURSIVE updated to CVS TIP
At 2008-07-09 17:06:19 -0700, david(a)fetter.org wrote: I'm really new to this git thing, but I now have access to create git-shell accounts, etc. on git.postgresql.org. Any ideas you can offer on how better to handle this would really help me. :) The question is: what is your objective in providing this r... 14 Jul 2008 19:54

PATCH: CITEXT 2.0 v3
I guess you're all just blown away by the perfection of this patch? ;-) Best, David On Jul 7, 2008, at 18:03, David E. Wheeler wrote: Attached is a new version of a patch to add a CITEXT contrib module. Changes since v2: * Optimized citext_eq() and citext_ne() (the = and <> operators, resp... 16 Jul 2008 00:40

Extending grant insert on tables to sequences
At 2008-07-08 09:32:44 -0400, alvherre(a)commandprompt.com wrote: The idea of this patch is to avoid the need to make explicit grants on sequences owned by tables. [...] I had a look at this patch and it looks good. The only thing that's not clear to me is whether we have agreed we want this to... 4 Sep 2008 12:59

Protocol 3, Execute, maxrows to return, impact?
I was wondering, if there is any real advantage to actually specify say 64 for the maxrows parameter to the Execute message in the PostgreSQL network protocol? I.e.: - Is it easier on the server, because it somehow uses less total memory when batching the Executes with 64 rows at a time? - Is it better for la... 30 Jul 2008 06:09

CommitFest: how does handoff work for non-committerreviewers?
On Wed, 2008-07-09 at 10:59 -0700, Josh Berkus wrote: This commitfest we have a number of non-committer reviewers doing reviewing. When they're done with their review, how do they "handoff" to a committer for final check and commit? One approach would be to assign a committer to each patch, in addition ... 10 Jul 2008 14:27

CommitFest: how does handoff work for non-committer reviewers?
Folks, This commitfest we have a number of non-committer reviewers doing reviewing. When they're done with their review, how do they "handoff" to a committer for final check and commit? --Josh -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: h... 10 Jul 2008 15:29

No answers on CommitFest procedures?
Folks, Have received exactly zero feedback on the question of whether I should be assigning reviewers to "WIP" patches or not. --Josh -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers ... 9 Jul 2008 16:48