Poll about auto-index stats update in FB
Dear users,
I work at a project related to a possibility to have the index statistics auto-updated and humbly I ask your opinion. Please feel free to vote below.
TIA,
m. Th.
(No Ratings Yet)
Loading...3 comments
Leave a Reply
You must be logged in to post a comment.
I doubt this poll has much of the practical value, as it doesn’t mention what statistics should be updated and under what conditions (i.e. how often).
What statistics:
1. Selectivity of changed indexes, of course. (or perhaps, blindly update all the indexes, I don’t think so…)
2. Do you want to add as possible choices some other (unimplemented) statistics? Or perhaps I didn’t understand this part correctly…
What conditions:
Perhaps is better to make a new poll (I will do it for you) to have:
1. After a specified amount of changes – no matter how big is the load
2. On a low load + after a specified amount of changes.
3. On a low load – no matter how many changes were made
3. On a daily basis (every Th day)
4. On weekly/monthly basis (every th week)
Something like this?
What’s your opinion?
hth,
m. th.
This will be like PostgreSQL’s autovacuum feature.
Good, but not something to cry for.
I’d rather see an internal scheduler implemented, something like Oracle’s DBMS_JOB or MySQL’s one (on 5.1) which could be used for a ton of tasks (managed in the database and through SQL, I’m aware of cron) including stats update.