Request a Demo
Home   >   mailing lists

Re: WAL + SSD = slow inserts? - Mailing list pgsql-performance

From Rosser Schwarz
Subject Re: WAL + SSD = slow inserts?
Date
Msg-id CAFnxYwhVLAQsL26kq+Uyo7qaQq=dNpc8xYyowZFTq4Gi_d9atg@mail.gmail.com
Whole thread Raw
In response to Re: WAL + SSD = slow inserts?  (Skarsol <skarsol@gmail.com>)
List pgsql-performance
Tree view
On Thu, Dec 5, 2013 at 9:55 PM, Skarsol <skarsol@gmail.com> wrote:
The rule is being used to return the id of the insert...

Take a look at the RETURNING clause of the INSERT statement. That should meet your needs here without having to bother with rules.

rls

--
:wq

pgsql-performance by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: One huge db vs many small dbs
Next
From: "Janek Sendrowski"
Date:
Subject: Similarity search with the tsearch2 extension