eVl <[EMAIL PROTECTED]> writes: > When executing this SELECT (see SELECT.A above) it executes in about > 700 ms, but when I want wipe out all info about local 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend