"sl...@centrum.sk" <sl...@centrum.sk> wrote: > I have a recursive CTE where a table scan occurs, even though > there doesn't seem to be a good reason for it.
Do you have effective_cache_size set to 50% to 75% of machine RAM? Do you have cpu_tuple_cost set to between 0.03 and 0.05? If not, do changes to these settings help? -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
