Re: [HACKERS] Win32 shared memory speed

2007-11-11 Thread Magnus Hagander
IIRC, there hasn't been any direct benchmark for it (though I've wanted to do that but had no time), but it's been the olnly real explanation put forward for the behaviour we've seen. And it does make sense given the thread-centric view of the windows mm. /Magnus > --- Original Message --

Re: [HACKERS] 8.2.3: Server crashes on Windows using Eclipse/Junit

2007-11-11 Thread Dave Page
> --- Original Message --- > From: "Trevor Talbot" <[EMAIL PROTECTED]> > To: "Magnus Hagander" <[EMAIL PROTECTED]> > Sent: 10/11/07, 23:17:13 > Subject: Re: [HACKERS] 8.2.3: Server crashes on Windows using Eclipse/Junit > > As for desktop heap, only 65KB of the service heap was allocated

Re: [HACKERS] Win32 shared memory speed

2007-11-11 Thread James Mansion
Magnus Hagander wrote: IIRC, there hasn't been any direct benchmark for it (though I've wanted to do that but had no time), but it's been the olnly real explanation put forward for the behaviour we've seen. And it does make sense given the thread-centric view of the windows mm. /Magnus Ho

[HACKERS] Beta2 "horology" test failure on non-US zoneinfo/posixrules

2007-11-11 Thread Radoslaw Zielinski
Hello, I'm building beta2 --with-system-tzdata, my /usr/share/zoneinfo/posixrules is a symbolic link to localtime, which is Europe/London; the horology test fails in three places: --- expected/horology.out 2007-07-25 18:22:36.0 +0100 +++ results/horology.out 2007-11-10 21:15:

[HACKERS] Problem to configure pg8.3b2 w/ ossp-uuid-support on OS X

2007-11-11 Thread Jörg Beyer
Hello. Compiling PostgreSQL 8.3 beta 2 on OS X 10.4 leads to some configuration problems, at least for an ordinary user like me -- so please bare with me if the following is due to user error and not PostgreSQL's fault. Some necessary notes on my environment: -- OS X 10.4.10 /w Xcode 2.5.0 (late

[HACKERS] [hibernate-team] PostgreSQLDialect

2007-11-11 Thread Diego Pires Plentz
Hi Guys, I'm one of the hibernate(http://hibernate.org) team commiters and I'm here to ask you for a little help :-) I'm trying to improve the support of hibernate to Postgre(and other databases), but I'm don't have *that* knowledge in database functions and behavior. I'm already done a couple of

Re: [HACKERS] Win32 shared memory speed

2007-11-11 Thread Magnus Hagander
James Mansion wrote: > Magnus Hagander wrote: >> IIRC, there hasn't been any direct benchmark for it (though I've >> wanted to do that but had no time), but it's been the olnly real >> explanation put forward for the behaviour we've seen. And it does make >> sense given the thread-centric view of t

Re: [HACKERS] [hibernate-team] PostgreSQLDialect

2007-11-11 Thread Martijn van Oosterhout
On Sun, Nov 11, 2007 at 12:04:51PM -0300, Diego Pires Plentz wrote: > I'm trying to improve the support of hibernate to Postgre(and other > databases), but I'm don't have *that* knowledge in database functions and > behavior. I'm already done a couple of improvements, but I'm trying to map > all yo

Re: [HACKERS] Beta2 "horology" test failure on non-US zoneinfo/posixrules

2007-11-11 Thread Tom Lane
Radoslaw Zielinski <[EMAIL PROTECTED]> writes: > I'm building beta2 --with-system-tzdata, my /usr/share/zoneinfo/posixrules > is a symbolic link to localtime, which is Europe/London; the horology test > fails in three places: > ... > If .../posixrules is a symlink to America/New_York (as originally

Re: [HACKERS] Problem to configure pg8.3b2 w/ ossp-uuid-support on OS X

2007-11-11 Thread Tom Lane
J=?ISO-8859-1?B?9g==?=rg Beyer <[EMAIL PROTECTED]> writes: > -- Binaries and libraries installed _by the OS itself_ reside in /usr (e.g. > uuid, libxml2, libxslt) What I see on my OSX machines is /usr/include/uuid/uuid.h and no sign of anything uuid-related in /usr/lib. (Apparently the functions

Re: [HACKERS] [hibernate-team] PostgreSQLDialect

2007-11-11 Thread Tom Dunstan
> Hi, I've never used Hibernate but it seems to be that table of > functions could be generated automatically. That's the obvious solution. It would be nice if the dialect could query the database itself to get a list of functions, since there will be different sets of functions for different serv

Re: [HACKERS] [hibernate-team] PostgreSQLDialect

2007-11-11 Thread Diego Pires Plentz
Wow, quick responses :-) On Nov 11, 2007 3:11 PM, Tom Dunstan <[EMAIL PROTECTED]> wrote: > > Hi, I've never used Hibernate but it seems to be that table of > > functions could be generated automatically. > > That's the obvious solution. It would be nice if the dialect could > query the database i

Re: [HACKERS] [hibernate-team] PostgreSQLDialect

2007-11-11 Thread Simon Riggs
On Sun, 2007-11-11 at 17:11 +, Tom Dunstan wrote: > The way to fix both that and the differing available functions would > probably be to have a subclass of the dialect for each server version. > MySQL seems to have about 5 :) I think a static dialect for each server version is the way to go.

Re: [HACKERS] [hibernate-team] PostgreSQLDialect

2007-11-11 Thread David Fetter
On Sun, Nov 11, 2007 at 04:48:00PM -0200, Diego Pires Plentz wrote: > Right Tom. The main problem is that hibernate propose is to be > database independent, so, it isn't all databases that has a table > with the list of all functions(and parameters/types to each > function). The "least common den

Re: [HACKERS] proposal casting from XML[] to int[], numeric[], text[]

2007-11-11 Thread Nikolay Samokhvalov
On Sep 25, 2007 10:57 AM, Pavel Stehule <[EMAIL PROTECTED]> wrote: > Hello > > Current result from xpath function isn't indexable. It cannot be > problem with possibility cast it to some base types. > > CREATE OR REPLACE FUNCTION xml_list_to_int(xml[]) > RETURNS int[] AS $$ > SELECT ARRAY(SELECT t

Re: [HACKERS] proposal casting from XML[] to int[], numeric[], text[]

2007-11-11 Thread Pavel Stehule
On 11/11/2007, Nikolay Samokhvalov <[EMAIL PROTECTED]> wrote: > > > On Sep 25, 2007 10:57 AM, Pavel Stehule <[EMAIL PROTECTED]> wrote: > > Hello > > > > Current result from xpath function isn't indexable. It cannot be > > problem with possibility cast it to some base types. > > > > CREATE OR REPLAC

Re: [HACKERS] proposal casting from XML[] to int[], numeric[], text[]

2007-11-11 Thread Tom Lane
"Nikolay Samokhvalov" <[EMAIL PROTECTED]> writes: > Alternative (and maybe better) approach would be: > - create comparison functions that work in the same way as string > comparison functions do (currently, it's straight forward since XML is > stored as string); > - do NOT create comparison oper

Re: [HACKERS] [hibernate-team] PostgreSQLDialect

2007-11-11 Thread Josh Berkus
Diego, > Wow, quick responses :-) Hey, anyone wanting to work on drivers is automatically one of our favorite people. FYI, you might want to ping the pgsql-jdbc mailing list as well. -- --Josh Josh Berkus PostgreSQL @ Sun San Francisco ---(end of broadcast)--

Re: [HACKERS] [hibernate-team] PostgreSQLDialect

2007-11-11 Thread Andrew Dunstan
Diego Pires Plentz wrote: I'm thinking the same thing. We could let PostgreSQLDialect to do full support to Postgre 7.x and extend it to support the new features/functions in Postgre 8.x. Btw, to do that, one thing that we must do is identify what functions are new/still avaiable in 8.x. That a

Re: [HACKERS] proposal casting from XML[] to int[], numeric[], text[]

2007-11-11 Thread Nikolay Samokhvalov
On Nov 12, 2007 12:59 AM, Tom Lane <[EMAIL PROTECTED]> wrote: > I'm not clear on what you're proposing. There is no such thing as an > opclass with no operators (or at least, not a useful one), so this seems > mutually contradictory. > > regards, tom lane > You're right, t