| From: | Greg Stark <gsstark(at)mit(dot)edu> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Delay INSERT |
| Date: | 2005-03-23 17:02:35 |
| Message-ID: | 871xa670t0.fsf@stark.xeocode.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-php |
Dawid Kuroczko <qnex42(at)gmail(dot)com> writes:
> PostgreSQL doesn't have such issues with blocking, so only difference
> between INSERT and INSERT DELAYED from PostgreSQL's standpoint
> would be waiting and not for the result...
An insert can be blocked if there's a UNIQUE constraint and another
transaction has an insert or update pending for the same key. If the other
transaction commits you get a unique constraint violation, if it aborts your
insert succeeds.
--
greg
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Patnude | 2005-03-23 17:03:57 | Re: Table audit system |
| Previous Message | A. Mous | 2005-03-23 17:02:01 | Re: Simple query takes a long time on win2K |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-03-23 17:33:00 | Re: Delay INSERT |
| Previous Message | Richard Huxton | 2005-03-23 16:49:49 | Re: Delay INSERT |