From: Chris Travers
Sent: Tuesday, September 12, 2017 3:36 PM
To: Frank Millman
Cc: Postgres General
Subject: Re: [GENERAL] Joining 16 tables seems slow
Chris Travers wrote:
On Tue, Sep 12, 2017 at 3:15 PM, Frank Millman <fr...@chagford.com> wrote:
2017-09-12 12:39 GMT+02:00
2017-09-12 14:01 GMT+02:00 Tom Lane :
> "Frank Millman" writes:
> > Pavel Stehule wrote:
> >> 2017-09-12 8:45 GMT+02:00 Frank Millman :
> >>> I am experimenting with optimising a SQL statement. One version uses
> 4 LEFT JOIN’s and a
On Tue, Sep 12, 2017 at 3:15 PM, Frank Millman wrote:
>
> 2017-09-12 12:39 GMT+02:00 Pavel Stehule :
>
>>
>>
>> 2017-09-12 12:25 GMT+02:00 Frank Millman :
>>
>>> Pavel Stehule wrote:
>>>
>>> 2017-09-12 9:36 GMT+02:00 Frank Millman
2017-09-12 12:39 GMT+02:00 Pavel Stehule :
2017-09-12 12:25 GMT+02:00 Frank Millman :
Pavel Stehule wrote:
2017-09-12 9:36 GMT+02:00 Frank Millman :
Pavel Stehule wrote:
>
> 2017-09-12 8:45
"Frank Millman" writes:
> Pavel Stehule wrote:
>> 2017-09-12 8:45 GMT+02:00 Frank Millman :
>>> I am experimenting with optimising a SQL statement. One version uses 4
>>> LEFT JOIN’s and a 5-way CASE statement in the body. The second moves the
>>>
2017-09-12 12:39 GMT+02:00 Pavel Stehule :
>
>
> 2017-09-12 12:25 GMT+02:00 Frank Millman :
>
>> Pavel Stehule wrote:
>>
>> 2017-09-12 9:36 GMT+02:00 Frank Millman :
>>
>>> Pavel Stehule wrote:
>>> >
>>> > 2017-09-12 8:45 GMT+02:00
2017-09-12 12:25 GMT+02:00 Frank Millman :
> Pavel Stehule wrote:
>
> 2017-09-12 9:36 GMT+02:00 Frank Millman :
>
>> Pavel Stehule wrote:
>> >
>> > 2017-09-12 8:45 GMT+02:00 Frank Millman :
>>
>>> I am using 9.4.4 on Fedora 22.
>>>
>>> I
Pavel Stehule wrote:
2017-09-12 9:36 GMT+02:00 Frank Millman :
Pavel Stehule wrote:
>
> 2017-09-12 8:45 GMT+02:00 Frank Millman :
I am using 9.4.4 on Fedora 22.
I am experimenting with optimising a SQL statement. One version uses 4 LEFT
2017-09-12 9:36 GMT+02:00 Frank Millman :
> Pavel Stehule wrote:
> >
> > 2017-09-12 8:45 GMT+02:00 Frank Millman :
>
>> I am using 9.4.4 on Fedora 22.
>>
>> I am experimenting with optimising a SQL statement. One version uses 4
>> LEFT JOIN’s and a 5-way
Ron Johnson wrote:
>
On 09/12/2017 01:45 AM, Frank Millman wrote:
Hi all
I am using 9.4.4 on Fedora 22.
I am experimenting with optimising a SQL statement. One version uses 4 LEFT
JOIN’s and a 5-way CASE statement in the body. The second moves the filtering
into the JOIN section, and I end
Pavel Stehule wrote:
>
> 2017-09-12 8:45 GMT+02:00 Frank Millman :
I am using 9.4.4 on Fedora 22.
I am experimenting with optimising a SQL statement. One version uses 4 LEFT
JOIN’s and a 5-way CASE statement in the body. The second moves the filtering
into the JOIN
On 09/12/2017 01:45 AM, Frank Millman wrote:
Hi all
I am using 9.4.4 on Fedora 22.
I am experimenting with optimising a SQL statement. One version uses 4
LEFT JOIN’s and a 5-way CASE statement in the body. The second moves the
filtering into the JOIN section, and I end up with 16 LEFT JOIN’s
hi
2017-09-12 8:45 GMT+02:00 Frank Millman :
> Hi all
>
> I am using 9.4.4 on Fedora 22.
>
> I am experimenting with optimising a SQL statement. One version uses 4
> LEFT JOIN’s and a 5-way CASE statement in the body. The second moves the
> filtering into the JOIN section,
Hi all
I am using 9.4.4 on Fedora 22.
I am experimenting with optimising a SQL statement. One version uses 4 LEFT
JOIN’s and a 5-way CASE statement in the body. The second moves the filtering
into the JOIN section, and I end up with 16 LEFT JOIN’s and no CASE statements.
My test involves
14 matches
Mail list logo