Re: [sqlite] Any operation to trigger osMunmap?

2018-04-18 Thread Nick
So the PSS will not decrease even if the db becomes smaller after some DELETE/vacuum operations? I think it is a better way to free the mmap memory after every query automatically inside sqlite. Why not? -- Sent from: http://sqlite.1065341.n5.nabble.com/

Re: [sqlite] Any operation to trigger osMunmap?

2018-04-18 Thread Richard Hipp
On 4/18/18, Nick wrote: > Hi, > I have one process using sqlite with “pragma mmap_size=30M”. The operations > of my process is insert-select-insert-select. So the PSS(private clean) will > increase along with the growing of the db which is treated as memory leak by >

[sqlite] Any operation to trigger osMunmap?

2018-04-18 Thread Nick
Hi, I have one process using sqlite with “pragma mmap_size=30M”. The operations of my process is insert-select-insert-select. So the PSS(private clean) will increase along with the growing of the db which is treated as memory leak by Mem-Analysor tool. I guess calling sqlite3_close() or pragma