From: | Strahinja Kustudić <strahinjak(at)nordeus(dot)com> |
---|---|
To: | Robert Burgholzer <rburghol(at)vt(dot)edu> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: INSERT performance tuning experiences |
Date: | 2013-11-22 21:35:05 |
Message-ID: | CADKbJJWvkeqjKrf-ZXWW2a21ckJzqihgEQKro3L6sxTuj3vPhg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Then all is good. You stunned me for a bit :)
Regards,
Strahinja
On Fri, Nov 22, 2013 at 10:29 PM, Robert Burgholzer <rburghol(at)vt(dot)edu> wrote:
> Sorry man, I miswrote - the default is ON, and I switched that to OFF -
> which yielded the performance improvements.. as you would expect. Simon
> must have just known what I meant when I said I changed the default.
>
> /r/b
>
>
> On Fri, Nov 22, 2013 at 3:28 PM, Strahinja Kustudić <
> strahinjak(at)nordeus(dot)com> wrote:
>
>> So you got better insert performance by turning on synchronous_commit?
>> How is that possible? Shouldn't synchronous_commit=off increase
>> performance? Is this only the case with 8.3?
>>
>> I tried inserting 10k rows in a table with more than 50 columns with and
>> without synchronous_commit and the results were (Postgres 9.1):
>>
>> off: 1.989s
>> on: 2.928s
>>
>> So off is 2 times faster.
>>
>> Regards,
>> Strahinja
>>
>>
>> On Thu, Nov 21, 2013 at 5:03 PM, Robert Burgholzer <rburghol(at)vt(dot)edu>wrote:
>>
>>> 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
>>>
>>
>>
>
>
> --
> --
> Robert W. Burgholzer
> 'Making the simple complicated is commonplace; making the complicated
> simple, awesomely simple, that's creativity.' - Charles Mingus
> Athletics: http://athleticalgorithm.wordpress.com/
> Science: http://robertwb.wordpress.com/
> Wine: http://reesvineyard.wordpress.com/
>
From | Date | Subject | |
---|---|---|---|
Next Message | Armand du Plessis | 2013-11-22 22:30:20 | Re: Partial Index Creation |
Previous Message | Joseph Mays | 2013-11-22 21:31:52 | pgpool-II |