Re: How to tune Postgres to take advantage of 256GB RAM hardware

> I am trying to configure Postgres (version 9.5)

This is the latest PG 9.5 ? ( = 9.5.5
<https://www.postgresql.org/docs/devel/static/release-9-5-5.html> ? [
Release Date : 2016-10-27 ] )

2016-11-24 9:17 GMT+01:00 Carmen Mardiros <bluecorr(at)gmail(dot)com>:

> Hi Andreas,
>
> Thanks for the reply. fsync is off because I don't care if the data gets
> corrupted in this environment if it means a performance gain, as it's only
> a minor inconvenience to restore from backups.
>
>
> Here is the query itself that pushes memory usage to 100%:
> http://pastebin.com/VzCAerwd . What's interesting is that if I execute
> this stand-alone, memory usage never exceeds 1.3% and query completes in 7
> minutes. But if I paste 2 other queries in the query window, followed by
> this one and execute them all at the same time, by the time postgres
> reaches the 3rd (this query), memory usage goes up to 100%. I don't
> understand why this is.
>
> And the EXPLAIN output: https://explain.depesz.com/s/hwH5 (have to admit
> I don't know how to read this!). Any help is greatly appreciated.
>
> On Thu, 24 Nov 2016 at 04:19 Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
> wrote:
>
>>
>>
>> Am 23. November 2016 23:15:25 MEZ, schrieb Carmen Mardiros <
>> bluecorr(at)gmail(dot)com>:
>> >
>> >various combinations)? How can I investigate what's limiting postgres
>> >from
>> >doing so?
>>
>> Why fsync=off?
>>
>> Please run the queries with EXPLAIN ANALYSE and show us the output.
>>
>> --
>> Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail
>> gesendet.
>>
>