Stats

Поиск
Список
Период
Сортировка
От Lukas
Тема Stats
Дата
Msg-id 2d4195f7f284079940e386844b37c31a.squirrel@fmf.vtu.lt
обсуждение исходный текст
Список pgsql-performance
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


В списке pgsql-performance по дате отправления:

Предыдущее
От: Josh Kupershmidt
Дата:
Сообщение: Re: get/set priority of PostgreSQL backends
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Stats