Re: Tweaking the planner's heuristics for small/empty tables

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Tweaking the planner's heuristics for small/empty tables
Date: 2011-07-13 19:12:12
Message-ID: 201107131912.p6DJCD403395@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
> Another reason not to rely completely on the auto-analyze update path is
> that it doesn't work for temp tables, since autovac can't access another
> session's temp tables. It's also worth noting that auto-analyze will
> never kick in at all for tables of less than about 60 rows, unless there
> is update/delete traffic on them.

We could exclude temp tables in the 'if' test.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2011-07-13 19:14:51 Re: pg_class.relistemp
Previous Message Bruce Momjian 2011-07-13 19:08:37 Re: Need help understanding pg_locks