Re: plain inserts and deletes very slow

Поиск
Список
Период
Сортировка
От Enrico Weigelt
Тема Re: plain inserts and deletes very slow
Дата
Msg-id 20050708134638.GA6368@nibiru.borg.metux.de
обсуждение исходный текст
Ответ на Re: plain inserts and deletes very slow  (Klint Gore <kg@kgb.une.edu.au>)
Список pgsql-performance
* Klint Gore <kg@kgb.une.edu.au> wrote:

<snip>

> Turn on statement logging.  I've seen delphi interfaces do extra queries
> on system tables to find some structure information.

I'm already using statement logging of all queries taking longer
than 200ms. It seems that only the INSERT takes such a time.

The client is in fact written in delphi, and it sometimes seems
to do strange things. For example we had the effect, that some
new fields in some table were regularily NULL'ed. None of the
triggers and rules inside the DB could do that (since there's
no dynamic query stuff) and the delphi application is the only
one writing directly to this table.


cu
--
---------------------------------------------------------------------
 Enrico Weigelt    ==   metux IT service
  phone:     +49 36207 519931         www:       http://www.metux.de/
  fax:       +49 36207 519932         email:     contact@metux.de
---------------------------------------------------------------------
  Realtime Forex/Stock Exchange trading powered by postgresSQL :))
                                            http://www.fxignal.net/
---------------------------------------------------------------------

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

Предыдущее
От: Rod Taylor
Дата:
Сообщение: Re: Mount database on RAM disk?
Следующее
От: Enrico Weigelt
Дата:
Сообщение: Re: Select performance vs. mssql