[HACKERS] Connection and transaction triggers

2007-08-05 Thread James Mansion
I've been looking at the new trigger features planned for Firebird 2.1 and I'm a bit jealous. I'm interested in 'stateful' proc packages that can benefit from accumulating data from updates during a transaction and then performing an action at the end - perhaps doing a bulk insert in a

[HACKERS] Strange file in cvs repo

2007-08-05 Thread Magnus Hagander
Can someone explain what this file is? Did we accidentally import something from a different project? Seems to me this file is a part of FreeBSD and not us? http://developer.postgresql.org/cvsweb.cgi/CVSROOT/avail

Re: [HACKERS] Document and/or remove unreachable code in tuptoaster.c from varvarlena patch

2007-08-05 Thread Gregory Stark
Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: Testers here were having a hard time constructing test cases to reach some lines touched by the varvarlena patch. Upon further investigation I'm convinced they're unreachable. I'm not really happy with any of this

Re: [HACKERS] pg_lzcompress strategy parameters

2007-08-05 Thread Gregory Stark
Tom Lane [EMAIL PROTECTED] writes: This whole structure seems a bit broken, independently of whether the particular parameter values are good. If the compressor is given an input of 100 bytes and manages to compress it to 99 bytes, we'll store it compressed, and pay for

Re: [HACKERS] Strange file in cvs repo

2007-08-05 Thread Andrew Dunstan
I believe it's part of cvs_acls ... do we use that any more? see http://www.koders.com/perl/fidA320EA67D62A67F65481F584FA71F7F1121A903F.aspx cheers andrew Magnus Hagander wrote: Can someone explain what this file is? Did we accidentally import something from a different project? Seems to

Re: [HACKERS] Strange file in cvs repo

2007-08-05 Thread Magnus Hagander
The script certainly isn't present in CVSROOT. There appears to be a bunch of other unused scrpits in CVSROOT though, but I'm not certain enough to go delete anything without someone knowing more about it checking that :) //Magnus Andrew Dunstan wrote: I believe it's part of cvs_acls ... do

Re: [HACKERS] default_text_search_config and expression indexes

2007-08-05 Thread Heikki Linnakangas
Bruce Momjian wrote: Ron Mayer wrote: We need more feedback from users. Well, I am waiting for other hackers to get involved, but if they don't, I have to evaluate it myself on the email lists. Personally, I think documentation changes would be an OK way to to handle it. Something that

[HACKERS] Autovacuum and toast tables

2007-08-05 Thread Gregory Stark
When autovacuum vacuums a table it always vacuums the toast table as well. Is there any particular reason to consider the two together? I think this may just be a holdover from the interactive command which considers them together because the toast table is supposed to be invisible to users.

[HACKERS] pgCluster CVS repository

2007-08-05 Thread Gustavo Tonini
Does pgCluster have a own CVS repository? Gustavo. pgppHPBB12Fhp.pgp Description: PGP signature

Re: [HACKERS] pg_lzcompress strategy parameters

2007-08-05 Thread Tom Lane
Gregory Stark [EMAIL PROTECTED] writes: (Incidentally, this means what I said earlier about uselessly trying to compress objects below 256 is even grosser than I realized. If you have a single large object which even after compressing will be over the toast target it will force *every* varlena

[HACKERS] Problem with locks

2007-08-05 Thread Gregory Stark
We're seeing a problem where occasionally a process appears to be granted a lock but miss its semaphore signal. It eventually gets the 60s deadlock signal and notices that it has been granted the lock and gets back to work. I haven't gotten any further than this in the forensic analysis and it's

Re: [HACKERS] Problem with locks

2007-08-05 Thread Tom Lane
Gregory Stark [EMAIL PROTECTED] writes: We're seeing a problem where occasionally a process appears to be granted a lock but miss its semaphore signal. Kernel bug maybe? What's the platform? regards, tom lane ---(end of

Re: [HACKERS] pgCluster CVS repository

2007-08-05 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Gustavo Tonini wrote: Does pgCluster have a own CVS repository? http://www.pgcluster.org/ Gustavo. - -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the

Re: [HACKERS] pgCluster CVS repository

2007-08-05 Thread Devrim GÜNDÜZ
Hi, On Sun, 2007-08-05 at 19:07 -0700, Joshua D. Drake wrote: Gustavo Tonini wrote: Does pgCluster have a own CVS repository? http://www.pgcluster.org/ It is not up2date . Just a FYI. Regards, -- Devrim GÜNDÜZ PostgreSQL Replication, Consulting, Custom Development, 24x7 support