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 resu
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
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
tran
Dawid Kuroczko wrote:
On Wed, 23 Mar 2005 14:50:47 +, Richard Huxton 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 returns. From
On Wed, 23 Mar 2005 14:50:47 +, Richard Huxton 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 r
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
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 thr
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
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 column
