Re: How bad is using queries with thousands of values for operators IN or ANY?

2020-09-01 Thread Kyotaro Horiguchi
At Tue, 1 Sep 2020 18:46:01 +0200, Pavel Stehule wrote in > nice :) thanks ;p regards. -- Kyotaro Horiguchi NTT Open Source Software Center

Re: High Availability, guarantee to use sync nodes

2020-09-01 Thread Maksim Milyutin
On 31.08.2020 14:06, Dirk Krautschick wrote: Hi all, Hi if there are several PostgreSQL nodes replicating synchronous and I configure a guarantee that for example 3 of 5 nodes have to be in sync to go on with synchronous_standby_names and now I want to implement a load balancing scenar

Re: How bad is using queries with thousands of values for operators IN or ANY?

2020-09-01 Thread Pavel Stehule
út 1. 9. 2020 v 9:22 odesílatel Kyotaro Horiguchi napsal: > At Mon, 31 Aug 2020 16:04:43 +0200, Pavel Stehule > wrote in > > po 31. 8. 2020 v 13:29 odesílatel Thomas Kellerer > napsal: > > > > > Thorsten Schöning schrieb am 31.08.2020 um 12:37: > > > > So for what query size or number of IDs to

Re: How bad is using queries with thousands of values for operators IN or ANY?

2020-09-01 Thread Michael Lewis
On Tue, Sep 1, 2020 at 1:22 AM Kyotaro Horiguchi wrote: > FWIW, the attached is the dusted-off version of a part of a stalled > development of mine, which unconditionally(!) creates on-the-fly > statistics on VALUES list. It seems to work for certain cases, > although the planning time increa

Re: Trigger transaction isolation

2020-09-01 Thread Tom Lane
Adrian Klaver writes: > As I understand it a trigger function runs in its own transaction so the > rules from below apply: > https://www.postgresql.org/docs/12/transaction-iso.html No, a trigger is part of the calling transaction. There's nothing special about it other than the condition causin

Re: Trigger transaction isolation

2020-09-01 Thread Adrian Klaver
On 9/1/20 7:07 AM, Dirk Lattermann wrote: Hello! Since unfortunately nobody has yet replied to my question, I'd like to know if this is the right list to ask this question on or if I should try another mailing list. Maybe the answer is too obvious, but in that case I'd appreciate a short hint to

Re: Trigger transaction isolation

2020-09-01 Thread Dirk Lattermann
Hello! Since unfortunately nobody has yet replied to my question, I'd like to know if this is the right list to ask this question on or if I should try another mailing list. Maybe the answer is too obvious, but in that case I'd appreciate a short hint to help me finding it. Maybe it's a hard quest

RE: [EXTERNAL] Re: Numeric data types

2020-09-01 Thread Godfrin, Philippe E
Very well, thanks very much. pg From: Bruce Momjian Sent: Monday, August 31, 2020 5:31 PM To: Godfrin, Philippe E Cc: pgsql-gene...@postgresql.org Subject: Re: [EXTERNAL] Re: Numeric data types On Mon, Aug 31, 2020 at 10:20:51PM +, Godfrin, Philippe E wrote: > Frankly, I’m not certain, I be

回复: 回复: Is it possible to set end-of-data marker for COPY statement.

2020-09-01 Thread Junfeng Yang
Thanks for your response!

回复: Is it possible to set end-of-data marker for COPY statement.

2020-09-01 Thread Junfeng Yang
Thanks, Laurenz! I understand `\\.` should work. But this requires users to modify huge data. I'm wondering is it possible to change the default end-of-data marker or could we implement a method to let users choose their own marker? 发件人: Laurenz Albe 发送时间: 2020年9月

Re: 回复: Is it possible to set end-of-data marker for COPY statement.

2020-09-01 Thread Laurenz Albe
Please, don't top-post on these lists. On Tue, 2020-09-01 at 09:20 +, Junfeng Yang wrote: > > 发件人: Laurenz Albe > > On Tue, 2020-09-01 at 06:14 +, Junfeng Yang wrote: > > > As described in the doc , the TEXT format recognizes > > > backslash-period (\.) as end-of-data marker. > > > > > >

Re: Is it possible to set end-of-data marker for COPY statement.

2020-09-01 Thread Laurenz Albe
[redirected from -hackers] On Tue, 2020-09-01 at 06:14 +, Junfeng Yang wrote: > As described in the doc > https://www.postgresql.org/docs/current/sql-copy.html, the TEXT format > recognizes > backslash-period (\.) as end-of-data marker. > > The example below will raise an error for the line

Re: How bad is using queries with thousands of values for operators IN or ANY?

2020-09-01 Thread Kyotaro Horiguchi
At Mon, 31 Aug 2020 16:04:43 +0200, Pavel Stehule wrote in > po 31. 8. 2020 v 13:29 odesílatel Thomas Kellerer napsal: > > > Thorsten Schöning schrieb am 31.08.2020 um 12:37: > > > So for what query size or number of IDs to compare in IN would you > > > consider a different approach at all? >