Hello,
Would I request to help me on this query.
SELECT 'Inspection Completed' as "ALL Status" ,COUNT(*) as "Number of Count"
FROM ud_document WHERE status = 'Inspection Completed' union SELECT 'Pending',
COUNT(*) FROM ud_document WHERE status = 'Pending' union SELECT 'Approved',
COUNT(*) FROM
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 Greg
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
>> wrote:
>> > To summarize, I still have performance proble
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
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 situation :
> >
> > I'm trying to copy the data of man
