Re: High cpu usage after many inserts
| От | Jordan Tomkinson |
|---|---|
| Тема | Re: High cpu usage after many inserts |
| Дата | |
| Msg-id | 6de2f13b0902232340o5364942ay558e10d671c067a@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: High cpu usage after many inserts (Greg Smith <gsmith@gregsmith.com>) |
| Ответы |
Re: High cpu usage after many inserts
Re: High cpu usage after many inserts |
| Список | pgsql-general |
On Tue, Feb 24, 2009 at 11:42 AM, Greg Smith <gsmith@gregsmith.com> wrote:
Right, the useful thing to do in this case is to take a look at how big all the relations (tables, indexes) involved are at each of the steps in the process. The script at http://wiki.postgresql.org/wiki/Disk_Usage will show you that. That will give some feedback on whether the vacuum/reindex methodology is really doing what you expect, and it will also let you compare the size of the table/index with how much RAM is in the system.
taken before the ~7000 rows were entered.
relation | size
-------------------------------+--------
public.mdl_log | 595 MB
public.mdl_forum_posts | 375 MB
public.mdl_log_coumodact_ix | 197 MB
public.mdl_user | 191 MB
public.mdl_cache_text | 162 MB
public.mdl_log_usecou_ix | 137 MB
public.mdl_log_act_ix | 119 MB
public.mdl_log_cmi_ix | 97 MB
public.mdl_log_tim_ix | 97 MB
public.mdl_log_id_pk | 97 MB
public.mdl_question_states | 48 MB
public.mdl_stats_user_daily | 48 MB
public.mdl_hotpot_responses | 47 MB
public.mdl_register_downloads | 45 MB
public.mdl_message_read | 37 MB
public.mdl_course_display | 37 MB
public.mdl_stats_user_weekly | 31 MB
public.mdl_mnet_log | 27 MB
public.mdl_user_ema_ix | 26 MB
public.mdl_regidown_url_ix | 23 MB
(20 rows)
В списке pgsql-general по дате отправления: