On Wed, Jan 25, 2012 at 08:42:05PM -0500, Robert Haas wrote:
> Only the first pass of vacuum knows how to mark pages all-visible.
> After the update, the first pass of the first vacuum sees a dead tuple
> on the old page and truncates it to a dead line pointer. When it
> comes to the new page, it
On Sat, Jan 21, 2012 at 9:50 PM, Jeff Janes wrote:
> A review:
>
> [ review ]
Thanks. Committed with hopefully-appropriate revisions.
> As a side-note, I noticed that I needed to run vacuum twice in a row
> to get the Heap Fetches to drop to zero. I vaguely recall that only
> one vacuum was ne
On Fri, Jan 13, 2012 at 7:21 AM, Robert Haas wrote:
> I think that people who are using index-only scans are going to want
> some way to find out the degree to which the scans are in fact
> index-only.
>
> So here's a 5-line patch that adds the number of heap fetches to the
> EXPLAIN ANALYZE outpu
Robert Haas writes:
> So here's a 5-line patch that adds the number of heap fetches to the
> EXPLAIN ANALYZE output. This might not be all the instrumentation
> we'll ever want here, but I think we at least want this much.
Cosmetic gripes:
1. Please initialize the counter in ExecInitIndexOnlySc
On Fri, Jan 13, 2012 at 10:41 AM, Peter Geoghegan wrote:
> On 13 January 2012 15:31, Robert Haas wrote:
>> On Fri, Jan 13, 2012 at 10:29 AM, Magnus Hagander
>> wrote:
>>> Would also be good to have counter sin pg_stat_* for this, since you'd
>>> usually want to look at this kind of data over ti
On 13 January 2012 15:31, Robert Haas wrote:
> On Fri, Jan 13, 2012 at 10:29 AM, Magnus Hagander wrote:
>> Would also be good to have counter sin pg_stat_* for this, since you'd
>> usually want to look at this kind of data over time as well. In your
>> plans? ;)
>
> Not really. I don't have a cl
On Fri, Jan 13, 2012 at 10:29 AM, Magnus Hagander wrote:
> On Fri, Jan 13, 2012 at 16:21, Robert Haas wrote:
>> I think that people who are using index-only scans are going to want
>> some way to find out the degree to which the scans are in fact
>> index-only.
>>
>> So here's a 5-line patch that
On 13 January 2012 15:21, Robert Haas wrote:
> I think that people who are using index-only scans are going to want
> some way to find out the degree to which the scans are in fact
> index-only.
>
> So here's a 5-line patch that adds the number of heap fetches to the
> EXPLAIN ANALYZE output. Thi
On Fri, Jan 13, 2012 at 16:21, Robert Haas wrote:
> I think that people who are using index-only scans are going to want
> some way to find out the degree to which the scans are in fact
> index-only.
>
> So here's a 5-line patch that adds the number of heap fetches to the
> EXPLAIN ANALYZE output.
I think that people who are using index-only scans are going to want
some way to find out the degree to which the scans are in fact
index-only.
So here's a 5-line patch that adds the number of heap fetches to the
EXPLAIN ANALYZE output. This might not be all the instrumentation
we'll ever want he
10 matches
Mail list logo
