From: | Carmen Mardiros <bluecorr(at)gmail(dot)com> |
---|---|
To: | Imre Samu <pella(dot)samu(at)gmail(dot)com>, Carmen Mardiros <bluecorr(at)gmail(dot)com> |
Cc: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: How to tune Postgres to take advantage of 256GB RAM hardware |
Date: | 2016-11-24 15:31:26 |
Message-ID: | CAD1+EUrm3uaG_PL8R2X6L6wvo9-DGsqyMSxB2kFMK5CFoyV3oA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
It's PostgreSQL 9.5.4
On Thu, 24 Nov 2016 at 11:46 Imre Samu <pella(dot)samu(at)gmail(dot)com> wrote:
> > 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.
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2016-11-24 18:40:34 | Re: How to tune Postgres to take advantage of 256GB RAM hardware |
Previous Message | Imre Samu | 2016-11-24 11:46:32 | Re: How to tune Postgres to take advantage of 256GB RAM hardware |