PgSql

multibyte charater set in levenshtein function
Excerpts from Alexander Korotkov's message of lun may 10 11:35:02 -0400 2010: Hackers, The current version of levenshtein function in fuzzystrmatch contrib modulte doesn't work properly with multibyte charater sets. My patch make this function works properly with multibyte charater sets. Great. Pl... 7 Jun 2010 18:50

Tags missing from GIT mirror?
On Wed, May 12, 2010 at 8:27 PM, Florian Pflug <fgp(a)phlo.org> wrote: Hi I just tried to checkout REL9_0_BETA1 from my local clone of the GIT repository at git.postgresql.org and discovered that none of the tags from CVS seem to exist in there. For alpha1 to alpha1 each tag is accompanied by a corresponding bra... 13 May 2010 09:22

[HACKERS] Tags missing from GIT mirror?
Hi I just tried to checkout REL9_0_BETA1 from my local clone of the GIT repository at git.postgresql.org and discovered that none of the tags from CVS seem to exist in there. For alpha1 to alpha1 each tag is accompanied by a corresponding brach, and those *do* exist on the GIT mirror. For beta1, however, no branch s... 12 May 2010 14:44

[HACKERS] pg_upgrade versus MSVC build scripts
A look at the MSVC buildfarm members shows that they are not building most of the files added to contrib/pg_upgrade. The reason seems to be that that module tries to build both an executable program *and* a shared library, which it does by dint of setting both PROGRAM and MODULES in its Makefile. Now that is a di... 12 May 2010 14:44

primary/secondary/master/slave/standby
On Wed, May 12, 2010 at 07:33:53PM +0300, Peter Eisentraut wrote: The server's messages and the documentation uses all of these terms in mixed ways. Maybe we could decide on some preferred terminology and adjust the existing texts. Ideas? How about origin/subscriber? More descriptive than primary/seconda... 26 May 2010 18:04

[HACKERS] primary/secondary/master/slave/standby
The server's messages and the documentation uses all of these terms in mixed ways. Maybe we could decide on some preferred terminology and adjust the existing texts. Ideas? -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/... 12 May 2010 13:37

[COMMITTERS] pgsql: Add PGFILEDESC description to Makefiles for all /contrib
momjian(a)postgresql.org (Bruce Momjian) writes: Add PGAPPICON to all executable makefiles. Is it really a good idea to have done that to the server, in particular? I can't imagine it being a good idea to launch the postmaster from a GUI, which is what I suppose this is good for. regards, tom lane -- S... 12 May 2010 16:59

hot update doesn't work?
Pavel Stehule <pavel.stehule(a)gmail.com> wrote: I would to repeatably update non indexed column of temp table. I expected cheap operation, but it isn't true. You're updating the row 100000 times within a single transaction. I don't *think* HOT will reclaim a version of a row until the transaction which c... 12 May 2010 12:30

[HACKERS] hot update doesn't work?
Hello I would to repeatably update non indexed column of temp table. I expected cheap operation, but it isn't true. p ostgres=# create temp table x(a int primary key, b int); NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "x_pkey" for table "x" CREATE TABLE Time: 363,339 ms postgres=# insert... 12 May 2010 11:22

Query execution plan from 8.3 -> 8.4
Brendan, * Brendan Hill (brendanh(a)jims.net) wrote: Getting significantly lower performance on a specific query after upgrading from 8.3 -> 8.4 (windows). I'm not expecting a quick fix from the mail lists, but I would appreciate any indications as to where else I could look or what tools I could employ to... 13 May 2010 13:49