Re: [HACKERS] planstats.sgml

2016-02-16 Thread Mark Kirkwood
On 16/02/16 20:01, Tatsuo Ishii wrote: Tatsuo Ishii writes: While reading planstats.sgml, I encounted a sentence which I don't understand. These numbers are current as of the last VACUUM or ANALYZE on the table. The planner then fetches the actual

Re: [HACKERS] planstats.sgml

2016-02-15 Thread Tatsuo Ishii
>> Tatsuo Ishii writes: >>> While reading planstats.sgml, I encounted a sentence which I don't >>> understand. >> >>> These numbers are current as of the last VACUUM or >>> ANALYZE on the table. The planner then fetches the >>> actual current number of pages in

Re: [HACKERS] planstats.sgml

2016-02-15 Thread Mark Kirkwood
On 16/02/16 12:46, David G. Johnston wrote: On Mon, Feb 15, 2016 at 4:23 PM, Tatsuo Ishii >wrote: While reading planstats.sgml, I encounted a sentence which I don't understand. These numbers are current as of the last VACUUM

Re: [HACKERS] planstats.sgml

2016-02-15 Thread Tatsuo Ishii
> Tatsuo Ishii writes: >> While reading planstats.sgml, I encounted a sentence which I don't >> understand. > >> These numbers are current as of the last VACUUM or >> ANALYZE on the table. The planner then fetches the >> actual current number of pages in the

Re: [HACKERS] planstats.sgml

2016-02-15 Thread Tom Lane
Tatsuo Ishii writes: > While reading planstats.sgml, I encounted a sentence which I don't > understand. > These numbers are current as of the last VACUUM or > ANALYZE on the table. The planner then fetches the > actual current number of pages in the table (this

Re: [HACKERS] planstats.sgml

2016-02-15 Thread David G. Johnston
On Mon, Feb 15, 2016 at 4:23 PM, Tatsuo Ishii wrote: > While reading planstats.sgml, I encounted a sentence which I don't > understand. > > These numbers are current as of the last VACUUM or > ANALYZE on the table. The planner then fetches the > actual current

[HACKERS] planstats.sgml

2016-02-15 Thread Tatsuo Ishii
While reading planstats.sgml, I encounted a sentence which I don't understand. These numbers are current as of the last VACUUM or ANALYZE on the table. The planner then fetches the actual current number of pages in the table (this is a cheap operation, not requiring a table