Re: a heavy duty operation on an "unused" table kills my server

Поиск
Список
Период
Сортировка
От Pierre Frédéric Caillaud
Тема Re: a heavy duty operation on an "unused" table kills my server
Дата
Msg-id op.u6i549rvcke6l8@soyouz
обсуждение исходный текст
Ответ на Re: a heavy duty operation on an "unused" table kills my server  (Eduardo Piombino <drakorg@gmail.com>)
Список pgsql-performance
> "high CPU usage" It might very well be "high IO usage".

    Try this :

    Copy (using explorer, the shell, whatever) a huge file.
    This will create load similar to ALTER TABLE.
    Measure throughput, how much is it ?

    If your server blows up just like it did on ALTER TABLE, you got a IO
system problem.
    If everything is smooth, you can look into other things.

    How's your fragmentation ? Did the disk ever get full ? What does the
task manager say (swap in/out, disk queue lengthn etc)

    PS : try a separate tablespace on another disk.

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

Предыдущее
От: Pierre Frédéric Caillaud
Дата:
Сообщение: Re: Inserting 8MB bytea: just 25% of disk perf used?
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: bad execution plan for subselects containing windowing-function