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

2017-08-31 Thread George Neuner
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 some columns to a file. I dont >u

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

2017-08-31 Thread Roman Konoval
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 team wrote a function that runs w

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

2017-08-31 Thread Mariel Cherkassky
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 columns to a > file. I dont understa