Re: INSERT performance tuning experiences - Mailing list pgsql-admin

From Robert Burgholzer
Subject Re: INSERT performance tuning experiences
Date
Msg-id CACT-NGL=egYop8GFDyHmqbvJszP_x6b-0_6VhNLOp=Cf55HVog@mail.gmail.com
Whole thread Raw
In response to Re: INSERT performance tuning experiences  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: INSERT performance tuning experiences
List 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

pgsql-admin by date:

Previous
From: Victor Tan
Date:
Subject: Intel DC S3700/S3500 question
Next
From: Glyn Astill
Date:
Subject: Re: Intel DC S3700/S3500 question