Thread: Re: How to optimize monstrous query, sorts instead of

Re: How to optimize monstrous query, sorts instead of

From
Rod Taylor
Date:
> CREATE VIEW foo AS {complex_slow_query};
>
> SET random_page_cost = 1.5; EXPLAIN ANALYZE SELECT * FROM foo;
>
> Note the time taken. Repeat a few times to get the average.

You pulled everything off disk and tossed it into memory with the first
run so the results will NOT match your normal situation (some data on
disk, some cached in memory) for your second run and further runs unless
there is a LONG timeframe between runs.

That said, if you test with several other queries and get the same
results, it's probably good enough for your system.

Attachment