PgSql

plan cache vs regclass constants
The example here http://archives.postgresql.org/pgsql-novice/2008-06/msg00025.php shows that we are failing to regenerate cached plans when a table referenced by a regclass constant is removed. This is pretty minor in the big scheme of things, but it's still annoying since there is code in there that's explicitly... 19 Jun 2008 01:22

pltcl broken on tcl8.5 ?
Andrew Dunstan wrote: Devrim GÜNDÜZ wrote: Hi, On Sun, 2008-06-15 at 20:54 -0400, Andrew Dunstan wrote: Has anyone been able to get the tests to pass using Tcl 8.5.1? All regression tests passed on Fedora-9 while building new RPM sets. Do you s... 19 Jun 2008 01:22

Reducing overhead for repeat de-TOASTing
Recent discussions with the PostGIS hackers led me to think about ways to reduce overhead when the same TOAST value is repeatedly detoasted. In the example shown here http://archives.postgresql.org/pgsql-hackers/2008-06/msg00384.php 90% of the runtime is being consumed by repeated detoastings of a single datum. T... 19 Jun 2008 01:23

How to Sponsor a Feature
On Sunday 15 June 2008 23:01:16 Joshua D. Drake wrote: Andrew Dunstan wrote: Plus an ability to filter the list on those criteria. I'd also like to see a space for companies to state which PostgreSQL major contributors are working for them. That should be of some assistance to sponsors in picking... 19 Jun 2008 01:22

Core team statement on replication in PostgreSQL
>>> On Mon, Jun 9, 2008 at 9:48 PM, in message <Pine.GSO.4.64.0806092243080.11286(a)westnet.com>, Greg Smith <gsmith(a)gregsmith.com> wrote: On Mon, 9 Jun 2008, Tom Lane wrote: It should also be pointed out that the whole thing becomes uninteresting if we get real-time log shipping implemented. So I se... 15 Jul 2008 19:33

TODO Item: Allow pg_hba.conf to specify host namesalong with IP addresses
On Mon, Jun 16, 2008 at 11:47:21AM +0200, Peter Eisentraut wrote: I'm a bit curious how useful in practice this would actually be. Obviously, you want to use host names to simplify the management of hosts, currently being done with IP addresses. But how widely useful is it really to authenticate a bu... 19 Jun 2008 01:22

pg_stat_statements
On Sunday 15 June 2008 22:31:59 ITAGAKI Takahiro wrote: Robert Treat <xzilla(a)users.sourceforge.net> wrote: On Friday 13 June 2008 12:58:22 Josh Berkus wrote: I can see how this would be useful, but I can also see that it could be a huge performance burden when activated. So it couldn't be part of... 24 Jun 2008 03:05

Question about Encoding a Custom Type
On Jun 16, 2008, at 02:52, Martijn van Oosterhout wrote: The only odd thing I see is the use of PG_ARGS to pass the arguments to citextcmp. But I can't see why it would break either. Can you attach a debugger and see where it goes wrong? Yes, I can do that, although I'm pretty new to C (let alone gdb... 19 Jun 2008 01:22

Crash in pgCrypto?
On 6/16/08, Mario Weilguni <mweilguni(a)sime.com> wrote: Marko Kreen schrieb: On 6/16/08, Mario Weilguni <mweilguni(a)sime.com> wrote: Could someone using the pgcrypto extension please verify this? SELECT encode(digest(null, 'md5'::text), 'hex'); or SELECT digest(null, 'md5'); ... 19 Jun 2008 01:22

Commit fest going well
Looks like this commit fest is going very well. The wiki is full of activity, and there are lots of active committers. -- Bruce Momjian <bruce(a)momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup... 7 May 2008 13:25