Re: [HACKERS] About BoringSSL, an OpenSSL fork

On 26 October 2015 at 00:59, Michael Paquier wrote: > https://boringssl.googlesource.com/boringssl/+/HEAD/PORTING.md > Looking at the porting section many routines have changed compared to > OpenSSL. I can't imagine this fork to become a complete replacement of >

Re: [HACKERS] questions about PG update performance

On Mon, Oct 26, 2015 at 12:07 PM, Ashutosh Bapat < ashutosh.ba...@enterprisedb.com> wrote: > > > On Mon, Oct 26, 2015 at 10:19 AM, Amit Kapila > wrote: >> >> >> I think Oracle just copies the changed part of old row to rollback >> segment. >> Also in Redo logs, it just

Re: [HACKERS] [PROPOSAL] Improvements of Hunspell dictionaries support

20.10.2015 17:00, Artur Zakirov пишет: These flag types are used in affix files of such dictionaries as ar, br_fr, ca, ca_valencia, da_dk, en_ca, en_gb, en_us, fr, gl_es, is, ne_np, nl_nl, si_lk (from http://cgit.freedesktop.org/libreoffice/dictionaries/tree/). Now almost all dictionaries are

Re: [HACKERS] [DESIGN] ParallelAppend

On Sun, Oct 25, 2015 at 9:23 PM, Kouhei Kaigai wrote: > I entirely agree with your suggestion. > > We may be able to use an analogy between PartialSeqScan and the > parallel- aware Append node. > PartialSeqScan fetches blocks pointed by the index on shared memory > segment,

Re: [HACKERS] questions about PG update performance

On Mon, Oct 26, 2015 at 4:09 PM, Amit Kapila wrote: > On Mon, Oct 26, 2015 at 12:07 PM, Ashutosh Bapat < > ashutosh.ba...@enterprisedb.com> wrote: > >> >> >> On Mon, Oct 26, 2015 at 10:19 AM, Amit Kapila >> wrote: >>> >>> >>> I think Oracle just

Re: [HACKERS] [PATCH v3] GSSAPI encryption support

On Thu, Oct 22, 2015 at 11:36 PM, Robbie Harwood wrote: > To be clear, what I need to know is: > - What changes do you want to see in the wire protocol? (And how will > fallback be supported if that's affected?) Hm. Something essential will be to send the length of the wrapped gss_buffer_t

Re: [HACKERS] questions about PG update performance

On Mon, Oct 26, 2015 at 10:19 AM, Amit Kapila wrote: > On Mon, Oct 26, 2015 at 9:03 AM, Любен Каравелов > wrote: > > > > > > - Цитат от Kisung Kim (ks...@bitnine.co.kr), на 26.10.2015 в 04:36 > - > > > > > However, what I want to know is about

[HACKERS] Patch (3): Implement failover on libpq connect level.

On 2015.10.14 at 13:41:51 +0300, Victor Wagner wrote: > Attached patch which implements client library failover and > loadbalancing as was described in the proposal > <20150818041850.ga5...@wagner.pp.ru>. New version of patch 1. Handles replication connections correctly (i.e doesn't attempt to

Re: [HACKERS] pgbench gaussian/exponential docs improvements

I was not only thinking of mathematical figures, I was also thinking of graphics, some format may be zip containing XML stuff for instance. But we don't need it here, so why should we care about it too much? I was just digressing about the main subject:-) Having some graphics in the doc

Re: [HACKERS] Proposal: Trigonometric functions in degrees

Dean Rasheed writes: > On 26 October 2015 at 14:18, Tom Lane wrote: >> ... but having said that, your argument here is faulty, because 0.9 >> in itself is not exactly representable in binary. You'd be relying >> on roundoff happening in the right

Re: [HACKERS] Proposal: Trigonometric functions in degrees

On 26 October 2015 at 18:58, Tom Lane wrote: > Dean Rasheed writes: >> On 26 October 2015 at 14:18, Tom Lane wrote: >>> ... but having said that, your argument here is faulty, because 0.9 >>> in itself is not exactly

Re: [HACKERS] UTF-32 support in PostgreSQL ?

On 10/23/2015 11:29 PM, fortin.christ...@videotron.ca wrote: Is PostgreSQL support UNICODE UTF-32 characters ? If not, I think it's a must to be internationnal. To help you in this task, you could use this UTF-32 editor: https://wxmedit.github.io/downloads.html thanks. Do you mean

Re: [HACKERS] Patch: Implement failover on libpq connect level.

On 26 October 2015 at 16:25, Peter Eisentraut wrote: > On 10/14/15 6:41 AM, Victor Wagner wrote: > > 1. It is allowed to specify several hosts in the connect string, either > > in URL-style (separated by comma) or in param=value form (several host > > parameters). > > I'm not

Re: [HACKERS] Proposal: Trigonometric functions in degrees

On 26 October 2015 at 19:45, Peter Eisentraut wrote: > On 10/24/15 5:24 AM, Dean Rasheed wrote: >> Additionally, functions that worked natively in degrees would be able >> to return exact answers in special cases like cosd(90) = 0, whereas >> cos(radians(90)) is not exactly 0

Re: [HACKERS] Patch (2): Implement failover on libpq connect level.

On 10/24/15 7:55 AM, Robert Haas wrote: > On Fri, Oct 23, 2015 at 4:02 PM, Korry Douglas > wrote: >> When you call pg_is_in_recovery(), you should schema-qualify the function >> name, just in case some other version of that function exists in the >> search_path. >

Re: [HACKERS] Proposal: Trigonometric functions in degrees

On 10/24/15 5:24 AM, Dean Rasheed wrote: > Additionally, functions that worked natively in degrees would be able > to return exact answers in special cases like cosd(90) = 0, whereas > cos(radians(90)) is not exactly 0 because pi/2 cannot be represented > exactly as a floating point number. But

Re: [HACKERS] Proposal: Trigonometric functions in degrees

On 10/26/15 1:48 PM, Simon Riggs wrote: Deviation from SI units is no laughing matter. How would we even know how to capitalise "Fortnight"? It's all fun and games until someone pokes Mars' eye out with a spacecraft. https://en.wikipedia.org/wiki/Mars_Climate_Orbiter (Ok, I guess we just

Re: [HACKERS] Proposal: Trigonometric functions in degrees

Dean Rasheed writes: > On 26 October 2015 at 19:45, Peter Eisentraut wrote: >> But how you are going to implement that? I don't see a sind() in the C >> library. > I'm thinking something along the lines of: > 1. Reduce the range of the input (say to

Re: [HACKERS] Patch: Implement failover on libpq connect level.

On 10/14/15 6:41 AM, Victor Wagner wrote: > 1. It is allowed to specify several hosts in the connect string, either > in URL-style (separated by comma) or in param=value form (several host > parameters). I'm not fond of having URLs that are not valid URLs according to the applicable standards.

Re : Re: [HACKERS] UTF-32 support in PostgreSQL ?

 Do you mean data stored as UTF-32, or source code in UTF-32, or translation files as UTF-32? I mean for ALL, data stored, source code, and translation files. For source code, I think then GCC must support UTF-32 before. I sent an e-mail to Oracle to see what they tink about this huge idea.

Re: Re : Re: [HACKERS] UTF-32 support in PostgreSQL ?

On Mon, Oct 26, 2015 at 6:20 PM, Craig Ringer wrote: > UTF-16 is like UCS-2, but adds UTF-8-like escape sequences to handle > the high 16 bits of the 32-bit Unicode space. It combines the worst > features of UTF-8 and UCS-2. UTF-16 is the character set used by > Windows

Re: [HACKERS] questions about PG update performance

On 10/25/15 9:36 PM, Kisung Kim wrote: I want to explain for our clients that PG's update performance is comparable to Oracle's. There's really only 2 ways you can answer that. You can either handwave the question away ("Yes, update performance is comparable."), or you have to do actual

Re: [HACKERS] Proposal: Trigonometric functions in degrees

On 26 October 2015 at 20:19, Tom Lane wrote: > Dean Rasheed writes: >> I'm thinking something along the lines of: > >> 1. Reduce the range of the input (say to 0..90 degrees). >> 2. Handle special cases (0, 30 and 90 for sind()). >> 3. Otherwise

Re: [HACKERS] Proposal: Trigonometric functions in degrees

Dean Rasheed writes: > Personally I'd rather have sind(30) be exactly 0.5, even if > sind(29.999...) or sind(30.000...1) ended up the wrong side of it. TBH, sir, if you think that you are too dangerous to be allowed anywhere near any numerical analysis code. Preserving

Re: [HACKERS] pg_basebackup and replication slots

On 10/26/2015 12:58 PM, Joshua D. Drake wrote: Hello, The fact that pg_basebackup doesn't use replicaiton slots, is that a technical limitation or just a, "we need a patch"? Given the rest of the thread any possibility whatsoever that it'd be backpatched into 9.5 before release?

Re: [HACKERS] Proposal: Trigonometric functions in degrees

> > ​ > Stupid question - is sin(3m) a call-through to the math coprocessor?​ It probably only matters when doing a series of calculations (where the extra guard bits can matter) and not when doing a simple one-time lookup but it might be something to consider in regards to setting a precedent.

Re: [HACKERS] questions about PG update performance

On 27/10/15 11:37, Jim Nasby wrote: On 10/25/15 9:36 PM, Kisung Kim wrote: I want to explain for our clients that PG's update performance is comparable to Oracle's. There's really only 2 ways you can answer that. You can either handwave the question away ("Yes, update performance is

Re: Re : Re: [HACKERS] UTF-32 support in PostgreSQL ?

On 27 October 2015 at 05:39, wrote: > I mean for ALL, data stored, source code, and translation files. > For source code, I think then GCC must support UTF-32 before. Why? UTF-32 is an incredibly inefficient way to store text that's predominantly or entirely

Re: [HACKERS] pg_basebackup and replication slots

On 10/26/2015 08:14 PM, Michael Paquier wrote: On Tue, Oct 27, 2015 at 7:18 AM, José Luis Tallón wrote: Given the rest of the thread any possibility whatsoever that it'd be backpatched into 9.5 before release? Guess it'd be a very welcome addition This will be available in 9.6.

Re: [HACKERS] Dangling Client Backend Process

On 23 October 2015 01:58, Robert Haas [mailto:robertmh...@gmail.com] Wrote: >Well, I'm not buying this extra PostmasterIsAlive() call on every pass >through the main loop. That seems more expensive than we can really >justify. Checking this when we're already calling WaitLatchOrSocket is

Re: [HACKERS] Multi-tenancy with RLS

On Wed, Oct 21, 2015 at 2:42 PM, Haribabu Kommi wrote: > Pending items: > 1. Need to add some more tests to verify all database catalog tables. > 2. Documentation changes for database catalog tenancy. Here I attached the updated database-catalog-security with more tests

Re: [HACKERS] pg_basebackup and replication slots

On Tue, Oct 27, 2015 at 7:18 AM, José Luis Tallón wrote: > Given the rest of the thread any possibility whatsoever that it'd be > backpatched into 9.5 before release? > Guess it'd be a very welcome addition This will be available in 9.6. 9.5 is aimed at being stabilized now, so no new

Re: [HACKERS] [DESIGN] ParallelAppend

> -Original Message- > From: pgsql-hackers-ow...@postgresql.org > [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Robert Haas > Sent: Monday, October 26, 2015 8:53 PM > To: Kaigai Kouhei(海外 浩平) > Cc: pgsql-hackers@postgresql.org; Amit Kapila; Kyotaro HORIGUCHI > Subject: Re:

Re: [HACKERS] questions about PG update performance

On Mon, Oct 26, 2015 at 4:31 PM, Ashutosh Bapat < ashutosh.ba...@enterprisedb.com> wrote: > > On Mon, Oct 26, 2015 at 4:09 PM, Amit Kapila > wrote: > >> On Mon, Oct 26, 2015 at 12:07 PM, Ashutosh Bapat < >> ashutosh.ba...@enterprisedb.com> wrote: >> >>> >>> >>> On Mon,

Re: [HACKERS] Proposal: Trigonometric functions in degrees

On 26 October 2015 at 14:18, Tom Lane wrote: >> Having degree-based functions would make it trivial to implement >> user-defined gradian-based functions, just by multiplying or dividing >> by 0.9, and they would return exact results in the smaller number of >> cases where

Re: [HACKERS] Proposal: Trigonometric functions in degrees

On 26 October 2015 at 13:58, Robert Haas wrote: > > Also -1 to furlongs, fortnights, pecks and hundredweight, amongst others. > > Aw, you're no fun. select '1 fortnight'::interval => '14 days' would be > cool. > Deviation from SI units is no laughing matter. How would

Re: [HACKERS] questions about PG update performance

On 10/26/2015 05:49 AM, Amit Kapila wrote: On Mon, Oct 26, 2015 at 9:03 AM, Любен Каравелов > wrote: > > > - Цитат от Kisung Kim (ks...@bitnine.co.kr ), на 26.10.2015 в 04:36 - > > > However, what I want to know

Re: [HACKERS] Proposal: Trigonometric functions in degrees

Dean Rasheed writes: > On 25 October 2015 at 09:16, Emre Hasegeli wrote: >> I would prefer gradian over degree. > I think gradians are generally less commonly used than degrees and > radians, so I'm less inclined to include them. I agree. gradians

Re: [HACKERS] pg_basebackup and replication slots

On Mon, Oct 26, 2015 at 12:58 PM, Joshua D. Drake wrote: > Hello, > > The fact that pg_basebackup doesn't use replicaiton slots, is that a > technical limitation or just a, "we need a patch"? > I believe it does, but only in master so far, not even in 9.5:

Re: [HACKERS] pg_basebackup and replication slots

On 26-10-2015 08:58, Joshua D. Drake wrote: Hello, The fact that pg_basebackup doesn't use replicaiton slots, is that a technical limitation or just a, "we need a patch"? It is not in 9.5 but it is already there. commit 0dc848b0314d63188919f1ce943730eac684dccd Author: Peter Eisentraut

Re: [HACKERS] Proposal: Trigonometric functions in degrees

On 25 October 2015 at 09:16, Emre Hasegeli wrote: >> Currently PostgreSQL only has trigonometric functions that work in >> radians. I think it would be quite useful to have an equivalent set of >> functions that worked in degrees. In other environments these are >> commonly

Re: [HACKERS] Avoid full page images in streaming replication?

--On 22. Oktober 2015 22:23:58 -0300 Alvaro Herrera wrote: >> You can? The xlog format between 9.4 and 9.5 changed, so I can't see how >> that'd work? > > Oh, crap. Must have been some other cross-version trial run I did, > then. I would hope it's at least not

Re: [HACKERS] Patch (3): Implement failover on libpq connect level.

On Mon, Oct 26, 2015 at 3:58 AM, Victor Wagner wrote: > On 2015.10.14 at 13:41:51 +0300, Victor Wagner wrote: >> Attached patch which implements client library failover and >> loadbalancing as was described in the proposal >> <20150818041850.ga5...@wagner.pp.ru>. > > New

[HACKERS] pg_basebackup and replication slots

Hello, The fact that pg_basebackup doesn't use replicaiton slots, is that a technical limitation or just a, "we need a patch"? JD -- Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564 PostgreSQL Centered full stack support, consulting and development. Announcing "I'm offended"

Re: [HACKERS] Avoid full page images in streaming replication?

--On 23. Oktober 2015 00:03:30 +0200 Andres Freund wrote: > > Note that FPIs are often pretty good for replay performance, avoiding > lots of synchronous random reads. That's a very import argument, i think. The difference can be significant, even if you have a decent

Re: [HACKERS] Freezing without cleanup lock

On Mon, Oct 26, 2015 at 4:39 AM, Jim Nasby wrote: > On 10/22/15 6:39 PM, Alvaro Herrera wrote: >> >> Jim Nasby wrote: >> >>> That would be the minimal-impact version, yes. But I suspect if we went >>> through the trouble to do that, it would be just as easy to attempt

Re: [HACKERS] Proposal: Trigonometric functions in degrees

On 26 October 2015 at 10:18, Tom Lane wrote: > Dean Rasheed writes: > > On 25 October 2015 at 09:16, Emre Hasegeli wrote: > >> I would prefer gradian over degree. > > > I think gradians are generally less commonly used than

Re: [HACKERS] Proposal: Trigonometric functions in degrees

On Mon, Oct 26, 2015 at 1:29 PM, Simon Riggs wrote: > On 26 October 2015 at 10:18, Tom Lane wrote: >> Dean Rasheed writes: >> > On 25 October 2015 at 09:16, Emre Hasegeli wrote: >> >> I would prefer gradian

[HACKERS] UTF-32 support in PostgreSQL ?

Is PostgreSQL support UNICODE UTF-32 characters ? If not, I think it's a must to be internationnal. To help you in this task, you could use this UTF-32 editor: https://wxmedit.github.io/downloads.html thanks.

Re: [HACKERS] Patch (2): Implement failover on libpq connect level.

On 24 October 2015 at 07:32, Victor Wagner wrote: > В Fri, 23 Oct 2015 22:14:56 +0100 > Thom Brown пишет: > > c> > >> > pg_basebackup -v -x -D standby1 \ >> > -d "host=localhost port=5532 user=rep_user readonly=1" >> >> Yes, this works: >> >> $ pg_basebackup

[HACKERS] WIP: Fix parallel workers connection bug in pg_dump (Bug #13727)

Parallel workers were failing to connect to the database when running pg_dump with a connection string. The first of the following two commands runs without errors, while the second one fails: pg_dump "postgres://my-user:my-passw...@my.hostname.com:5432/my-db" -Fd -f my-dump pg_dump

Re: [HACKERS] UTF-32 support in PostgreSQL ?

On 2015-10-23 23:29:53 -0400, fortin.christ...@videotron.ca wrote: > Is PostgreSQL support UNICODE UTF-32 characters ? No. > If not, I think it's a must to be internationnal. Why? I think Unicode support is a must, but I don't see why utf-32 support is. Postgres supports UTF-8, and I haven't

Re: [HACKERS] UTF-32 support in PostgreSQL ?

fortin.christ...@videotron.ca writes: > Is PostgreSQL support UNICODE UTF-32 characters ? There's no particular intention of supporting the UTF32 representation inside the database. We do support UTF8 representation of the entire Unicode character set. You can transcode to and from UTF32 easily