Re: Improving PostgreSQL insert performance

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

Subject: Re: Improving PostgreSQL insert performance
From: Frits Jalvingh <jal@xxxxxx>
Date: Sat, 10 Jun 2017 11:12:43 +0000
Arc-authentication-results: i=1; mx.google.com; dkim=pass header.i=@etc-to.20150623.gappssmtp.com; spf=pass (google.com: best guess record for domain of pgsql-performance-owner+m55137=spinic=gmail.com@xxxxxxxxxxxxxx designates 2a02:16a8:dc51::56 as permitted sender) smtp.mailfrom=pgsql-performance-owner+M55137=spinic=gmail.com@xxxxxxxxxxxxxx
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:to:subject:message-id :date:from:in-reply-to:references:mime-version:dkim-signature :arc-authentication-results; bh=SgVvIbeJt2qukjIGEDebOZe3V8lgyy6jBhYD6pmF784=; b=wHvIcHzfniwEgKf9C1mLmdquOFkLNM0UFRoTiCPoE06kRsytDeDNV3mOyYx3QChCoF BNNLcPUW2YGt8KLBLXXVewxu56KQ1SHvy5vaC/UckwB5E5eYZpTS0ni4tYuqcjAMyXEz 7kxoW8dD41xuOhcdLb6Maqx+wPMeMU9QoieIt5mEv7Uw+6r0SoBCxzAyLtKPGeAgRFj3 RLVIu9ho6qhfr7aGA9bkLl/1cYj9oKl0321faTCbmA3veX9J6hl/LEva8tTCrmal+t6o ZEnGfkRYKsmu/oJLNHtwIetsJyTJ3cI20MANjVbsgbaH1yGSkvUSatNL+FbiIaDHhUaC NPrw==
Arc-seal: i=1; a=rsa-sha256; t=1497093230; cv=none; d=google.com; s=arc-20160816; b=LtwrdO35LpuTQm4x6Egp2fVJ8bW0qaNSryXTV8WlB3Q1sBf418tH0oLVzfzpVRnmtc 7E70+3F0BI/4GqbewqbbYLnSq6amDLaR64VNItAu6lr9OhYl6FpzYBtIpyFMhoUV6Z0T MS7tjDmL3ehD5vmCjCTEYhoiH99neopQ/p50GUqBs5x6CMz1i/Qzgg5EpwQKk/7TndzO kkT2mfAX1Yy/4wcROeOflwJ6gOomY6+1+KNPlzCMhw1KMOiHouchyqQgfSL/h0qNmF68 gUhrTkwmxhnmg7HHAiCfSfAL3EDmviME3UAxn8dZ65I+XXskq7ZI72S2EJqLDt4SiE0o 6E1w==
In-reply-to: <CAB=Je-Hh4ieW2Sv0HcAbaAnrf6xV_dK+OQ536ELNtY6619KF0A@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> <CAB=Je-Hh4ieW2Sv0HcAbaAnrf6xV_dK+OQ536ELNtY6619KF0A@mail.gmail.com>

On Sat, Jun 10, 2017 at 12:08 AM Vladimir Sitnikov <sitnikov.vladimir@xxxxxxxxx> wrote:

Would you mind sharing the source code of your benchmark?

The source code for the several tests, plus the numbers collected so far, can be found at:

https://etc.to/confluence/display/~admjal/PostgreSQL+performance+tests

Regards,

Frits

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
- Re: Improving PostgreSQL insert performance
  - From: Vladimir Sitnikov

Prev by Date: Re: Rollback table data.
Next by Date: Re: Improving PostgreSQL insert performance
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]