[HACKERS] Is SPI safe to use in multi-threaded PL/Java?

2014-03-08 Thread MauMau
Hello, Is PL/Java safe to use in terms of its threading design? I'm going to ask the PL/Java community about this too, but I'd ask for opinions here because I believe people in this community have seasoned knowledge of OS and SPI. To put the question in other words, is it safe to load a

[HACKERS] Little confusing things about client_min_messages.

2014-03-08 Thread Tomonari Katsumata
Hi, I noticed that the behavior of client_min_messages do not have a consistency in document and 'pg_settings', postgresql.conf. the behaviro is: I can set 'INFO', 'FATAL' and 'PANIC' as the valid value. postgres=# set client_min_messages to info; SET postgres=# set

[HACKERS] Selection of join algorithm.

2014-03-08 Thread Ishaya Bhatt
Hi, I am trying to analyze join performance. But I see that even for a table having 100,000 rows and join attribute as primary key, postgres always performs hash join. Can anyone please tell me under which conditions merge join or nested loop join is invoked? Thanks and Regards, Ishaya

Re: [HACKERS] Static Code Analysis Exploits.

2014-03-08 Thread Patrick Curran
On 03/07/2014 07:19 PM, Tom Lane wrote: Patrick Curran pcur...@contentanalyst.com writes: We use Postgres in our product and we have a client that requires a static code analysis scan to detect vulnerabilities. They are concerned because the tool (Veracode) found several flaws in Postgres and

Re: [HACKERS] Selection of join algorithm.

2014-03-08 Thread Atri Sharma
On Saturday, March 8, 2014, Ishaya Bhatt ishayabh...@gmail.com wrote: Hi, I am trying to analyze join performance. But I see that even for a table having 100,000 rows and join attribute as primary key, postgres always performs hash join. Can anyone please tell me under which conditions

Re: [HACKERS] Shave a few instructions from child-process startup sequence

2014-03-08 Thread Tom Lane
Bruce Momjian br...@momjian.us writes: On Sun, Dec 1, 2013 at 12:07:21PM -0500, Gurjeet Singh wrote: Yes, this is a performance patch, but as the subject says, it saves a few instructions. I don't know how to write a test case that can measure savings of skipping a few instructions in a

Re: [HACKERS] Is SPI safe to use in multi-threaded PL/Java?

2014-03-08 Thread Tom Lane
MauMau maumau...@gmail.com writes: Is PL/Java safe to use in terms of its threading design? I'm going to ask the PL/Java community about this too, but I'd ask for opinions here because I believe people in this community have seasoned knowledge of OS and SPI. To put the question in other

Re: [HACKERS] Little confusing things about client_min_messages.

2014-03-08 Thread Tom Lane
Tomonari Katsumata t.katsumata1...@gmail.com writes: [ client_min_messages = info is not documented ] That's intentional, because it's not a useful setting. Even more so for the other two. regards, tom lane -- Sent via pgsql-hackers mailing list

Re: [HACKERS] gaussian distribution pgbench

2014-03-08 Thread Fabien COELHO
Hello Mitsumasa-san, New \setrandom interface is here. \setrandom var min max [gaussian threshold | exponential threshold] Attached patch realizes this interface, but it has little bit ugly codeing in executeStatement() and process_commands().. I think it is not too bad. The ignore extra

Re: [HACKERS] Little confusing things about client_min_messages.

2014-03-08 Thread Bruce Momjian
On Sat, Mar 8, 2014 at 11:31:22AM -0500, Tom Lane wrote: Tomonari Katsumata t.katsumata1...@gmail.com writes: [ client_min_messages = info is not documented ] That's intentional, because it's not a useful setting. Even more so for the other two. Well, 'info' is between other settings we

Re: [HACKERS] Little confusing things about client_min_messages.

2014-03-08 Thread Tom Lane
Bruce Momjian br...@momjian.us writes: On Sat, Mar 8, 2014 at 11:31:22AM -0500, Tom Lane wrote: Tomonari Katsumata t.katsumata1...@gmail.com writes: [ client_min_messages = info is not documented ] That's intentional, because it's not a useful setting. Even more so for the other two.

Re: [HACKERS] pg_ctl status with nonexistent data directory

2014-03-08 Thread Bruce Momjian
On Sat, Mar 8, 2014 at 09:08:31AM +0530, Amit Kapila wrote: On Fri, Mar 7, 2014 at 7:59 PM, Bruce Momjian br...@momjian.us wrote: On Fri, Mar 7, 2014 at 07:18:04PM +0530, Amit Kapila wrote: OK, done with the attached patch Three is returned for status, but one for other cases. I

Re: [HACKERS] Comment - uniqueness of relfilenode

2014-03-08 Thread Bruce Momjian
On Thu, Mar 6, 2014 at 09:20:39PM -0500, Bruce Momjian wrote: On Thu, Mar 6, 2014 at 08:34:29AM +0100, Antonin Houska wrote: You're right. I missed the fact that Postgres (unlike another DBMS that I worked with) allows for tablespace to be shared across databases. I have update the

Re: [HACKERS] Improve timestamp substraction to be DST-aware

2014-03-08 Thread Bruce Momjian
On Mon, Dec 2, 2013 at 11:43:06PM +0100, Piotr Marcinczyk wrote: The alternative proposal that's been on the table for awhile (see the preceding entry in the TODO list) is to remove the interval_justify_hours call in timestamp_mi, which would also have the effect of fixing the

Re: [HACKERS] git-review: linking commits to review discussion in git

2014-03-08 Thread Murtuza Mukadam
Hi Heikki We have linked git commits and reviews in a web interface. If you enter a commit hash, you will be redirected to the email archive of the peer review discussion: http://cesel.encs.concordia.ca/git-reviewed-tracker.php This work is part of my thesis, so feedback is much appreciated. If

[HACKERS] Re: [COMMITTERS] pgsql: libpq: change PQconndefaults() to ignore invalid service files

2014-03-08 Thread Bruce Momjian
On Tue, Dec 3, 2013 at 11:42:08AM -0500, Tom Lane wrote: Bruce Momjian br...@momjian.us writes: On Tue, Dec 3, 2013 at 11:30:15AM -0500, Tom Lane wrote: Why does this patch remove the errorMessage argument from pg_fe_getauthname? I gauge the amount of thought that went into that choice

Re: [HACKERS] ANALYZE sampling is too good

2014-03-08 Thread Bruce Momjian
I assume we never came up with a TODO from this thread: --- On Tue, Dec 3, 2013 at 11:30:44PM +, Greg Stark wrote: At multiple conferences I've heard about people trying all sorts of gymnastics to avoid ANALYZE which

Re: [HACKERS] Patch: show relation and tuple infos of a lock to acquire

2014-03-08 Thread Amit Kapila
On Thu, Feb 27, 2014 at 4:14 PM, Christian Kruse christ...@2ndquadrant.com wrote: On 25/02/14 16:11, Robert Haas wrote: Reading this over, I'm not sure I understand why this is a CONTEXT at all and not just a DETAIL for the particular error message that it's supposed to be decorating.