Re: Constraint Error effect on PostgreSQL
От
Richard Huxton
Тема
Re: Constraint Error effect on PostgreSQL
Дата
Msg-id
4415AE4E.9000402@archonet.com
Ответ на
Constraint Error effect on PostgreSQL (Christian Paul B. Cosinas)
Список
Дерево обсуждения
Re: REINDEX DATABASE Christopher Browne <cbbrowne@acm.org>
Re: REINDEX DATABASE Achilleus Mantzios <achill@matrix.gatewaynet.com>
Christian Paul B. Cosinas wrote:
>
> Then I have a program that insert 1(one) million times like this:
> Insert into unique_items(item_id) values('Item001)
>
> Ofcourse we all know that it will fail because there is already a record in
> the database.
>
> Would there be any bad effect on the database or none?
No long-term effects. Obviously it takes time to run one million queries
even if they are all inserts that fail.
-- Richard Huxton Archonet Ltd
В списке pgsql-sql по дате отправления
