performance tuning

Поиск
Список
Период
Сортировка
От Sheer El-Showk
Тема performance tuning
Дата
Msg-id Pine.LNX.4.33.0110271355490.420-100000@laudanum.saraf.com
обсуждение исходный текст
Список pgsql-sql
Does anyone have a good reference for Postgres performance tuning.  The
first thing I'm looking for is a way to determine my bottle-neck.  My
system is currently running with 5-6 processes in the runqueue and 100%
cpu utilization (50% in the kernel).  I'm guessing I'm cpu-bound but I'd
like to find out why (I'm doing mostly inserts, but I have a lot of
foreign keys).  I know postgres has a lot of pg_stat_* tables but I'd like
to learn how to use these and other performance analysis tools.

Thanks,
Sheer


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

Предыдущее
От: "stephen"
Дата:
Сообщение: delete queires
Следующее
От: "Valdir H. Dias Leite"
Дата:
Сообщение: SQL99