Re: Speeding up query

On Wednesday 05 November 2008, "Andrus" <kobruleht2(at)hot(dot)ee> wrote:
> takes 34 seconds. Tables are indexed and logfile shows autovacuum
> running. I ran VACUUM ANALYZE.
> It returns
>
> INFO: free space map contains 22501 pages in 77 relations
> DETAIL: A total of 20000 page slots are in use (including overhead).
> 111216 page slots are required to track all free space.
> Current limits are: 20000 page slots, 1000 relations, using 186 KB.
> NOTICE: number of page slots needed (111216) exceeds max_fsm_pages
> (20000) HINT: Consider increasing the configuration parameter
> "max_fsm_pages" to a value over 111216.
> Query returned successfully with no result in 201099 ms.
>
> How to speed up this query ?
>
> Should I set max_fsm_pages to a 113000 or other suggestions ?

Undoubtedly (higher), to prevent table bloat, but you'll also need to post
your table structures and an explain analyze for help speeding this
particular query.

--
Alan