Sebastian Hennebrueder wrote:

I could not find any recommandations for the level of set statistics and
what a specific level does actually mean.
What is the difference between 1, 50 and 100? What is recommanded for a
table or column?

Default I believe is 10. The higher the number, the more statistics are kept, with a maximum of 1000.

The default is a little bit low for columns used in foreign keys, though
frequently it is okay.
When problems start, try setting them to 100 or 200. Higher is more
accurate, but takes longer to compute, *and* takes longer when planning
the optimal query method. It can be worth it, though.


Attachment: signature.asc
Description: OpenPGP digital signature

Reply via email to