Re: [HACKERS] WIP: Fast GiST index build

2011-09-14 Thread Stefan Keller
I'm on the way to open a ticket for hash indexes (adding WAL support) anyway: May I open a ticket for adding GiST support to unlogged tables ? Stefan 2011/9/14 Stefan Keller sfkel...@gmail.com: Robert, 2011/9/6 Alexander Korotkov aekorot...@gmail.com: GiST use serial numbers of operations

Re: [HACKERS] DBI-LINK not support special support?

2011-09-14 Thread Albe Laurenz
paulo matadr wrote: I use dbi-link to connect for oracle db 10g and 11g, and big problem give to me: example: select * from table(oracle) çavân When dbi-link call information from oracle his show ?cv?an In pure perl script no have problems too. Any ideas for help me? This is not a

[HACKERS] [REVIEW] pg_last_xact_insert_timestamp

2011-09-14 Thread Kyotaro HORIGUCHI
Hi, This is a review for pg_last_xact_insert_timestamp patch. (https://commitfest.postgresql.org/action/patch_view?id=634) Summary There's one question and two comments. Q1: The shmem entry for timestamp is not initialized on allocating. Is this OK? (I don't know that for

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

2011-09-14 Thread Peter Eisentraut
On tis, 2011-09-13 at 17:10 +0100, Simon Riggs wrote: So treat postgresql.conf as if it has an automatic include recovery.conf in it. The file format is the same. Sounds good. That would also have the merit that you could use, say, different memory settings during recovery. -- Sent via

Re: [HACKERS] Inserting heap tuples in bulk in COPY

2011-09-14 Thread Heikki Linnakangas
On 13.08.2011 17:33, Tom Lane wrote: Heikki Linnakangasheikki.linnakan...@enterprisedb.com writes: The patch is WIP, mainly because I didn't write the WAL replay routines yet, but please let me know if you see any issues. Why do you need new WAL replay routines? Can't you just use the

Re: [HACKERS] What Would You Like To Do?

2011-09-14 Thread Kaare Rasmussen
Hi [brief]: http://postgresopen.org/2011/schedule/presentations/83/ You list Job scheduling as one item here, snip but not here Here's my preliminary list: Could you expand your idea about this here? -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to

Re: [HACKERS] augmenting MultiXacts to improve foreign keys

2011-09-14 Thread Robert Haas
On Tue, Sep 13, 2011 at 9:27 AM, Alvaro Herrera alvhe...@commandprompt.com wrote: I wonder if it's a mistake to be thinking about solving this problem by extending the MultiXact mechanism.  Pushing xmax out-of-line so that we have room to store tuple information seems expensive, especially

Re: [HACKERS] WIP: Fast GiST index build

2011-09-14 Thread Robert Haas
On Tue, Sep 13, 2011 at 5:00 PM, Stefan Keller sfkel...@gmail.com wrote: 2011/9/6 Alexander Korotkov aekorot...@gmail.com: GiST use serial numbers of operations for concurrency. In current implementation xlog record ids are used in capacity of that numbers. In unlogged table no xlog records

Re: [HACKERS] What Would You Like To Do?

2011-09-14 Thread Hannu Krosing
On Tue, 2011-09-13 at 10:26 -0700, Joshua D. Drake wrote: Complete isolation at the user level, allowing an ISP to support multiple independent customers on a server without having to fiddle with multiple back ends each running on a separate port, a feature that MySQL has had for as far

Re: [HACKERS] What Would You Like To Do?

2011-09-14 Thread Hannu Krosing
On Tue, 2011-09-13 at 17:02 -0300, Rodrigo Gonzalez wrote: On 09/13/2011 04:52 PM, Tom Lane wrote: Rodrigo Gonzalezrjgonz...@estrads.com.ar writes: In a perfect world, it would be nice if one could do combined queries linking a PostgreSQL database with an Oracle one, or a MySQL one,

Re: [HACKERS] Sponsored development

2011-09-14 Thread David Fetter
On Tue, Sep 13, 2011 at 08:24:15AM +0300, Heikki Linnakangas wrote: On 13.09.2011 00:33, Dermot wrote: I have seen this feature on the todo list: http://wiki.postgresql.org/wiki/Todo#Referential_Integrity It's my understanding that this will allow FK constraints on array elements, if I'm

Re: [HACKERS] What Would You Like To Do?

2011-09-14 Thread Joshua D. Drake
On 09/14/2011 05:12 AM, Hannu Krosing wrote: On Tue, 2011-09-13 at 10:26 -0700, Joshua D. Drake wrote: Complete isolation at the user level, allowing an ISP to support multiple independent customers on a server without having to fiddle with multiple back ends each running on a separate port,

Re: [HACKERS] DBI-LINK not support special support?

2011-09-14 Thread paulo matadr
Environment has been applied [postgres@gcomdesenv oracle]$ export declare -x HOME=/usr/local/pgsql/data declare -x INPUTRC=/etc/inputrc declare -x JAVA_HOME=/usr/java/jdk1.6.0_26 declare -x LANG=en_US.UTF-8 declare -x LANGUAGE=en_US.UTF-8 declare -x LC_ALL=en_US declare -x LC_CTYPE=UTF8 declare

Re: [HACKERS] What Would You Like To Do?

2011-09-14 Thread David E. Wheeler
On Sep 14, 2011, at 5:49 AM, Kaare Rasmussen wrote: [brief]: http://postgresopen.org/2011/schedule/presentations/83/ You list Job scheduling as one item here, snip but not here Here's my preliminary list: Could you expand your idea about this here? It was something suggested to me on IRC a

Re: [HACKERS] What Would You Like To Do?

2011-09-14 Thread Hannu Krosing
On Wed, 2011-09-14 at 07:14 -0700, Joshua D. Drake wrote: On 09/14/2011 05:12 AM, Hannu Krosing wrote: On Tue, 2011-09-13 at 10:26 -0700, Joshua D. Drake wrote: Complete isolation at the user level, allowing an ISP to support multiple independent customers on a server without having to

Re: [HACKERS] What Would You Like To Do?

2011-09-14 Thread Jaime Casanova
On Wed, Sep 14, 2011 at 9:14 AM, Joshua D. Drake j...@commandprompt.com wrote: On 09/14/2011 05:12 AM, Hannu Krosing wrote: On Tue, 2011-09-13 at 10:26 -0700, Joshua D. Drake wrote: Complete isolation at the user level, allowing an ISP to support multiple independent customers on a server

Re: [HACKERS] What Would You Like To Do?

2011-09-14 Thread Aidan Van Dyk
On Wed, Sep 14, 2011 at 12:09 PM, Jaime Casanova ja...@2ndquadrant.com wrote: last time i tried it (last year), it seems broken because i couldn't log in with any user anymore... but it could be that i did something wrong so i didn't report until i could confirm but i hadn't the time and i

Re: [HACKERS] What Would You Like To Do?

2011-09-14 Thread Jaime Casanova
On Wed, Sep 14, 2011 at 11:49 AM, Aidan Van Dyk ai...@highrise.ca wrote: But I found it useful when needing to hand out seperate usernames for different apps because they all needed to have their own search_path and other settings set before login (yes, dumb apps, mostly odbc), and be able to

Re: [HACKERS] What Would You Like To Do?

2011-09-14 Thread Josh Berkus
DW, All: - Update newsysviews and bundle it as an extension, and maintain it for each new version - Add median() and quartile() windowing aggregates, or similar equivalents. - work on pgTune -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-hackers mailing list

[HACKERS] memory barriers (was: Yes, WaitLatch is vulnerable to weak-memory-ordering bugs)

2011-09-14 Thread Robert Haas
On Mon, Aug 8, 2011 at 7:47 AM, Robert Haas robertmh...@gmail.com wrote: I've been thinking about this too and actually went so far as to do some research and put together something that I hope covers most of the interesting cases.  The attached patch is pretty much entirely untested, but

Re: [HACKERS] foreign table: WARNING: problem in alloc set ExecutorState detected write past chunk end in block ...

2011-09-14 Thread Josh Kupershmidt
On Tue, Sep 13, 2011 at 7:38 PM, Tom Lane t...@sss.pgh.pa.us wrote: Hmm.  I tried on 64-bit Lion (10.7.1) and had no luck. Please try setting a gdb breakpoint on the warning elog (it's in aset.c) and looking to see what's the contents of the complained-of chunk.  That might give us a hint

Re: [HACKERS] DBI-LINK not support special support?

2011-09-14 Thread Robert Haas
On Wed, Sep 14, 2011 at 9:15 AM, paulo matadr saddon...@yahoo.com.br wrote: Any ideia for help You are much more likely to get help if you ask on the right mailing list, instead of here. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via