Postgres Pro
Downloads
Home   >   mailing lists

Re: INSERT OU UPDATE WITHOUT SELECT? - Mailing list pgsql-performance

From PFC
Subject Re: INSERT OU UPDATE WITHOUT SELECT?
Date
Msg-id op.tadyc1jwcigqcu@apollo13
Whole thread Raw
In response to Re: INSERT OU UPDATE WITHOUT SELECT?  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Responses Re: INSERT OU UPDATE WITHOUT SELECT?
Re: INSERT OU UPDATE WITHOUT SELECT?
List pgsql-performance
Tree view 
> PostgreSQL does not support MERGE at the moment, sorry.

    Issue an UPDATE, and watch the rowcount ; if the rowcount is 0, issue an
INSERT.
    Be prepared to retry if another transaction has inserted the row
meanwhile, though.

    MERGE would be really useful.

pgsql-performance by date:

Previous
From: "Daniel J. Luke"
Date:
Subject: Re: Getting even more insert performance (250m+rows/day)
Next
From: PFC
Date:
Subject: Re: Optimizing a huge_table/tiny_table join