PgSql

Parameters of GiST indexes
On Sun, Jun 6, 2010 at 10:24 AM, Alexander Korotkov <aekorotkov(a)gmail.com> wrote: I think that such parameters don't have optimal value for all the cases; What makes you think that? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-hackers mail... 8 Jun 2010 14:53

[HACKERS] Connection leak in dblink on duplicate names
I found contrib/dblink leaks a connection or a small amout of memory when dblink_connect() ends with a duplicate connection name error. We should disconnect the connection before raise any ERRORs. Patch attached. Regards, --- Takahiro Itagaki NTT Open Source Software Center ... 8 Jun 2010 02:34

[HACKERS] pg_lesslog 1.4.2 beta now available
Folks; It is an announcement that pg_lesslog 1.4.2 beta is now available for PostgreSQL 9.0 beta2. You can download the latest file from http://pgfoundry.org/projects/pglesslog/ This is only for PosrgreSLQ 9.0 beta 2. Please do not use this against older version of PostgreSQL. For 8.3 and 8.4, version 1.4... 8 Jun 2010 02:34

[COMMITTERS] pgsql: Fix dblink to treat connection names longer than NAMEDATALEN-2
itagaki(a)postgresql.org (Takahiro Itagaki) wrote: Fix dblink to treat connection names longer than NAMEDATALEN-2 (62 bytes). Now long names are adjusted with truncate_identifier() and NOTICE messages are raised if names are actually truncated. Modified Files: -------------- pgsql/contrib/db... 8 Jun 2010 02:34

How to get permission to debug postgres?
On Sat, Jun 5, 2010 at 8:16 AM, Randy Solomonson <randy(a)solomonson.com> wrote: I have a system that uses C methods as functions in a Postgres database. When I try to run gdb with my user account I get this: ptrace: Operation not permitted It looks like a permission thing. It seemed to work when I ran gdb... 8 Jun 2010 02:34

pgstatindex still throws ERROR: value "3220078592" is out of range for type integer
Dave Cramer <pg(a)fastcrypt.com> wrote: I noted on line 169 that max_avail is still an int ? Where else would it be having problems ? It should not a problem because the local variable only stores byte size in a page. It will be at most only BLCKSZ (=8192). I wonder why you had "ERROR: value ... is out o... 7 Jun 2010 21:04

[HACKERS] Parameters of GiST indexes
Hi hackers, I found that some parameters of GiST implementation are builin in the code. For example, following can be found in the backend/utils/adt/tsgistidx.c: #define SIGLENINT 31 /* >121 => key will toast, so it will not work * !!! */ #define SIGLEN ( size... 7 Jun 2010 18:50

[HACKERS] How to get permission to debug postgres?
I have a system that uses C methods as functions in a Postgres database. When I try to run gdb with my user account I get this: ptrace: Operation not permitted It looks like a permission thing. It seemed to work when I ran gdb as the "postgres" user. I would like to continue running postgres as the "postgres" us... 7 Jun 2010 18:50

Functional dependencies and GROUP BY
On Mon, Jun 7, 2010 at 7:33 PM, Peter Eisentraut <peter_e(a)gmx.net> wrote: I have developed a patch that partially implements the "functional dependency" feature Nice! :) -- greg -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.po... 26 Jul 2010 19:23

[HACKERS] Functional dependencies and GROUP BY
I have developed a patch that partially implements the "functional dependency" feature that allows some columns to be omitted from the GROUP BY clause if it can be shown that the columns are functionally dependent on the columns in the group by clause and therefore guaranteed to be unique per group. The full funct... 7 Jun 2010 15:28