> 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 <bluec...@gmail.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 <andr...@a-kretschmer.de> > wrote: > >> >> >> Am 23. November 2016 23:15:25 MEZ, schrieb Carmen Mardiros < >> bluec...@gmail.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. >> >
