From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc:
Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com>,
Stuart Brooks <stuartb(at)cat(dot)co(dot)za>, pgsql-general(at)postgresql(dot)org,
PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: [HACKERS] ANALYZE getting dead tuple count hopelessly wrong
Date:
2008-04-01 15:00:15
Message-ID:
2320.1207062015@sss.pgh.pa.us (view raw or flat )
Thread:
2008-03-31 08:03:23 from Stuart Brooks <stuartb(at)cat(dot)co(dot)za>
2008-03-31 12:34:26 from "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com>
2008-03-31 15:32:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-03-31 18:34:25 from "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com>
2008-03-31 19:52:46 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-04-01 07:37:20 from "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com>
2008-04-01 08:04:21 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-04-01 14:22:03 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-04-01 14:46:15 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-04-01 15:00:15 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-04-01 19:18:18 from Gregory Stark <stark(at)enterprisedb(dot)com>
2008-04-01 13:00:31 from Stuart Brooks <stuartb(at)cat(dot)co(dot)za>
2008-04-02 20:29:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-04-02 23:04:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-04-03 16:12:48 from "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com>
2008-04-03 16:32:28 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-04-03 16:51:24 from "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com>
2008-04-03 17:09:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-04-04 04:31:31 from "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com>
2008-04-04 05:40:35 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-04-04 05:48:59 from "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com>
2008-04-07 08:04:51 from Stuart Brooks <stuartb(at)cat(dot)co(dot)za>
Lists:
pgsql-general pgsql-hackers
Simon Riggs <simon(at)2ndquadrant(dot)com> writes:
> On Tue, 2008-04-01 at 10:22 -0400, Tom Lane wrote:
>> In the fourth, if we actually believed this was a problem we'd
>> need to redesign VACUUM too, as it does the same thing.
> VACUUM waits until nobody else has the buffer pinned, so lock contention
> is much less of a consideration there. Plus it rearranges the block,
> which is hard to do one tuple at a time even if we wanted to.
That's the second scan. The first scan acts exactly like Pavan is
proposing for ANALYZE.
regards, tom lane
In response to
pgsql-hackers by date
Next :From: Mathias HasselmannDate: 2008-04-01 15:07:31Subject : Re: [HACKERS] Avahi support for PostgresqlPrevious :From : Tom LaneDate : 2008-04-01 14:52:41Subject : Re: Scroll cursor oddity...
pgsql-general by date
Next :From: Pettis, BarryDate: 2008-04-01 15:12:54Subject : Re: Using tables in other PostGreSQL databasePrevious :From : Ivan Sergio BorgonovoDate : 2008-04-01 14:54:12Subject : optimiser STABLE vs. temp table was: HOWTO caching data across
function calls: temporary tables, cursor?
