Hello,
lets say I have such theoretical situation: big database with a lot of
tables and fields, and a lot of users with are using different queries.
And the worse - I am that data base admin ;] which has to add or remove
indexes on table columns. As I dont know what queries are coming (users
are writing it by them self) I dont know which columns should have
indexes.
My question - is here any statistics Postgres can collect to help answer
my question. Basically I need most often "where" statements of queries
(also JOINs etc). Is here something what can help in such situation?
--
Lukas
www.nsoft.lt