Re: optimization downgrade perfomance? - Mailing list pgsql-performance

From Tom Lane
Subject Re: optimization downgrade perfomance?
Date
Msg-id 3192.1127482808@sss.pgh.pa.us
Whole thread Raw
In response to optimization downgrade perfomance?  (eVl <evl.evl@gmail.com>)
List pgsql-performance
eVl <evl.evl@gmail.com> writes:
>     When executing this SELECT (see SELECT.A above) it executes in about 700 ms, but when I want wipe out all info
aboutlocal traffic, with query like this: 
>       SELECT * FROM ( SELECT.A ) a WHERE type = 'global';
> It executes about 10000 ms - more then 10 TIMES SLOWER!

>  Why this could be?

You tell us --- let's see EXPLAIN ANALYZE results for both cases.

            regards, tom lane

pgsql-performance by date:

Previous
From: Joost Kraaijeveld
Date:
Subject: Re: How to determine cause of performance problem?
Next
From: Joost Kraaijeveld
Date:
Subject: Re: How to determine cause of performance problem?