Re: perfomance question/issues

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: perfomance question/issues
Дата
Msg-id 20021021170521.I77022-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на perfomance question/issues  ("Williams, Travis L, NPONS" <tlw@att.com>)
Список pgsql-general
On Mon, 21 Oct 2002, Williams, Travis L, NPONS wrote:

> How can you tell what the performance of you DB is?  I know a lot has
> to do with DB design..  I don't see postgres using a lot of memory or
> cpu on my system.. but everything seems a little slow for what I
> consider a small DB..
>
> What I have is 4 static columns that are indexed and roughly 460 that
> are updated.  Now I have only 215 rows.  If I update all of the
> columns then run vacuum analyze it takes 7-10 minutes.  I also have
> had trouble doing updates... I have tried doing them through perl and
> psql by doing a \i then the file name.. I have also tried using begin;
> and end; around the file.. but it still takes 1 minute+ to update one
> row.  any suggestions are welcome.

Are you using any foreign keys to/from this table that might be doing
checks on other tables?


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

Предыдущее
От: "Andrew Bartley"
Дата:
Сообщение: Re: ERROR: _mdfd_getrelnfd: cannot open relation pg_temp_15300_53: No such file or directory
Следующее
От: "Williams, Travis L, NPONS"
Дата:
Сообщение: Re: perfomance question/issues