On Wed, 23 Mar 2005 12:33:00 -0500, Tom Lane [EMAIL PROTECTED] wrote:
Dawid Kuroczko [EMAIL PROTECTED] 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...
Hi
Does PostgreSQL have something like INSERT DELAYD - like it is used in
MySQL?
or any other way to delay inserting?
Thanx
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining
On Wed, Mar 23, 2005 at 07:31:22PM +0300, ON.KG wrote:
Does PostgreSQL have something like INSERT DELAYD - like it is used in
MySQL?
or any other way to delay inserting?
What problem are you trying to solve? Are you aware that PostgreSQL
uses Multiversion Concurrency Control (MVCC) so
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?
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 3: if posting/reading
In article [EMAIL PROTECTED],
ON.KG [EMAIL PROTECTED] 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
On Wed, 23 Mar 2005 14:50:47 +, 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
Dawid Kuroczko wrote:
On Wed, 23 Mar 2005 14:50:47 +, Richard Huxton dev@archonet.com wrote:
ON.KG wrote:
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
Dawid Kuroczko [EMAIL PROTECTED] 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
Dawid Kuroczko [EMAIL PROTECTED] 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...
With the right client-side code you can transmit multiple queries before