Re: [HACKERS] Additional stats for Relations

2006-10-14 Thread NikhilS
Hi Jim, On 10/13/06, Jim C. Nasby [EMAIL PROTECTED] wrote: On Fri, Oct 13, 2006 at 06:17:47PM +0530, NikhilS wrote: Currently a select * from pg_statio_user_tables; displays only heap_blks_read, heap_blks_hit stats amongst others for the main relation. It would be good to have the following stats

Re: [HACKERS] Interface of the R-tree in order to work with postgresql

2006-10-14 Thread Markus Schaber
Hi, Jorge, jorge alberto wrote: I'm Jorge from Peru South America, and this is my first post I want to know how can I add a new spatial access method into the postgresql (I'm doing research on spatial access methods( reading a lot of papers and programming a lot too ) but also I want to

Re: [HACKERS] query optimization with UDFs

2006-10-14 Thread Markus Schaber
Hi, Tom, Tom Lane wrote: Neil Conway [EMAIL PROTECTED] writes: BTW, I think it would make sense to implement a limited subset of the xfunc ideas: add options to CREATE FUNCTION to allow cost information to be specified, and then take advantage of this information instead of using the

Re: [HACKERS] query optimization with UDFs

2006-10-14 Thread Tom Lane
Markus Schaber [EMAIL PROTECTED] writes: Tom Lane wrote: The trick is to figure out what a useful parameterized cost model would look like. IIRC, the main reason the xfunc code rotted on the vine was that its cost parameters didn't seem to be either easy to select or powerful in predicting

Re: [HACKERS] [PATCHES] New shared memory hooks proposal (was Re: pre_load_libraries)

2006-10-14 Thread Tom Lane
Marc Munro [EMAIL PROTECTED] writes: The attached patch provides add-ins with the means to register for shared memory and LWLocks. I finally got around to reviewing this patch, and realized that it's got a pretty fundamental design flaw: it isn't useful under Windows (or any other EXEC_BACKEND

[HACKERS] Problems building 8.2beta1 on macos G5 xserve

2006-10-14 Thread Sean Davis
Trying to build 8.2beta1 on MacOS G5 Xserver, OS version 10.4.7. I got this: gcc -no-cpp-precomp -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wendif-labels -fno-strict-aliasing -dynamiclib -install_name /usr/local/pgsql/lib/libpq.5.dylib -compatibility_version 5

[HACKERS] Not quite there on timezone names in timestamp input

2006-10-14 Thread Tom Lane
This doesn't work: regression=# select '2006-07-13 09:20:00 EST5EDT'::timestamptz; ERROR: invalid input syntax for type timestamp with time zone: 2006-07-13 09:20:00 EST5EDT It never has worked in the past, of course, but I expected it to work in HEAD seeing that the zic database includes

Re: [HACKERS] Problems building 8.2beta1 on macos G5 xserve

2006-10-14 Thread Tom Lane
Sean Davis [EMAIL PROTECTED] writes: Trying to build 8.2beta1 on MacOS G5 Xserver, OS version 10.4.7. I got this: /usr/bin/libtool: for architecture: cputype (16777234) cpusubtype (0) file: -lSystem is not an object file (not allowed in a library) What Xcode version have you got? My

Re: [HACKERS] Problems building 8.2beta1 on macos G5 xserve

2006-10-14 Thread Sean Davis
Tom Lane wrote: Sean Davis [EMAIL PROTECTED] writes: Trying to build 8.2beta1 on MacOS G5 Xserver, OS version 10.4.7. I got this: /usr/bin/libtool: for architecture: cputype (16777234) cpusubtype (0) file: -lSystem is not an object file (not allowed in a library) What Xcode version

Re: [HACKERS] [BUGS] BUG #2683: spi_exec_query in plperl returns column names which are not marked as UTF8

2006-10-14 Thread Tom Lane
Vitali Stupin [EMAIL PROTECTED] writes: If database uses UTF8 encoding, then spi_exec_query in plperl should return query results in UTF8 encoding. But unfortunately only data is marked as UTF8, while column names are not. It looks to me like basically everywhere in plperl.c that does

Re: [PATCHES] [HACKERS] large object regression tests

2006-10-14 Thread Bruce Momjian
Patch applied. Thanks. --- Jeremy Drake wrote: On Sun, 24 Sep 2006, Jeremy Drake wrote: On Thu, 21 Sep 2006, Tom Lane wrote: I think we could do without the Moby Dick extract too ... I am open to

Re: [PATCHES] [HACKERS] large object regression tests

2006-10-14 Thread Bruce Momjian
Sorry, please disregard. Was means for a Japanese FAQ update. --- Bruce Momjian wrote: Patch applied. Thanks. --- Jeremy Drake wrote: On