| From: | Craig Ringer <craig(at)2ndquadrant(dot)com> |
|---|---|
| To: | Gary M <garym(at)oedata(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Is there a cache consistent interface to tables ? |
| Date: | 2018-02-11 12:11:19 |
| Message-ID: | CAMsr+YEwf2RYK4Dd7LuiW6YHTfcpPcdE9eJ2Qw7k3PD6_JzCrQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 11 February 2018 at 04:44, Gary M <garym(at)oedata(dot)com> wrote:
> Thanks Craig,
>
> As I'm back in pg code after many years, I'm feeling much better there's
> one (1) or two (2) items causing the hiccup. Rereading your comments, I'm
> agreeing with you. I'm considering bumping up the ram to 512gb as a RAM
> disk just for consistent profiling (an old bad habit).
>
> I'm reassessing my profiling plan. I'm getting ahead of myself thinking
> the OS is not having a significant effect.
>
Definitely. Especially since PostgreSQL uses buffered I/O.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nikolay Shaplov | 2018-02-11 13:51:49 | Re: [PATCH][PROPOSAL] Add enum releation option type |
| Previous Message | Etsuro Fujita | 2018-02-11 07:45:10 | Re: postgres_fdw: perform UPDATE/DELETE .. RETURNING on a join directly |