Re: [PERFORM] printing results of query to file in different times

Hi Mariel, On 9/7/2017 7:02 AM, Mariel Cherkassky wrote: I'm pretty sure that the source tables are changing during the loop. I have no problem showing the query :        SELECT AREA,                PHONE,                TERM_CODE,                LINE_NO,                PAYMENT_START_DATE,    

Re: [PERFORM] printing results of query to file in different times

Hi Mariel, On 9/6/2017 4:38 AM, Mariel Cherkassky wrote: I'm sure that those tables arent involved in any other transaction when the loop is running. Anything else that I can check ? I think that mybe its connected to some fetching properties but Im not familiar with what settings.. That's

Re: [PERFORM] printing results of query to file in different times

Geez ... I just saw how my last message got mangled. Trying again. On 9/5/2017 7:28 AM, Mariel Cherkassky wrote: I didn't understand what do you mean by REPEATABLE_READ. I was referring to transaction isolation levels.  When multiple transactions are running concurrently, the DBMS can (or

Re: [PERFORM] printing results of query to file in different times

Hi Mariel, Please don't top post in the Postgresql groups. On 9/5/2017 7:28 AM, Mariel Cherkassky wrote: 2017-08-31 16:24 GMT+03:00 George Neuner >: > >> One thing you might look at is the isolation level of the query. >> If you are using

Re: [PERFORM] printing results of query to file in different times

I'm using an extension that is called orafce. Yes I add the raise notice in order to see what happening but it doesnt work faster. The execution plan isnt relevant because It happens for many queries not for a specific one. I didnt understand what do you mean by REPEATABLE_READ . 2017-08-31 16:24

Re: [PERFORM] printing results of query to file in different times

On Thu, 24 Aug 2017 16:15:19 +0300, Mariel Cherkassky wrote: >I'm trying to understand what postgresql doing in an issue that I'm having. >Our app team wrote a function that runs with a cursor over the results of a >query and via the utl_file func they write

Re: [PERFORM] printing results of query to file in different times

Can you show explain with analyze and buffers options for your query? Regards, Roman Konoval rkono...@gmail.com > On Aug 24, 2017, at 15:15, Mariel Cherkassky > wrote: > > I'm trying to understand what postgresql doing in an issue that I'm having. > Our app

Re: [PERFORM] printing results of query to file in different times

Anyone? 2017-08-24 16:15 GMT+03:00 Mariel Cherkassky : > I'm trying to understand what postgresql doing in an issue that I'm > having. Our app team wrote a function that runs with a cursor over the > results of a query and via the utl_file func they write some

[PERFORM] printing results of query to file in different times

I'm trying to understand what postgresql doing in an issue that I'm having. Our app team wrote a function that runs with a cursor over the results of a query and via the utl_file func they write some columns to a file. I dont understand why, but postgresql write the data into the file in the fs in