Re: [HACKERS] [RFC] Common object property boards

2011-07-30 Thread Kohei KaiGai
2011/7/29 Tom Lane : > Kohei Kaigai writes: >> In addition to this suggestion, I think the big static array also contains >> the following items: >> - Text form of the object type (e.g, "table", "function", ...) > > What will you do with that that wouldn't be better done by calling > getObjectDesc

Re: [HACKERS] pgbench internal contention

2011-07-30 Thread Robert Haas
On Sat, Jul 30, 2011 at 9:08 AM, Robert Haas wrote: > If I'm reading the code right, it only modifies __libc_drand48_data on > first call, so as long as we called erand48() at least once before > spawning the child threads, it would probably work.  That seems pretty > fragile in the face of the fa

Re: [HACKERS] Review of VS 2010 support patches

2011-07-30 Thread Andrew Dunstan
On 07/06/2011 08:26 PM, Brar Piening wrote: Original Message Subject: Re: [HACKERS] Review of VS 2010 support patches From: Andrew Dunstan To: Brar Piening Date: 06.07.2011 22:58 I'll remove my versions from the patch (v9 probably) if those files get commited. I'm ju

Re: [HACKERS] cataloguing NOT NULL constraints

2011-07-30 Thread Dean Rasheed
On 30 July 2011 01:23, Alvaro Herrera wrote: > Excerpts from Robert Haas's message of sáb jul 23 07:40:12 -0400 2011: >> On Sat, Jul 23, 2011 at 4:37 AM, Dean Rasheed >> wrote: >> > That looks wrong to me, because a NOT NULL constraint is a column >> > constraint not a table constraint. The CREA

Re: [HACKERS] [GENERAL] Dropping extensions

2011-07-30 Thread Dimitri Fontaine
Tom Lane writes: > Hmm. I don't think we have any code in there to prohibit the same > object from being made a member of two different extensions ... but this > example suggests that maybe we had better check that. I see you did take care of that, thank you! http://git.postgresql.org/gitweb

Re: [HACKERS] libedit memory stomp is apparently fixed in OS X Lion

2011-07-30 Thread Dave Page
On Sat, Jul 30, 2011 at 8:25 PM, Tom Lane wrote: > I think you had better plan on incorporating GNU readline into installer > builds for Lion. Unfortunately the licence makes that a non-starter. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enter

Re: [HACKERS] libedit memory stomp is apparently fixed in OS X Lion

2011-07-30 Thread Tom Lane
[ ... having now installed OS X Lion ... ] Dave Page writes: > On Fri, Jul 22, 2011 at 5:16 PM, Tom Lane wrote: >> and if so does it crash when you try >> to tab-complete a case with exactly 9 completions? > Tab complete doesn't seem to work at all (nor does it in my builds > with libedit). No

Re: [HACKERS] pgbench internal contention

2011-07-30 Thread Robert Haas
On Jul 30, 2011, at 9:40 AM, Andy Colson wrote: > On 07/29/2011 04:00 PM, Robert Haas wrote: >> On machines with lots of CPU cores, pgbench can start eating up a lot >> of system time. Investigation reveals that the problem is with >> random(), which glibc implements like this: >> >> long int >>

Re: [HACKERS] pgbench internal contention

2011-07-30 Thread Andy Colson
On 07/29/2011 04:00 PM, Robert Haas wrote: On machines with lots of CPU cores, pgbench can start eating up a lot of system time. Investigation reveals that the problem is with random(), which glibc implements like this: long int __random () { int32_t retval; __libc_lock_lock (lock); (v

Re: [HACKERS] pgbench internal contention

2011-07-30 Thread Robert Haas
On Sat, Jul 30, 2011 at 2:32 AM, Tom Lane wrote: > Robert Haas writes: >> On Fri, Jul 29, 2011 at 5:25 PM, Tom Lane wrote: >>> Portability, or rather lack of it.  What about using erand48, which we >>> already have a dependency on (and substitute code for)? > >> Neither our implementation nor gl

Re: [HACKERS] RC1 / Beta4?

2011-07-30 Thread Martin Atukunda
Now I understand. At the day job we were being pushed hard to have some tests completed before or on 30th June. The major push behind this was a French man! :) And yes, he's off for the next 2-3 weeks, and we did complete the tests! - Martin - On Sat, Jul 30, 2011 at 12:44 PM, Dave Page wrote:

Re: [HACKERS] RC1 / Beta4?

2011-07-30 Thread Dave Page
On Saturday, July 30, 2011, Lou Picciano wrote: > I think it's just that the Europeans - wisely - have a habit of taking these long summer vacations (!) > They also tend to be taller and better-looking than the rest of us, and have better food and wine. > :) Lou This would be one of those few mo

Re: [HACKERS] RC1 / Beta4?

2011-07-30 Thread Lou Picciano
I think it's just that the Europeans - wisely - have a habit of taking these long summer vacations (!) They also tend to be taller and better-looking than the rest of us, and have better food and wine. :) Lou - Original Message - From: "Martin Atukunda" To: "Joshua Berkus" Cc:

Re: [HACKERS] RC1 / Beta4?

2011-07-30 Thread Martin Atukunda
Hi All, Just a quick question because I don't get the reference to the europeans. What do they have to do with the final release in August? :) Thanks, - Martin - On Sat, Jul 30, 2011 at 2:58 AM, Joshua Berkus wrote: > All, > > Where are we on RC1 or Beta4 for PostgreSQL 9.1? > > While I know

Re: [HACKERS] cheaper snapshots

2011-07-30 Thread Simon Riggs
On Thu, Jul 28, 2011 at 8:32 PM, Hannu Krosing wrote: > Maybe this is why other databases don't offer per backend async commit ? Oracle has async commit but very few people know about it. --  Simon Riggs   http://www.2ndQuadrant.com/  PostgreSQL Development, 24x7 Support, Train