agora inbox for pgsql-performance@postgresql.org  

help / color / mirror / Atom feed

From: Kenneth Marshall <ktm@rice.edu>
To: Frits Jalvingh <jal@etc.to>
Cc: Andreas Kretschmer <andreas@a-kretschmer.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: Improving PostgreSQL insert performance
Date: Fri, 9 Jun 2017 09:36:37 -0500
Message-ID: <20170609143637.GD26506@aart.rice.edu> (raw)
In-Reply-To: <CAKhTGFVTvFxsfngDNgQV-ciWYFn6aXROwGj6s4Gqkqa0bTusJw@mail.gmail.com>
References: <CAKhTGFX-ChBSjqENrAv8uqUR_H5PTvf14jG0cOAq6c-ami_7sQ@mail.gmail.com>
	<9e2a0a34-dd83-43af-d41a-791b34ff76e1@a-kretschmer.de>
	<20170609132857.GC26506@aart.rice.edu>
	<CAKhTGFVTvFxsfngDNgQV-ciWYFn6aXROwGj6s4Gqkqa0bTusJw@mail.gmail.com>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>

On Fri, Jun 09, 2017 at 01:56:58PM +0000, Frits Jalvingh wrote:
> Hi Kenneth, Andreas,
> 
> Thanks for your tips!
> 
> I increased shared_buffers to 8GB but it has no measurable effect at all. I
> think that is logical: shared buffers are important for querying but not
> for inserting; for that the speed to write to disk seems most important- no
> big reason to cache the data if the commit requires a full write anyway.
> I also changed the code to do only one commit; this also has no effect I
> can see.
> 
> It is true that Oracle had more memory assigned to it (1.5G), but unlike
> Postgres (which is completely on a fast SSD) Oracle runs on slower disk
> (ZFS)..
> 
> I will try copy, but I first need to investigate how to use it- its
> interface seems odd to say the least ;) I'll report back on that once done.
> 
> Any other tips would be welcome!
> 
> Regards,
> 
> Frits

Hi Frits,

Here is an article that is still valid:

https://www.depesz.com/2007/07/05/how-to-insert-data-to-database-as-fast-as-possible/

Regards,
Ken


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

view thread (29+ messages)  latest in thread

Message-ID: <20170609143637.GD26506@aart.rice.edu>
Permalink:  ../20170609143637.GD26506@aart.rice.edu/
Also on:    postgresql.org/message-id/20170609143637.GD26506@aart.rice.edu

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: ktm@rice.edu, jal@etc.to, andreas@a-kretschmer.de
  Subject: Re: Improving PostgreSQL insert performance
  In-Reply-To: <20170609143637.GD26506@aart.rice.edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox