Re: limit and query planner

> On Jun 5, 2018, at 2:02 PM, Tom Lane wrote: > > armand pirvu writes: >> My question is: I suspect the limit simply limits the fethching to the first >> n-records retrieved and has no implications whatsoever on the planner, >> meaning the planner igno

Re: limit and query planner

> On Jun 5, 2018, at 1:32 PM, Pavel Stehule wrote: > > > > 2018-06-05 20:24 GMT+02:00 armand pirvu <mailto:armand.pi...@gmail.com>>: > All > > Please see below > > explain analyze select * from sp_i2birst_reg_staging_test where evt_id =

limit and query planner

All Please see below explain analyze select * from sp_i2birst_reg_staging_test where evt_id = 'ACSF17' and status=0 limit 10; QUERY PLAN --

Re: authentication failure

> On Apr 12, 2018, at 10:07 AM, armand pirvu wrote: > > >> On Apr 12, 2018, at 9:55 AM, Adrian Klaver > <mailto:adrian.kla...@aklaver.com>> wrote: >> >> On 04/12/2018 07:50 AM, armand pirvu wrote: >> >>>> I would be inclined to raise

Re: authentication failure

> On Apr 12, 2018, at 9:55 AM, Adrian Klaver wrote: > > On 04/12/2018 07:50 AM, armand pirvu wrote: > >>> I would be inclined to raise the authentication_timeout first before >>> setting the auth method to trust. >>> >>> I would also set the

Re: authentication failure

> On Apr 12, 2018, at 9:48 AM, Adrian Klaver wrote: > > On 04/12/2018 07:37 AM, armand pirvu wrote: >>> On Apr 12, 2018, at 9:28 AM, Adrian Klaver >>> wrote: >>> >>> On 04/12/2018 07:15 AM, armand pirvu wrote: >>> >>>&g

Re: authentication failure

> On Apr 12, 2018, at 9:28 AM, Adrian Klaver wrote: > > On 04/12/2018 07:15 AM, armand pirvu wrote: > >>> >>> >> Sorry for the double posting but could it be from >> #authentication_timeout = 1min# 1s-600s > > From you previous post: > &g

Re: authentication failure

> On Apr 12, 2018, at 9:12 AM, armand pirvu wrote: > > >> On Apr 12, 2018, at 9:08 AM, Adrian Klaver > <mailto:adrian.kla...@aklaver.com>> wrote: >> >> On 04/12/2018 06:59 AM, armand pirvu wrote: >> >> Please reply to list also. >> Cci

Re: authentication failure

> On Apr 12, 2018, at 9:08 AM, Adrian Klaver wrote: > > On 04/12/2018 06:59 AM, armand pirvu wrote: > > Please reply to list also. > Ccing list. >> Yes and worked fine until two days ago >> I use .pgpass > > So can you connect from wherever the p

authentication failure

Hi there I have a process in place which runs several queries from one host to another one All of a sudden I started noticing authentication failures Like below .009 ms statement: COPY NACDS.tf_show_code_response_person FROM STDIN with csv;","psql" 2018-04-12 00:10:48.765 CDT,"csi

Re: connection dropped from the backend server

Sent from my iPhone > On Mar 27, 2018, at 9:21 PM, armand pirvu wrote: > > >>> On Mar 27, 2018, at 6:49 PM, Tom Lane wrote: >>> >>> Adrian Klaver writes: >>>> On 03/27/2018 04:07 PM, armand pirvu wrote: >>>> As long

Re: connection dropped from the backend server

> On Mar 27, 2018, at 6:49 PM, Tom Lane wrote: > > Adrian Klaver writes: >> On 03/27/2018 04:07 PM, armand pirvu wrote: >>> As long as the connection stays up yes data gets fine across >>> In pg_stat_activity I see the node ip address where tail -f piped int

Re: connection dropped from the backend server

As long as the connection stays up yes data gets fine across In pg_stat_activity I see the node ip address where tail -f piped into psql happens Sent from my iPhone > On Mar 27, 2018, at 6:03 PM, Adrian Klaver wrote: > >> On 03/27/2018 03:36 PM, armand pirvu wrote: >>

connection dropped from the backend server

Hi all I have a process of some data manipulation and ultimate transfer to a postgres database A DML statement gest concoted with the transformed data and pusshed into a named pipe The named pipe is tailed -f in the background like this nohup $SHELL <

Re: ERROR: invalid byte sequence for encoding "UTF8": 0xfc

> On Mar 27, 2018, at 3:47 PM, armand pirvu wrote: > > Folks > > > From another system (non postgres) as data gets changed we collect in the > form like below into a named pipe which is tailed into psql -U csidba -d > repdb -hrephost > > insert into foo

Re: Proposition for better performance

> On Mar 27, 2018, at 4:25 PM, Paul Jungwirth > wrote: > > On 03/27/2018 11:42 AM, hmidi slim wrote: >> This is the message that I got: >> Successfully run. Total query runtime: 2 min. >> 1500 rows affected. > > Sorry, I don't think this is enough information to suggest anything. > > --

ERROR: invalid byte sequence for encoding "UTF8": 0xfc

Folks From another system (non postgres) as data gets changed we collect in the form like below into a named pipe which is tailed into psql -U csidba -d repdb -hrephost insert into foo (mydata) values ('{"mail_stop": "" , "city_id": "Garching bei M?nchen"}'); And got a failure ERROR: inval

Re: cursors and function question

> On Feb 13, 2018, at 4:37 PM, David G. Johnston > wrote: > > On Tue, Feb 13, 2018 at 3:31 PM, Adrian Klaver > wrote: > 2) By global table do you mean a temporary table? If so not sure that is > going to work as I am pretty sure it will disappear after the fu

Re: cursors and function question

> On Feb 13, 2018, at 1:22 PM, Adrian Klaver wrote: > > On 02/13/2018 11:17 AM, armand pirvu wrote: >>> On Feb 13, 2018, at 12:54 PM, Adrian Klaver >> <mailto:adrian.kla...@aklaver.com><mailto:adrian.kla...@aklaver.com >>> <mailto:adrian.kla...@ak

Re: cursors and function question

> On Feb 13, 2018, at 12:54 PM, Adrian Klaver wrote: > > On 02/13/2018 10:22 AM, armand pirvu wrote: >> Hi >> Is there any elegant way not a two steps way I can output the cursor value >> at each step? >> testtbl table has this content &

Re: cursors and function question

> On Feb 13, 2018, at 12:26 PM, David G. Johnston > wrote: > > On Tuesday, February 13, 2018, armand pirvu <mailto:armand.pi...@gmail.com>> wrote: > > CREATE OR REPLACE FUNCTION foofunc() >RETURNS text AS $$ > > sel

cursors and function question

Hi Is there any elegant way not a two steps way I can output the cursor value at each step? testtbl table has this content col1|col2| col3 ++-- E1 | CAT1 |0 E1 | CAT2 |0 E1 | CAT3 |0 E4

Re: characters converted to ??? in postgres

insight — Armand > On Jan 12, 2018, at 8:10 AM, Peter Eisentraut > wrote: > > On 1/11/18 20:52, armand pirvu wrote: >> The -n flag worked fine on OS X. I don’t have this issue on Centos. As a >> side question I wonder why was postgres built with libedit instead o

Re: characters converted to ??? in postgres

/11/18 16:34, armand pirvu wrote: >> On OS X: >> - case 1 fails >> testdb=# insert into jt1 values ('??') ; >> ERROR: invalid byte sequence for encoding "UTF8": 0xe2 0xa4 0x27 >> Note that at paste time ≤ changed in ?? > > This looks like someth

characters converted to ??? in postgres

Hi all, Got the following thing : ≠, ≤, and ≥ store in the database as question marks according to one of my developers. I have postgres installed on both MAC OS X and Centos 7 All locale on both point to UTF8 LANG=en_US.UTF-8 LC_CTYPE="en_US.UTF-8" LC_NUMERIC="en_US.UTF-8" LC_TIME="en_US