Re: Questions on query planner, join types, and work_mem

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Greg Smith" <greg(at)2ndquadrant(dot)com>
Cc: "Hannu Krosing" <hannu(at)2ndquadrant(dot)com>, "Robert Haas" <robertmhaas(at)gmail(dot)com>, "Peter Hussey" <peter(at)labkey(dot)com>, "pgsql-performance" <pgsql-performance(at)postgresql(dot)org>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Questions on query planner, join types, and work_mem
Date: 2010-08-04 20:46:05
Message-ID: 4C598B3D0200002500034207@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Greg Smith <greg(at)2ndquadrant(dot)com> wrote:

> Was trying to demonstrate the general ability of pg_stat_bgwriter
> snapshots at points in time to directly measure the buffer
> activity Hannu was theorizing about, not necessarily show a useful
> benchmark of any sort with that.

Ah, OK. Sorry I didn't pick up on that; I was struggling to tease
out some particular effect you expected to see in the numbers from
that particular run. :-/

-Kevin

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Brad Nicholson 2010-08-05 12:40:37 Re: Testing Sandforce SSD
Previous Message Kevin Grittner 2010-08-04 20:42:49 Re: Questions on query planner, join types, and work_mem