Re: [SQL] Don't need transaction integrity - can I turn it off

Поиск
Список
Период
Сортировка
От Michael Richards
Тема Re: [SQL] Don't need transaction integrity - can I turn it off
Дата
Msg-id Pine.BSF.4.10.9908271853050.29442-100000@scifair.acadiau.ca
обсуждение исходный текст
Ответ на Don't need transaction integrity - can I turn it off  ("Hamid Khoshnevis" <hamid@emarq.com>)
Список pgsql-sql
On Thu, 26 Aug 1999, Hamid Khoshnevis wrote:

> My application requires very fast update/insert- where I am told mySQL
> shines.  Can I turn off commit/rollback in Postgres so as to dramatically
> speed up insert/updates.  I understand and accept the cost of dropping some
> insert/updates.

Personally, I'd set it all up and give it a whirl first. Often I've found
that these things work better than I expected and don't need to be fiddled
with to get expected speeds.

-Michael



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

Предыдущее
От: Michael Richards
Дата:
Сообщение: RE: [SQL] 2 million+ entries
Следующее
От: Michael Richards
Дата:
Сообщение: indexes using datetime