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

From Tom Lane
Subject Re: Tweaking the planner's heuristics for small/empty tables
Date
Msg-id 10706.1310591765@sss.pgh.pa.us
Whole thread Raw
In response to Re: Tweaking the planner's heuristics for small/empty tables  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes:
> 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.

I considered whether to do things differently depending on the table's
temp status, but it's not clear what we could do better from knowing that.
If it's temp, it's more likely not less likely that we need some sort of
hack because vacuum/analyze won't come along to help.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [BUGS] extract(epoch from infinity) is not 0
Next
From: Brendan Jurd
Date:
Subject: Re: [BUGS] extract(epoch from infinity) is not 0