On Wednesday 05 November 2008, "Andrus" <kobruleht2@xxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
