Re: [HACKERS] Perfomance degradation 9.3 (vs 9.2) for FreeBSD

2014-04-20 Thread Francois Tigeot
Hi, On Sun, Apr 20, 2014 at 11:24:38AM +0200, Palle Girgensohn wrote: I see performance degradation with PostgreSQL 9.3 vs 9.2 on FreeBSD, and I'm wondering who to poke to mitigate the problem. In reference to this thread [1], who where the FreeBSD people that Francois mentioned? At least

Re: [HACKERS] Perfomance degradation 9.3 (vs 9.2) for FreeBSD

2014-04-20 Thread Palle Girgensohn
20 apr 2014 kl. 12:19 skrev Francois Tigeot ftig...@wolfpond.org: Hi, On Sun, Apr 20, 2014 at 11:24:38AM +0200, Palle Girgensohn wrote: I see performance degradation with PostgreSQL 9.3 vs 9.2 on FreeBSD, and I'm wondering who to poke to mitigate the problem. In reference to this

Re: [HACKERS] Minor improvement in src/backend/access/gin/README

2014-04-20 Thread Robert Haas
On Fri, Apr 18, 2014 at 10:28 AM, Etsuro Fujita fujita.ets...@lab.ntt.co.jp wrote: The attached improves a document in src/backend/access/gin/README. Committed. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list

Re: [HACKERS] Minor improvement in gin_private.h

2014-04-20 Thread Robert Haas
On Fri, Apr 18, 2014 at 10:43 AM, Etsuro Fujita fujita.ets...@lab.ntt.co.jp wrote: The attached improves a comment in gin_private.h a little bit. Committed also. That comment should probably be rephrased more extensively, something like We use our own versions of ItemPointerGetBlockNumber and

Re: [HACKERS] DISCARD ALL (Again)

2014-04-20 Thread Robert Haas
On Fri, Apr 18, 2014 at 2:24 AM, Tom Lane t...@sss.pgh.pa.us wrote: 2. While I'm no Python expert, I believe GD is just a specific instance of a general capability for global state in Python. Are we going to promise that any and all user-created data inside Python goes away? What about other

Re: [HACKERS] PostgreSQL in Windows console and Ctrl-C

2014-04-20 Thread Christian Ullrich
OK, here is the first draft against current master. It builds on Windows with VS 2012 and on FreeBSD 10 with clang 3.3. I ran the regression tests on Windows, they all pass. The changed behavior is limited to Windows, where it now silently ignores Ctrl-C and Ctrl-Break when started via pg_ctl

Re: [HACKERS] Composite Datums containing toasted fields are a bad idea(?)

2014-04-20 Thread Tom Lane
I wrote: The main problem with this patch, as I see it, is that it'll introduce extra syscache lookup overhead even when there are no toasted fields anywhere. I've not really tried to quantify how much, since that would require first agreeing on a benchmark case --- anybody have a thought

Re: [HACKERS] DISCARD ALL (Again)

2014-04-20 Thread Stephen Frost
* Robert Haas (robertmh...@gmail.com) wrote: On Fri, Apr 18, 2014 at 2:24 AM, Tom Lane t...@sss.pgh.pa.us wrote: 2. While I'm no Python expert, I believe GD is just a specific instance of a general capability for global state in Python. Are we going to promise that any and all user-created

[HACKERS] Removing dependency to wsock32.lib when compiling code on WIndows

2014-04-20 Thread Michael Paquier
Hi all, When doing some work on Windows, I noticed that the mkvc specs in src/tools/msvc use wsock32.lib, which is as far as I understand an old, obsolete version of the Windows socket library. Wouldn't it make sense to update the specs to build only with ws2_32.lib like in the patch attached?

Re: [HACKERS] PATCH: Allow empty targets in unaccent dictionary

2014-04-20 Thread David Fetter
Please add this to the next commitfest. https://commitfest.postgresql.org/action/commitfest_view?id=22 Cheers, David. On Sun, Apr 20, 2014 at 01:06:43AM +0200, Mohammad Alhashash wrote: Hi, Currently, unaccent extension only allows replacing one source character with one or more target

[HACKERS] New functions in sslinfo module

2014-04-20 Thread Воронин Дмитрий
Hello, I make an a patch, which adds 4 functions to sslinfo extension module:1) ssl_get_count_of_extensions() --- get count of X509v3 extensions from client certificate;2) ssl_get_extension_names() --- get short names of X509v3 extensions from client certificate;3) ssl_get_extension_value(text)

Re: [HACKERS] Composite Datums containing toasted fields are a bad idea(?)

2014-04-20 Thread Noah Misch
I lack time to give this a solid review, but here's a preliminary reaction: On Sun, Apr 20, 2014 at 03:38:23PM -0400, Tom Lane wrote: On HEAD, this takes about 295-300 msec on my machine in a non-cassert build. With the patch I sent previously, the time goes to 495-500 msec. This goes from

Re: [HACKERS] New functions in sslinfo module

2014-04-20 Thread Michael Paquier
On Mon, Apr 21, 2014 at 1:48 PM, Воронин Дмитрий carriingfat...@yandex.ru wrote: Hello, I make an a patch, which adds 4 functions to sslinfo extension module: 1) ssl_get_count_of_extensions() --- get count of X509v3 extensions from client certificate; 2) ssl_get_extension_names() --- get

Re: [HACKERS] New functions in sslinfo module

2014-04-20 Thread Воронин Дмитрий
I put patch generated on git diffs to this letter. I make an a thread in postgresql commit fest: https://commitfest.postgresql.org/action/patch_view?id=1438 21.04.2014, 09:12, "Michael Paquier" michael.paqu...@gmail.com:On Mon, Apr 21, 2014 at 1:48 PM, Воронин Дмитрий carriingfat...@yandex.ru