Re: WAL + SSD = slow inserts?

From: Rosser Schwarz <rosser(dot)schwarz(at)gmail(dot)com>
To: Skarsol <skarsol(at)gmail(dot)com>
Cc: bricklen <bricklen(at)gmail(dot)com>, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: WAL + SSD = slow inserts?
Date: 2013-12-06 06:03:44
Message-ID: CAFnxYwhVLAQsL26kq+Uyo7qaQq=dNpc8xYyowZFTq4Gi_d9atg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Dec 5, 2013 at 9:55 PM, Skarsol <skarsol(at)gmail(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Janek Sendrowski 2013-12-06 14:30:57 Similarity search with the tsearch2 extension
Previous Message Pavel Stehule 2013-12-06 05:58:36 Re: One huge db vs many small dbs