Re: How to optimize monstrous query, sorts instead of - Mailing list pgsql-performance

From Rod Taylor
Subject Re: How to optimize monstrous query, sorts instead of
Date
Msg-id 1057235173.30368.32.camel@jester
Whole thread Raw
List pgsql-performance
> 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

pgsql-performance by date:

Previous
From: Paul Thomas
Date:
Subject: Re: raise or lower transaction timeout?
Next
From: Sean Chittenden
Date:
Subject: Moving postgresql.conf tunables into 2003...