Re: Delay INSERT

Поиск
Список
Период
Сортировка
От Harald Fuchs
Тема Re: Delay INSERT
Дата
Msg-id pu8y4e2wgh.fsf@srv.protecting.net
обсуждение исходный текст
Ответ на Delay INSERT  ("ON.KG" <skyer@on.kg>)
Список pgsql-general
In article <14435275218.20050323193122@on.kg>,
"ON.KG" <skyer@on.kg> writes:

> Hi
> Does PostgreSQL have something like "INSERT DELAYD" - like it is used in
> MySQL?

> or any other way to delay inserting?

Every INSERT in PostgreSQL is delayed in some sense: firstly, it is
not visible to anyone else until you commit, and secondly, it is
written first to the (supposedly fast) write-ahead log and only later
to the table files.

If you have problems with INSERT speed, describe hardware,
configuration, and table structure.

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

Предыдущее
От: Edson Vilhena de Carvalho
Дата:
Сообщение: backend process
Следующее
От: "A. Mous"
Дата:
Сообщение: Re: Simple query takes a long time on win2K