Re: Improving PostgreSQL insert performance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Improving PostgreSQL insert performance
From: Vladimir Sitnikov <sitnikov.vladimir@xxxxxxxxx>
Date: Fri, 09 Jun 2017 22:08:34 +0000
Arc-authentication-results: i=1; mx.google.com; dkim=pass header.i=@gmail.com; spf=pass (google.com: best guess record for domain of pgsql-performance-owner+m55134=spinic=gmail.com@xxxxxxxxxxxxxx designates 2a02:16a8:dc51::56 as permitted sender) smtp.mailfrom=pgsql-performance-owner+M55134=spinic=gmail.com@xxxxxxxxxxxxxx; dmarc=pass (p=NONE sp=NONE dis=NONE) header.from=gmail.com
Arc-message-signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20160816; h=sender:precedence:list-unsubscribe:list-subscribe:list-post :list-owner:list-id:list-help:list-archive:cc:to:subject:message-id :date:from:in-reply-to:references:mime-version:dkim-signature :arc-authentication-results; bh=CF+GJLkBUwI8IAIVrxSvDTmaI3+1lzyLKTCcqMm2R5w=; b=z860nbfJiSuSrDKErWg9gah9Rse7pGXW5rJ20V5h8EvRxnEm3ckuKyloBB3tg7QymY Vo+SI2kwaeyGC1enaojnpt+6wYc5+J7HGQwjCpRXY1iNEGRFssmyCEIHzvznI4YLurXP o0XRKsM9w7I1ZswzKJQP9mG0zDZIOmkCQ6CvfrRFfPd0baP/JtEK0o817GR6siA67vsS e960r5jplnlE3aUMI7lwV5Rt/en5cSGot01CE//1OxsvXHJKMUwz6wAyXJ5IkyGoYAOI Z1ge0eqE+eTzoRy89Qm1bkm680TPWe1FyPyv1fnxD1fm7xY2Y6Y0pew46oNaEnjat1ZH 1oLQ==
Arc-seal: i=1; a=rsa-sha256; t=1497046168; cv=none; d=google.com; s=arc-20160816; b=YmBH34/6AD5o5bYvbBEMtgFLvQFVCgD3Krb/5O1WbFqixaaZDOa23aWurLsuIbxIr0 FqPyCVVLt4m+IccGjBRXNN4irlC8lMKIpIMAi+cJDNdcZOSzmW3wUBjud40zaz/2dKLJ F/h6BGLt7ITvTX3Vv1Bu6qEKY3FeodL+0uQ2g6KgXJ4Iq4R7ov8eihPJNAcGC8tSPE1y EvkWT8NFqJ+oBP7ip6hPHoQDQff0YDBQfRSbdD8PqDQ9DDJ5IINlocAWbKzJuRUfsWWl zRTOjvTrHcbNP5sSWYi7+bgEHsGNPZU3zoKVNZMmksCbnJOPeeaATEaXy6l8tsrOKn2h x+mw==
Cc: "Chellappa, Babu" <Babu_Chellappa@xxxxxxxxxxxx>, "pgsql-performance@xxxxxxxxxxxxxx" <pgsql-performance@xxxxxxxxxxxxxx>, Kenneth Marshall <ktm@xxxxxxxx>
In-reply-to: <CAKhTGFUi7DsN7Y4ECLA5o0CepwkWjPh-pdOhfFbE36h2dL+e9g@mail.gmail.com>
References: <20170609132857.GC26506@aart.rice.edu> <CAKhTGFVTvFxsfngDNgQV-ciWYFn6aXROwGj6s4Gqkqa0bTusJw@mail.gmail.com> <CAOR=d=1CYLvtesjcCmC95rWZSzJ02pYZyfJ8SA9jfx-CCekx3A@mail.gmail.com> <CAKhTGFXiU_t_EiB37q-H897pFqQY9a=hDAuAZV7T3dLMTsvSiw@mail.gmail.com> <CA+wvBw0P92PF95hewt5OWc_9oQByJTwEynV=Lv2MdguB2o-kFQ@mail.gmail.com> <CAKhTGFVBu3Zrsp6oRSpTEgWvnie4Wbx++P6=WTfZOWptLOKj+Q@mail.gmail.com> <4CC4AADC-59DB-4B3D-8A07-4A110E97D5A5@unigroup.com> <CAKhTGFW2xJ9cmRSge3rMpVzBK73_oWSPWQrqF-TYeCtuTKGXjA@mail.gmail.com> <9840E469-1D75-4BF2-AA4D-CE8FB21E0FCC@unigroup.com> <CAKhTGFVoxFfh+5+ZkEb3s_ynb2HnTRzaOBPvK1Tpy0+7GfM2BQ@mail.gmail.com> <20170609153333.GF26506@aart.rice.edu> <CAKhTGFUi7DsN7Y4ECLA5o0CepwkWjPh-pdOhfFbE36h2dL+e9g@mail.gmail.com>

Frits,

Would you mind sharing the source code of your benchmark?

>BTW: It seems you need a recent driver for this; I'm using postgresql-42.1.1.jar

Technically speaking, reWriteBatchedInserts was introduced in 9.4.1209 (2016-07-15)

Vladimir

Follow-Ups:
- Re: Improving PostgreSQL insert performance
  - From: Frits Jalvingh

References:
- Re: Improving PostgreSQL insert performance
  - From: Kenneth Marshall
- Re: Improving PostgreSQL insert performance
  - From: Frits Jalvingh
- Re: Improving PostgreSQL insert performance
  - From: Scott Marlowe
- Re: Improving PostgreSQL insert performance
  - From: Frits Jalvingh
- Re: Improving PostgreSQL insert performance
  - From: Sunkara, Amrutha
- Re: Improving PostgreSQL insert performance
  - From: Frits Jalvingh
- Re: Improving PostgreSQL insert performance
  - From: Frits Jalvingh
- Re: Improving PostgreSQL insert performance
  - From: Frits Jalvingh
- Re: Improving PostgreSQL insert performance
  - From: Kenneth Marshall
- Re: Improving PostgreSQL insert performance
  - From: Frits Jalvingh

Prev by Date: Re: Improving PostgreSQL insert performance
Next by Date: Re: [BUGS] Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64
Previous by thread: Re: Improving PostgreSQL insert performance
Next by thread: Re: Improving PostgreSQL insert performance
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]