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

On Sun, Jun 12, 2011 at 6:46 AM, Florian Pflug 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

On Fri, Feb 4, 2011 at 12:31 PM, Greg Smith 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 huge win > when it's

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

On Thu, Jan 13, 2011 at 2:06 AM, Martijn van Oosterhout 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 > subroutine. I pla

Re: [HACKERS] plperl arginfo

On Thu, Oct 28, 2010 at 11:34 AM, Tom Lane wrote: > Andrew Dunstan 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 some >>> sort of inquiry functio

Re: [HACKERS] log files and permissions

On Thu, Jul 1, 2010 at 12:19 PM, Michael Tharp 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 with apache logs. I used

Re: [HACKERS] postgresql regular expr bug?

On Sun, Jun 14, 2009 at 1:15 AM, Pavel Stehule 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' ~ '^[0..9]+