Re: INSERT performance tuning experiences

From: Robert Burgholzer <rburghol(at)vt(dot)edu>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: INSERT performance tuning experiences
Date: 2013-11-21 16:03:39
Message-ID: CACT-NGL=egYop8GFDyHmqbvJszP_x6b-0_6VhNLOp=Cf55HVog@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Thanks for the response Simon. This is a perfect application of that
function, I have a distributed environmental modeling system that generates
Gigs and Gigs of time series data, most of which is "write-once
read-seldom", and thus not worth the overhead of perpetual storage in the
database, or stored in a remote modeling node (also not worth network or
storage traffic for synching nodes). Similarly, since the tables all come
from text files, there is virtually no penalty to accepting the risk of pg
failure during table loading.

Thanks again,
/r/b

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Victor Tan 2013-11-21 16:29:25 Intel DC S3700/S3500 question
Previous Message Simon Riggs 2013-11-21 15:54:28 Re: INSERT performance tuning experiences