Re: Tweaking the planner's heuristics for small/empty tables - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Tweaking the planner's heuristics for small/empty tables
Date
Msg-id 201107131912.p6DJCD403395@momjian.us
Whole thread Raw
In response to Tweaking the planner's heuristics for small/empty tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Tweaking the planner's heuristics for small/empty tables
List 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@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Need help understanding pg_locks
Next
From: Bruce Momjian
Date:
Subject: Re: pg_class.relistemp