[PERFORM] latest perf tuning info

Many years ago, I considered myself fairly expert when it came to performance tuning and query optimization in postgresql, but I've been hiding out inside (insert big company that doesn't use Postgresql here) for a long while while postgresql has continued to evolve, and much has changed since

Re: [PERFORM] performance problem on big tables

On Thu, Aug 24, 2017 at 4:51 AM, Mariel Cherkassky wrote: > Hi Claudio, how can I do that ? Can you explain me what is this option ? > > 2017-08-24 2:15 GMT+03:00 Claudio Freire : >> >> On Mon, Aug 21, 2017 at 5:00 AM, Mariel Cherkassky >>

[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

Re: [PERFORM] performance problem on big tables

Hi Claudio, how can I do that ? Can you explain me what is this option ? 2017-08-24 2:15 GMT+03:00 Claudio Freire : > On Mon, Aug 21, 2017 at 5:00 AM, Mariel Cherkassky > wrote: > > To summarize, I still have performance problems. My current