On Wed, 23 Mar 2005 14:50:47 +0000, Richard Huxton <dev@archonet.com> wrote: > ON.KG wrote: > > Hi > > > > Does PostgreSQL have something like "INSERT DELAYD" - like it is used in > > MySQL? > > > > or any other way to delay inserting? > > What precisely does this do?
It adds an insert into a 'do this' queue and returns. From PostgreSQL-s point of view it would be equivalent of issuing INSERT and not waiting for the result. The MySQL has this mainly because when other statement such as SELECT or UPDATE is in progress, the INSERT would be blocked. 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... ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
