> 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.
signature.asc
Description: This is a digitally signed message part