Re: [HACKERS] Improve lseek scalability v3

2011-09-18 Thread Benjamin LaHaise
On Fri, Sep 16, 2011 at 07:27:33PM +0200, Andres Freund wrote: > many tuples does the table have. Those statistics are only updated every now > and then though. > So it uses those old stats to check how many tuples are normally stored on a > page and then uses that to extrapolate the number of tu

Re: [HACKERS] pg_upgrade automatic testing

2011-09-18 Thread Peter Eisentraut
On mån, 2011-09-05 at 23:42 +0300, Peter Eisentraut wrote: > On lör, 2011-09-03 at 19:58 -0400, Tom Lane wrote: > > Anyway, after giving up on that I went back to plan A, namely install > > regress.so and friends into $libdir. That turns out to be really quite > > straightforward, though I had to

Re: [HACKERS] unite recovery.conf and postgresql.conf

2011-09-18 Thread Robert Haas
On Fri, Sep 16, 2011 at 3:22 PM, Joshua Berkus wrote: > No.  pg_settings already has a couple dozen "developer" parameters which > nobody not on this mailing list understands.  Adding the recovery parameters > to it wouldn't confuse anyone further, and would have the advantage of making > the r

Re: [HACKERS] [REVIEW] Generate column names for subquery expressions

2011-09-18 Thread Marti Raudsepp
On Wed, Sep 14, 2011 at 05:26, Kyotaro HORIGUCHI wrote: > This is a review for the patch `Generate column names for > subquery expressions' > (https://commitfest.postgresql.org/action/patch_view?id=632) Thanks for the review. :) PS: When you send a review, you should add the author's email to th

Re: [HACKERS] [WIP] Caching constant stable expressions per execution

2011-09-18 Thread Marti Raudsepp
On Mon, Sep 12, 2011 at 00:22, Tom Lane wrote: > The other thing that is going to be an issue is that I'm fairly sure > this breaks plpgsql's handling of simple expressions. > The quick and dirty solution to this would be for plpgsql to pass some > kind of planner flag that disables insertion of

[HACKERS] Grouping Sets

2011-09-18 Thread David Rinaldi
Hi, I tried to apply the Grouping Sets Patch to 8.4, but received several Hunks failed messages, does anyone know if the failing hunks can be applied manually? Or what version they were applied to specifically? -- Regards David

Re: [HACKERS] Is there really no interest in SQL Standard?

2011-09-18 Thread Tom Lane
Peter Eisentraut writes: > On sön, 2011-09-18 at 09:45 -0500, Dave Page wrote: >> That is much more reasonable, though unfortunately not what was said. >> Regardless, I stand by my main point that such a representative should >> be communicating with the project regularly. Having a rep who works

Re: [HACKERS] /proc/self/oom_adj is deprecated in newer Linux kernels

2011-09-18 Thread Tom Lane
Peter Eisentraut writes: > On fre, 2011-09-16 at 10:57 -0400, Tom Lane wrote: >> So it looks like it behooves us to cater for oom_score_adj in the >> future. The simplest, least risky change that I can think of is to >> copy-and-paste the relevant #ifdef code block in fork_process.c. >> If we do

Re: [HACKERS] Range Types - typo + NULL string constructor

2011-09-18 Thread Erik Rijkers
On Tue, September 13, 2011 10:41, Jeff Davis wrote: > Another updated patch is attached. > Hi, Below are 2 changes. The first change is an elog saying 'lower' instead of 'upper'. The second change is less straightforward, but I think it should be changed too: Rangetypes as it stands uses NULL

[HACKERS] 2011-09 CF underway

2011-09-18 Thread Kevin Grittner
The 2nd CommitFest for 9.2 is in progress. It is scheduled to run from September 15th (three days ago) until October 15th (just under four weeks from now). No new patches should be added to it (although, obviously, new versions of patches already in the CF are expected). Although this is just t

Re: [HACKERS] Is there really no interest in SQL Standard?

2011-09-18 Thread Peter Eisentraut
On sön, 2011-09-18 at 09:45 -0500, Dave Page wrote: > That is much more reasonable, though unfortunately not what was said. > Regardless, I stand by my main point that such a representative should > be communicating with the project regularly. Having a rep who works > outside the project is of no u

Re: [HACKERS] Is there really no interest in SQL Standard?

2011-09-18 Thread Kevin Grittner
Susanne Ebrecht wrote: > Since 4 years I am PostgreSQL representative in SQL Standard > committee. I wasn't aware of that. Thanks for taking the time to look out for community interests. > The next ISO meeting will be soon - and of course there are lots of > drafts that needs decisions. A

Re: [HACKERS] Is there really no interest in SQL Standard?

2011-09-18 Thread Dave Page
On Sunday, September 18, 2011, Peter Eisentraut wrote: > On fre, 2011-09-16 at 08:59 -0500, Dave Page wrote: >> You're missing my point completely. You say you represent PostgreSQL >> on the SQL Committee (or German working group, but that's not the >> point), yet the PostgreSQL hackers didn't kno

Re: [HACKERS] /proc/self/oom_adj is deprecated in newer Linux kernels

2011-09-18 Thread Peter Eisentraut
On fre, 2011-09-16 at 10:57 -0400, Tom Lane wrote: > So it looks like it behooves us to cater for oom_score_adj in the > future. The simplest, least risky change that I can think of is to > copy-and-paste the relevant #ifdef code block in fork_process.c. > If we do that, then it would be up to the

Re: [HACKERS] Is there really no interest in SQL Standard?

2011-09-18 Thread Peter Eisentraut
On fre, 2011-09-16 at 08:59 -0500, Dave Page wrote: > You're missing my point completely. You say you represent PostgreSQL > on the SQL Committee (or German working group, but that's not the > point), yet the PostgreSQL hackers didn't know that, and were making > other plans less than 2 years ago.

Re: [HACKERS] Is there really no interest in SQL Standard?

2011-09-18 Thread Peter Eisentraut
On fre, 2011-09-16 at 07:38 -0500, Merlin Moncure wrote: > So, generally speaking, what kinds of things are going to be brought > up at the ISO meeting? Is this an opportunity to get postgres special > syntax drafted into the sql standard? Don't expect to take a PostgreSQL-specific feature, say,

Re: [HACKERS] Double sorting split patch

2011-09-18 Thread Peter Geoghegan
On 18 September 2011 01:51, Greg Stark wrote: > I think we provided the qsort implementation for the benefit of > platforms that didn't have a decent one and then ended up switching to > use it always for some reason I don't recall.  It wasn't because we > thought we were better at writing qsort i

[HACKERS] Adding CORRESPONDING to Set Operations

2011-09-18 Thread Kerem Kat
Hello, I am new to postgresql code, I would like to start implementing easyish TODO items. I have read most of the development guidelines, faqs, articles by Greg Smith (Hacking Postgres with UDFs, Adding WHEN to triggers). The item I would like to implement is adding CORRESPONDING [BY (col1[,col2