limit and query planner

2018-06-05 Thread armand pirvu
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: limit and query planner

2018-06-05 Thread armand pirvu
> 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 =

Re: limit and query planner

2018-06-05 Thread armand pirvu
> 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: characters converted to ??? in postgres

2018-01-12 Thread armand pirvu
and insight — Armand > On Jan 12, 2018, at 8:10 AM, Peter Eisentraut > <peter.eisentr...@2ndquadrant.com> 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 w

characters converted to ??? in postgres

2018-01-11 Thread armand pirvu
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"

Re: characters converted to ??? in postgres

2018-01-11 Thread armand pirvu
drant.com> wrote: > > On 1/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 ??

cursors and function question

2018-02-13 Thread armand pirvu
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: cursors and function question

2018-02-13 Thread armand pirvu
> On Feb 13, 2018, at 12:26 PM, David G. Johnston <david.g.johns...@gmail.com> > wrote: > > On Tuesday, February 13, 2018, armand pirvu <armand.pi...@gmail.com > <mailto:armand.pi...@gmail.com>> wrote: > > CREATE OR REPLACE FUNCTION foofunc() >

Re: cursors and function question

2018-02-13 Thread armand pirvu
> On Feb 13, 2018, at 12:54 PM, Adrian Klaver <adrian.kla...@aklaver.com> 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 ha

Re: cursors and function question

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

Re: cursors and function question

2018-02-13 Thread armand pirvu
> 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

Re: authentication failure

2018-04-12 Thread armand pirvu
> On Apr 12, 2018, at 9:28 AM, Adrian Klaver <adrian.kla...@aklaver.com> 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 >

Re: authentication failure

2018-04-12 Thread armand pirvu
> On Apr 12, 2018, at 9:48 AM, Adrian Klaver <adrian.kla...@aklaver.com> wrote: > > On 04/12/2018 07:37 AM, armand pirvu wrote: >>> On Apr 12, 2018, at 9:28 AM, Adrian Klaver <adrian.kla...@aklaver.com> >>> wrote: >>>

Re: authentication failure

2018-04-12 Thread armand pirvu
> On Apr 12, 2018, at 9:08 AM, Adrian Klaver <adrian.kla...@aklaver.com> 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 yo

Re: authentication failure

2018-04-12 Thread armand pirvu
> On Apr 12, 2018, at 9:12 AM, armand pirvu <armand.pi...@gmail.com> wrote: > > >> On Apr 12, 2018, at 9:08 AM, Adrian Klaver <adrian.kla...@aklaver.com >> <mailto:adrian.kla...@aklaver.com>> wrote: >> >> On 04/12/2018 06:59 AM, armand pirv

Re: authentication failure

2018-04-12 Thread armand pirvu
> On Apr 12, 2018, at 9:55 AM, Adrian Klaver <adrian.kla...@aklaver.com> 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. >>> &g

Re: authentication failure

2018-04-15 Thread armand pirvu
> On Apr 12, 2018, at 10:07 AM, armand pirvu <armand.pi...@gmail.com> wrote: > > >> On Apr 12, 2018, at 9:55 AM, Adrian Klaver <adrian.kla...@aklaver.com >> <mailto:adrian.kla...@aklaver.com>> wrote: >> >> On 04/12/2018 07:50 AM, armand

connection dropped from the backend server

2018-03-27 Thread armand pirvu
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

2018-03-27 Thread armand pirvu
> On Mar 27, 2018, at 3:47 PM, armand pirvu <armand.pi...@gmail.com> 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 -hrephos

Re: connection dropped from the backend server

2018-03-27 Thread armand pirvu
Sent from my iPhone > On Mar 27, 2018, at 9:21 PM, armand pirvu <armand.pi...@gmail.com> wrote: > > >>> On Mar 27, 2018, at 6:49 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: >>> >>> Adrian Klaver <adrian.kla...@aklaver.com> writes: >>

Re: connection dropped from the backend server

2018-03-27 Thread armand pirvu
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 <adrian.kla...@aklaver.com> wrote: > >> On 03/27/2018 03:3

Re: connection dropped from the backend server

2018-03-27 Thread armand pirvu
> On Mar 27, 2018, at 6:49 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > > Adrian Klaver <adrian.kla...@aklaver.com> 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_

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

2018-03-27 Thread armand pirvu
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:

Re: Proposition for better performance

2018-03-27 Thread armand pirvu
> 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