[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 pre-com

[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 http://developer.postgresql.org/cvsweb.cgi/CVSROOT/avail?rev=1.34;content-type=text%

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

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 decom

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 m

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

[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. But

[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* va

[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 broadcast)---

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 th

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