Re: [HACKERS] Boolean operators without commutators vs. ALL/ANY

2011-06-13 Thread Stephen J. Butler
On Sun, Jun 12, 2011 at 6:46 AM, Florian Pflug f...@phlo.org wrote: (B) There should be a way to use ANY()/ALL() with the array elements becoming the left arguments of the operator. FWIW, in case people were unaware, this is getting close to Perl 6 junctions/superpositions. See:

Re: [HACKERS] Linux filesystem performance and checkpoint sorting

2011-02-04 Thread Stephen J. Butler
On Fri, Feb 4, 2011 at 12:31 PM, Greg Smith g...@2ndquadrant.com wrote: -Switching from ext3 to xfs gave over a 3X speedup on the smaller test set:  from the 600-700 TPS range to around 2200 TPS.  TPS rate on the larger data set actually slowed down a touch on XFS, around 10%.  Still, such a

Re: [HACKERS] arrays as pl/perl input arguments [PATCH]

2011-01-13 Thread Stephen J. Butler
On Thu, Jan 13, 2011 at 2:06 AM, Martijn van Oosterhout klep...@svana.org wrote: I played with this a little and it is fairly easy to make a variable such that $a is the string representation and $a[0] the first value of the array. The problem is that you can't pass such a variable into a

Re: [HACKERS] plperl arginfo

2010-10-28 Thread Stephen J. Butler
On Thu, Oct 28, 2010 at 11:34 AM, Tom Lane t...@sss.pgh.pa.us wrote: Andrew Dunstan and...@dunslane.net writes: On 10/28/2010 11:54 AM, Pavel Stehule wrote: Alternatively, maybe the feature could be exposed in a way where you don't actually calculate the values unless requested, ie provide

Re: [HACKERS] log files and permissions

2010-07-01 Thread Stephen J. Butler
On Thu, Jul 1, 2010 at 12:19 PM, Michael Tharp g...@partiallystapled.com wrote: That said, as Martin mentions one can easily place the log directory outside of the data directory and set appropriate directory permissions. If I can offer my $0.02, I recently solved such a problem on SuSE Linux

Re: [HACKERS] postgresql regular expr bug?

2009-06-14 Thread Stephen J. Butler
On Sun, Jun 14, 2009 at 1:15 AM, Pavel Stehulepavel.steh...@gmail.com wrote: can somebody explain this behave? postgres=# select '10' ~ e'^\\d+$'; ?column? -- t (1 row) ok postgres=# select '10' ~ '[0..9]+$'; ?column? -- t (1 row) ok postgres=# select '10' ~