Re: [HACKERS] [COMMITTERS] pgsql: Add pages deleted from pending list to FSM

2015-09-24 Thread Fujii Masao
On Sat, Sep 19, 2015 at 5:20 AM, Jeff Janes wrote: > On Fri, Sep 18, 2015 at 6:27 AM, Tom Lane wrote: >> >> [ moving thread to -hackers ] >> >> Fujii Masao writes: >> > So autoanalyze still doesn't call IndexFreeSpaceMapVacuum().

Re: [HACKERS] [COMMITTERS] pgsql: Add pages deleted from pending list to FSM

2015-09-18 Thread Jeff Janes
On Fri, Sep 18, 2015 at 6:27 AM, Tom Lane wrote: > [ moving thread to -hackers ] > > Fujii Masao writes: > > So autoanalyze still doesn't call IndexFreeSpaceMapVacuum(). > > That is, only backend can clean the list in INSERT-only workload. > > I don't

Re: [HACKERS] [COMMITTERS] pgsql: Add pages deleted from pending list to FSM

2015-09-18 Thread Teodor Sigaev
Reply to both emails in one Fujii: > So autoanalyze still doesn't call IndexFreeSpaceMapVacuum(). Fixed, see patch > ginvacuumcleanup calls RecordFreeIndexPage() twice for the same block. fixed too Tom: It seems quite bizarre for auto-analyze to do that. auto-vacuum, sure, but I do not

Re: [HACKERS] [COMMITTERS] pgsql: Add pages deleted from pending list to FSM

2015-09-18 Thread Teodor Sigaev
-- Teodor Sigaev E-mail: teo...@sigaev.ru WWW: http://www.sigaev.ru/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription:

Re: [HACKERS] [COMMITTERS] pgsql: Add pages deleted from pending list to FSM

2015-09-18 Thread Tom Lane
[ moving thread to -hackers ] Fujii Masao writes: > So autoanalyze still doesn't call IndexFreeSpaceMapVacuum(). > That is, only backend can clean the list in INSERT-only workload. > I don't think that this is desirable. Because the backend will > periodically take a big