How big does your place.sqlite file get?

[Ant]

Mine gets up to 30 MB with 30 days of histories. :/

Thank you in advance. :)
--
"The men of experiment are like the ant; they only collect and use. But
the bee...gathers its materials from the flowers of the garden and of
the field, but transforms and digests it by a power of its own."
--Leonardo da Vinci
Note: A fixed width font (Courier, Monospace, etc.) is required to see
this signature correctly.
/\___/\ Ant(Dude) @ http://antfarm.ma.cx (Personal Web Site)
/ /\ /\ \ Ant's Quality Foraged Links: http://aqfl.net
| |o o| |
\ _ / If crediting, then use Ant nickname and AQFL URL/link.
( ) Axe ANT from its address if e-mailing privately.

[Wolf K]

On 2017-10-18 04:30, Ant wrote:
> Mine gets up to 30 MB with 30 days of histories. :/
>
> Thank you in advance. :)

Mine's at 1.1MB this a.m. I use CCleaner about every other week, and
often Clear History. The most visited sites are tabbed and/or on the
Bookmarks bar. I rarely have more than 8 or so tabs open. Finding what I
want with Search is quicker than scrolling through a month's worth of
History.

--
Wolf K
kirkwood40.blogspot.com
"Wanted. Schrödinger’s Cat. Dead and Alive."

[Libor Striz]

Dne 18.10.2017 v 10:30 Ant napsal(a):

> Mine gets up to 30 MB with 30 days of histories. :/

And how many bookmarks ?

[WaltS48]

On 10/18/17 4:30 AM, Ant wrote:
> Mine gets up to 30 MB with 30 days of histories. :/
>
> Thank you in advance. :)

5.2 MB

--
Go Bills, Steelers, Pitt, Pens and Sabres!
Coexist <https://www.coexist.org/>
National Popular Vote <http://www.nationalpopularvote.com/>
Ubuntu 16.04LTS - Unity Desktop

[Retroman]

On Wed, 18 Oct 2017 08:48:20 -0400, Wolf K <wol...@sympatico.ca>
wrote:

>On 2017-10-18 04:30, Ant wrote:
>> Mine gets up to 30 MB with 30 days of histories. :/
>>
>> Thank you in advance. :)
>
>Mine's at 1.1MB this a.m. I use CCleaner about every other week, and
>often Clear History. The most visited sites are tabbed and/or on the
>Bookmarks bar. I rarely have more than 8 or so tabs open. Finding what I
>want with Search is quicker than scrolling through a month's worth of
>History.

After reopening FF and closing it, you might want to open the
file places.sqlite in Notepad to see if it has indeed been
cleaned. My experience with places.sqlite and FF 55 is that the
file is rebuilt by FF with the prior entries mostly intact after
FF reopens. So CCleaner (which I also use) is not the answer.

There is a FF extension called PlacesCleaner that claimed to
clear this data but it does nothing in FF 55.

I don't have a solution to this problem, which is also unaffected
by the FF "clear history" feature. It would be good to know
where FF really stores these locations. Then we could add that
file as a custom location for CCleaner to clean.

Ideas, anyone?

Doug M. in NJ

[Gary C Curtin]

5.12 MB

[J. P. Gilliver (John)]

In message
<mailman.1321.150833093...@lists.mozilla.org>, Wolf

K <wol...@sympatico.ca> writes:
>On 2017-10-18 04:30, Ant wrote:
>> Mine gets up to 30 MB with 30 days of histories. :/
>> Thank you in advance. :)
>
>
>Mine's at 1.1MB this a.m. I use CCleaner about every other week, and
>often Clear History. The most visited sites are tabbed and/or on the
>Bookmarks bar. I rarely have more than 8 or so tabs open. Finding what
>I want with Search is quicker than scrolling through a month's worth of
>History.
>

Mine's about 41M, with years of histories (I can't remember when I last
cleared history, if ever, either from FF or Cc). This is with FF (26)
open, if that makes any difference. I too have tabs open (21 or 22 at
the moment). I rarely _use_ the history, though it has sometimes been
useful in the past; autocomplete as I type usually suggests what I want
(I _presume_ that's prompted by history).

My Pale Moon one is about 30-31M, dated 2017-April-10, which is probably
the last time I used it (and I'm pretty sure I let PM set itself up from
Firefox), so that _suggests_ it (the Firefox one) has grown about 10M in
6 months. (I didn't play with PM for long.)

Why are you (Ant) asking?
--
J. P. Gilliver. UMRA: 1960/<1985 MB++G()AL-IS-Ch++(p)Ar@T+H+Sh0!:`)DNAf

This was before we knew that a laboratory rat, if experimented upon, will
develop cancer. [Quoted by] Anne (ann...@aol.com), 1997-1-29

[EE]

I am using Pale Moon and SeaMonkey rather than Firefox, but that file
works the same way. In both, it is 10.5 MB. I block favicons.

[Keith Nuttle]

On 10/18/2017 4:30 AM, Ant wrote:
> Mine gets up to 30 MB with 30 days of histories. :/
>
> Thank you in advance. :)

Mine never gets over 6 MB, but I clear the history every time I close FF.

Based on other replies, I wonder if the minimal operational files size
is close to 5MB.

[Gary C Curtin]

I noticed that on a fresh install on Windows 10 FF 56, without importing anything from other browsers or connecting to the Internet, the size is 5,120KB.

[John McGaw]

On 10/18/2017 4:30 AM, Ant wrote:

> Mine gets up to 30 MB with 30 days of histories. :/
>
> Thank you in advance. :)

Windows reports mine as 46,080KB. I have never intentionally cleaned mine
up (and wouldn't know how to do so right off hand if I must be honest). It
doesn't seem to be any sort of drag.

[Wolf K]

Mine is 1.120MB

[B00ze]

On 2017-10-18 04:30, Ant <ANT...@zimage.com> wrote:

> Mine gets up to 30 MB with 30 days of histories. :/
> Thank you in advance. :)

Alright, mine is 61440KB. It has never been cleaned so it contains years
of history, and about 2500 bookmarks. What I would like is to remove all
history say older than 3 years. Anyone know if there's an AddOn for
that? The file will likely NOT shrink (maybe you can reclaim space with
the sqlite shell) but it would stop growing...

Thank you.
Best Regards,

--
! _\|/_ Sylvain / B00...@hotmail.com
! (o o) Member:David-Suzuki-Fdn/EFF/Red+Cross/SPCA/Planetary-Society
oO-( )-Oo Error 13: Insufficient user IQ.

[David E. Ross]

On 10/18/2017 1:30 AM, Ant wrote:
> Mine gets up to 30 MB with 30 days of histories. :/
>
> Thank you in advance. :)
>

I believe places.sqlite is forced to be at least 10 MB. This was done
at the same time (around 2011) the ability of users to have the history
of visiting a Web page automatically expire after some user-set number
of days. Now, history expires for the oldest entry only when some
excessive number of history entries are stored.

Before doing a system-wide backup, I run SpeedyFox, which currently
reduces the size to 2.7 MB. That reverts back to 10 MB when I terminate
my browser. I got SpeedyFox at <http://www.crystalidea.com/speedyfox>.

--
David E. Ross
<http://www.rossde.com/>

By allowing employers to eliminate coverage for birth control
from their insurance plans, President Trump has guaranteed there
will be an increase in the demand for abortions.

[Ant]

Too many. Maybe hundreds? Is there a way to calculate them in this file?
--
"Do not kill ants. They are your best friends." --Joe Brainard

[WaltS48]

On 10/18/17 8:58 PM, B00ze wrote:
> On 2017-10-18 04:30, Ant <ANT...@zimage.com> wrote:
>
>> Mine gets up to 30 MB with 30 days of histories. :/
>> Thank you in advance. :)
>
> Alright, mine is 61440KB. It has never been cleaned so it contains years
> of history, and about 2500 bookmarks. What I would like is to remove all
> history say older than 3 years. Anyone know if there's an AddOn for
> that? The file will likely NOT shrink (maybe you can reclaim space with
> the sqlite shell) but it would stop growing...
>
> Thank you.
> Best Regards,
>

That older history doesn't show up in the History sidebar or Library?

Ctrl+H to open the sidebar. Ctrl+Shift+H to open History in the Library.

[PietB]

B00ze wrote:
> Alright, mine is 61440KB. It has never been cleaned so it contains years
> of history, and about 2500 bookmarks. What I would like is to remove all
> history say older than 3 years. Anyone know if there's an AddOn for
> that? The file will likely NOT shrink (maybe you can reclaim space with
> the sqlite shell) but it would stop growing...

Addon? A rodent will do.
Right-click on "Older than 6 months", then Delete.
The effect isn't impressive though. Despite my history going back
at least 2 years, my places.sqlite went from 30 MB to 30 MB...

-p

[B00ze]

Ah! I didn't think of that :-) But I'd like to keep a few years, not
just 6 months, however I see it is easy to do, just go into Older than 6
Months and shift-select. I'm not surprised the database file itself does
not shrink; the free space is re-used tho, so it should stop growing for
a while. To make it shrink, go to the SQLite homepage and download the
tools. Then run SQLITE3.EXE "Places.sqlite" "VACUUM;" and it will
rebuild the database, sort everything, and remove wasted space.

Best Regards,

--
! _\|/_ Sylvain / B00...@hotmail.com
! (o o) Member:David-Suzuki-Fdn/EFF/Red+Cross/SPCA/Planetary-Society

oO-( )-Oo BUREAUCRACY: Transforming energy into solid waste.

[B00ze]

On 2017-10-18 21:08, WaltS48 <thali...@REMOVEaol.com> wrote:

> On 10/18/17 8:58 PM, B00ze wrote:
>> On 2017-10-18 04:30, Ant <ANT...@zimage.com> wrote:
>>
>>> Mine gets up to 30 MB with 30 days of histories. :/
>>> Thank you in advance. :)
>>
>> Alright, mine is 61440KB. It has never been cleaned so it contains
>> years of history, and about 2500 bookmarks. What I would like is to
>> remove all history say older than 3 years. Anyone know if there's an
>> AddOn for that? The file will likely NOT shrink (maybe you can reclaim
>> space with the sqlite shell) but it would stop growing...
>>
>> Thank you.
>> Best Regards,
>
> That older history doesn't show up in the History sidebar or Library?
> Ctrl+H to open the sidebar. Ctrl+Shift+H to open History in the Library.

Yeah, I didn't know we could delete history entries from the history
sidebar/library, thanks to you and Piet for letting me know! Who needs
an AddOn :-)

--
! _\|/_ Sylvain / B00...@hotmail.com
! (o o) Member:David-Suzuki-Fdn/EFF/Red+Cross/SPCA/Planetary-Society

oO-( )-Oo And all the Borg Left was this copy of Windoze.

[B00ze]

I just made this for myself from an older script.
Dump it in a .CMD or .BAT in the Firefox profile folder and double-click.
It will compact all the SQLite databases that Firefox uses.
You need SQLite3.exe somewhere in your path.

@ECHO OFF
@SETLOCAL ENABLEEXTENSIONS

REM ffVacuumAll2.cmd v2 2017-10-19
REM Runs sqlite3 VACUUM command on all SQLite databases in the current
folder
REM Just for safety we will not compact files with a Write-Ahead-Log
remaining behind
REM Make backup of all databases prior to vacuuming

PUSHD "%~dp0"
MD SQLiteBackup >NUL:
COMPACT /C SQLiteBackup >NUL:

For %%F in ("*.sqlite") do (

IF NOT EXIST "%%~F-wal" (

copy /Y /B "%%~F" SQLiteBackup >NUL: 2>&1

IF ERRORLEVEL 0 (

echo Compacting "%%~F"
sqlite3 "%%~F" "VACUUM;" )

) ELSE echo Skipping "%%~F" because of existing Write-Ahead-Log
)

POPD
pause

--
! _\|/_ Sylvain / B00...@hotmail.com
! (o o) Member:David-Suzuki-Fdn/EFF/Red+Cross/SPCA/Planetary-Society

[J. P. Gilliver (John)]

In message
<mailman.1402.150846591...@lists.mozilla.org>, B00ze
<B00...@hotmail.com> writes:
[]

>Ah! I didn't think of that :-) But I'd like to keep a few years, not
>just 6 months, however I see it is easy to do, just go into Older than
>6 Months and shift-select. I'm not surprised the database file itself
>does not shrink; the free space is re-used tho, so it should stop
>growing for a while. To make it shrink, go to the SQLite homepage and
>download the tools. Then run SQLITE3.EXE "Places.sqlite" "VACUUM;" and
>it will rebuild the database, sort everything, and remove wasted space.
>
>Best Regards,
>

I have an extension that does this latter bit for you, at least I think
it does - it's activate button looks like an upright vacuum cleaner!
It's called Vacuum Places Improved - it's one of the old type, I don't
know if it's been webbyized. Its hope page is/was
https://addons.mozilla.org/en-GB/firefox/addon/vacuum-places-improved/?src=api
, and it says it's based on
https://addons.mozilla.org/en-US/firefox/addon/13824 .

--
J. P. Gilliver. UMRA: 1960/<1985 MB++G()AL-IS-Ch++(p)Ar@T+H+Sh0!:`)DNAf

"Grammar is there to help, not hinder."
-- Mark Wallace, APIHNA, 2nd December 2000 (quoted by John Flynn 2000-12-6)

[B00ze]

On 2017-10-20 07:47, J. P. Gilliver (John) <G6JP...@255soft.uk> wrote:

> In message
> <mailman.1402.150846591...@lists.mozilla.org>, B00ze
> <B00...@hotmail.com> writes:

>> Ah! I didn't think of that :-) But I'd like to keep a few years, not
>> just 6 months, however I see it is easy to do, just go into Older than
>> 6 Months and shift-select. I'm not surprised the database file itself
>> does not shrink; the free space is re-used tho, so it should stop
>> growing for a while. To make it shrink, go to the SQLite homepage and
>> download the tools. Then run SQLITE3.EXE "Places.sqlite" "VACUUM;" and
>> it will rebuild the database, sort everything, and remove wasted space.
>>
>> Best Regards,
>>
> I have an extension that does this latter bit for you, at least I think
> it does - it's activate button looks like an upright vacuum cleaner!
> It's called Vacuum Places Improved - it's one of the old type, I don't
> know if it's been webbyized. Its hope page is/was
> https://addons.mozilla.org/en-GB/firefox/addon/vacuum-places-improved/?src=api

> and it says it's based on
> https://addons.mozilla.org/en-US/firefox/addon/13824 .

Yeah, I downloaded it and had a look at the code, it does indeed issue a
VACCUM command to the Places database:


Components.classes["@mozilla.org/browser/nav-history-service;1"]
.getService(Components.interfaces.nsPIPlacesDatabase)
.DBConnection.createStatement("VACUUM")
.executeAsync({

But you really only need to vaccum like once every 2 years; once every
30 days is a bit much, not that it will really hurt. I wonder if it
really works tho - when you do it with the SQLite3 tool, offline, it
rebuilds the database in a temporary file; does that work while the
database is opened as well? I'd have to go back to the SQLite website
and download the database documentation to make absolutely sure...

It's not been webbyized yet, lol. But someone is bound to do it one day.

Thanks!

--
! _\|/_ Sylvain / B00...@hotmail.com
! (o o) Member:David-Suzuki-Fdn/EFF/Red+Cross/SPCA/Planetary-Society

oO-( )-Oo Darmok and Groucho, at the opera.

[B00ze]

On 2017-10-20 04:50, PietB <www.godfatherof.nl/@opt-in.invalid> wrote:

> B00ze wrote:

>> Yeah, I didn't know we could delete history entries from the history
>> sidebar/library
>

> Yeah, it's a great way to cover your ass: make FF forget sites
> you probably shouldn't have visited. ;-)

Yup, and you can SEARCH too! I zapped some very old but, shall we say,
private, history lol.

--
! _\|/_ Sylvain / B00...@hotmail.com
! (o o) Member:David-Suzuki-Fdn/EFF/Red+Cross/SPCA/Planetary-Society

oO-( )-Oo Look! A completely new undocumented fea&%$#*@ NO CARRIER

[Christian Riechers]

On 10/20/17 1:47 PM, J. P. Gilliver (John) wrote:
> In message
> <mailman.1402.150846591...@lists.mozilla.org>, B00ze
> <B00...@hotmail.com> writes:
> []
>> Ah! I didn't think of that :-) But I'd like to keep a few years, not
>> just 6 months, however I see it is easy to do, just go into Older than
>> 6 Months and shift-select. I'm not surprised the database file itself
>> does not shrink; the free space is re-used tho, so it should stop
>> growing for a while. To make it shrink, go to the SQLite homepage and
>> download the tools. Then run SQLITE3.EXE "Places.sqlite" "VACUUM;" and
>> it will rebuild the database, sort everything, and remove wasted space.
>>
>> Best Regards,
>>
> I have an extension that does this latter bit for you, at least I think
> it does - it's activate button looks like an upright vacuum cleaner!
> It's called Vacuum Places Improved - it's one of the old type, I don't
> know if it's been webbyized. Its hope page is/was
> https://addons.mozilla.org/en-GB/firefox/addon/vacuum-places-improved/?src=api
>
> , and it says it's based on
> https://addons.mozilla.org/en-US/firefox/addon/13824 .

http://elgurutech.com/2011/06/21/dont-vacuum-your-places/

[J. P. Gilliver (John)]

In message
<mailman.1426.150856894...@lists.mozilla.org>,

"they also cautioned that continuous vacuuming could actually do more
harm than good" - without giving any details; and this from an article
written around the time of Firefox 3.7 to 5 (!). [2011-6-21.]

Basically, I'm not saying do or don't vacuum - just that there is an
extension that, if you _do_ want to do it, saves you doing the
command-line thing (you just do one click).

(I have it, but can't remember when I last used it - nor whether it made
any noticeable difference to anything.)

--
J. P. Gilliver. UMRA: 1960/<1985 MB++G()AL-IS-Ch++(p)Ar@T+H+Sh0!:`)DNAf

A biochemist walks into a student bar and says to the barman: "I'd like a pint
of adenosine triphosphate, please." "Certainly," says the barman, "that'll be
ATP." (Quoted in) The Independent, 2013-7-13

[B00ze]

On 2017-10-21 02:55, Christian Riechers <chrie...@netscape.net> wrote:

>
> http://elgurutech.com/2011/06/21/dont-vacuum-your-places/
>

Ah! I had a feeling that vacuuming too often wouldn't really help. I
vacuumed last week after about 5 years of not doing it, and only after
deleting a bunch of history entries and having lots and lots of FavIcon
reloaded because I used an AddOn to follow re-directs and correct the
URLs in Places (thereby stupidly destroying the FavIcon). My Places
shrunk a little, and went right back to its original size as soon as
Firefox loaded lol, kinda proving the point that as far as size is
concerned Firefox does a good job already.

Best Regards,

--
! _\|/_ Sylvain / B00...@hotmail.com
! (o o) Member:David-Suzuki-Fdn/EFF/Red+Cross/SPCA/Planetary-Society

oO-( )-Oo JUST DISCOVERED - Research causes cancer in rats!

[Mark12547]

In article <mailman.1491.1508587993.16833.support-
fir...@lists.mozilla.org>, G6JP...@255soft.uk says...

> "they also cautioned that continuous vacuuming could actually do more
> harm than good" - without giving any details; and this from an article
> written around the time of Firefox 3.7 to 5 (!). [2011-6-21.]
>
>

At my last job I had dealt with VSAM files, various databases, and
finally with Oracle databases. One common thread was that over-emphasis
on reorganizing the database (or VSAM cluster) often resulted in a
short-time degradation of INSERT performance. So I wouldn't recommend a
database reorganization daily, but monthly might be about right.

Lately I have been using https://www.crystalidea.com/speedyfox to vacuum
the .sqlite databases for various browsers and mail clients. (Run
against specified profiles only when they are not in use.) I found it
convenient and reasonably quick to run, and it handles all my Firefox
profiles, my one Chrome profile, and my one Thunderbird profile in a
single run.

If one runs CCleaner, it also has an option to "Compact Databases",
which is probably also the VACUUM command. It seems that from time to
time various options cause glitches with Firefox (e. g., Clear Session
History causes an "Oops! This is embarrassing!" screen on the next
Firefox start-up), but I don't recall any issues with "Compact
Databases" as long as Firefox is shut down when this runs.

[J. P. Gilliver (John)]

In message
<mailman.1469.150883217...@lists.mozilla.org>,

Mark12547 <mark...@xyzzy.invalid> writes:
>In article <mailman.1491.1508587993.16833.support-
>fir...@lists.mozilla.org>, G6JP...@255soft.uk says...
>> "they also cautioned that continuous vacuuming could actually do more
>> harm than good" - without giving any details; and this from an article
>> written around the time of Firefox 3.7 to 5 (!). [2011-6-21.]
>>
>>
>
>At my last job I had dealt with VSAM files, various databases, and
>finally with Oracle databases. One common thread was that over-emphasis
>on reorganizing the database (or VSAM cluster) often resulted in a
>short-time degradation of INSERT performance. So I wouldn't recommend a
>database reorganization daily, but monthly might be about right.

[]
Presumably "insert performance" means the time taken to add new entries.
I can see that where the database has gaps in it, it will be quicker to
add new entries than where it doesn't (at which point presumably the
file has to be rewritten to redefine its size to big enough to include
the new entry/ies); this to be set against it being larger than it need
be when there are _lots of_ (or _big_) gaps. So, as you say, compacting
it _too_ frequently might be counterproductive. Not necessarily cause
errors, though.

--
J. P. Gilliver. UMRA: 1960/<1985 MB++G()AL-IS-Ch++(p)Ar@T+H+Sh0!:`)DNAf

"EARTH is 98% full. Please delete anybody you can." - Fortunes file

[Mr. Man-wai Chang]

On 18/10/2017 4:30 PM, Ant wrote:
> Mine gets up to 30 MB with 30 days of histories. :/
>
> Thank you in advance. :)

46 Mbytes here... could I just delete it as in Thunderbird? :)

--
@~@ Remain silent! Drink, Blink, Stretch! Live long and prosper!!
/ v \ Simplicity is Beauty!
/( _ )\ May the Force and farces be with you!
^ ^ (x86_64 Ubuntu 9.10) Linux 2.6.39.3
不借貸! 不詐騙! 不援交! 不打交! 不打劫! 不自殺! 請考慮綜援 (CSSA):
http://www.swd.gov.hk/tc/index/site_pubsvc/page_socsecu/sub_addressesa

[Mr. Man-wai Chang]

On 19/10/2017 3:32 AM, John McGaw wrote:
>
> Windows reports mine as 46,080KB. I have never intentionally cleaned
> mine up (and wouldn't know how to do so right off hand if I must be
> honest). It doesn't seem to be any sort of drag.

47,185,920 bytes to be exact? :)

[Mark12547]

My places.sqlite file sizes are:

Nightly: 20,480 KB (currently my primary browser)
Beta: 5,120 KB (lightly used)
Release: 5,120 KB (lightly used)


In article <mailman.1473.1508842769.16832.support-
fir...@lists.mozilla.org>, G6JP...@255soft.uk says...

> So, as you say, compacting
> it _too_ frequently might be counterproductive. Not necessarily cause
> errors, though.
>
>

Right: compressing too frequently can slow down INSERT performance for
the next one or few INSERTs after the compress due to needing to
allocate additional space, split a database allocation unit or other
overhead (details vary between databases), and after that INSERT
performance should become normal.

But it should NOT cause errors.

[Graham Perrin]

On 18/10/2017 17:20, J. P. Gilliver (John) wrote:

> … about 41M, with years of histories … FF (26) … tabs open (21 or 22 at the moment). …

45M here, and performance is fine.


$ date ; uname -v
Sat 4 Nov 2017 12:38:12 GMT
FreeBSD 12.0-CURRENT #0 r320869: Mon Jul 10 13:57:55 UTC 2017 ro...@releng3.nyi.freebsd.org:/usr/obj/usr/src/sys/GENERIC
$ ls -hlrt places.*
-rw-r--r-- 1 grahamperrin grahamperrin 45M 4 Nov 12:30 places.sqlite
-rw-r--r-- 1 grahamperrin grahamperrin 2.2M 4 Nov 12:31 places.sqlite-wal
-rw-r--r-- 1 grahamperrin grahamperrin 32K 4 Nov 12:32 places.sqlite-shm
$ pkg info firefox | grep -i version
Version : 56.0.2_5,1
$


At the time of writing:

- 1,265 tabs
-twenty or fewer loaded.

<https://mozilla.logbot.info/firefox/20171029#c13778254> reminds me that at extraordinarily busy times, more than fifteen minutes can pass without a write to the database.

[Ant]

You were running Firefox because of -wal and -shm. What about if you
exited it?

On 11/4/2017 5:48 AM, Graham Perrin wrote:
>
> 45M here, and performance is fine.
>
>
> $ date ; uname -v
> Sat 4 Nov 2017 12:38:12 GMT
> FreeBSD 12.0-CURRENT #0 r320869: Mon Jul 10 13:57:55 UTC 2017
> ro...@releng3.nyi.freebsd.org:/usr/obj/usr/src/sys/GENERIC
> $ ls -hlrt places.*
> -rw-r--r-- 1 grahamperrin grahamperrin 45M 4 Nov 12:30 places.sqlite
> -rw-r--r-- 1 grahamperrin grahamperrin 2.2M 4 Nov 12:31
> places.sqlite-wal
> -rw-r--r-- 1 grahamperrin grahamperrin 32K 4 Nov 12:32
> places.sqlite-shm
> $ pkg info firefox | grep -i version
> Version : 56.0.2_5,1
> $
>
>
> At the time of writing:
>
> - 1,265 tabs
> -twenty or fewer loaded.
>
> <https://mozilla.logbot.info/firefox/20171029#c13778254> reminds me that
> at extraordinarily busy times, more than fifteen minutes can pass
> without a write to the database.

--
"Are you slower than an ant?" --Sai Yuk from The Legend of Fong Sai Yuk
movie (English subtitles)

[Graham Perrin]

On 04/11/2017 17:15, Ant wrote:

> You were running Firefox because of -wal and -shm. What about if you exited it?

Below, three listings:

1. running Firefox
2. without running Firefox
3. after using DB Browser for SQLite <http://sqlitebrowser.org/> 3.10.0 to compact the database


Sun 5 Nov 2017 08:52:06 GMT
-rw-r--r-- 1 grahamperrin grahamperrin 45M 5 Nov 08:34 places.sqlite
-rw-r--r-- 1 grahamperrin grahamperrin 0B 5 Nov 08:50 places.sqlite-wal
-rw-r--r-- 1 grahamperrin grahamperrin 32K 5 Nov 08:51 places.sqlite-shm
$ date ; ls -hlrt places.*
Sun 5 Nov 2017 08:52:34 GMT
-rw-r--r-- 1 grahamperrin grahamperrin 45M 5 Nov 08:34 places.sqlite
$ date ; ls -hlrt places.*
Sun 5 Nov 2017 08:53:38 GMT
-rw-r--r-- 1 grahamperrin grahamperrin 42M 5 Nov 08:53 places.sqlite
$


I expect no more than that from compaction, so it's not a routine (not necessary – there's plenty of free space in the ZFS pool that I created for my home directory).

$ zfs get used,available,referenced,compressratio,recordsize,compression,atime,usedbysnapshots,usedbydataset,usedbychildren,compressratio,logicalused,logicalreferenced hpelitebook8570p/usr/home/grahamperrin
NAME PROPERTY VALUE SOURCE
hpelitebook8570p/usr/home/grahamperrin used 79.0G -
hpelitebook8570p/usr/home/grahamperrin available 231G -
hpelitebook8570p/usr/home/grahamperrin referenced 76.8G -
hpelitebook8570p/usr/home/grahamperrin compressratio 1.29x -
hpelitebook8570p/usr/home/grahamperrin recordsize 128K default
hpelitebook8570p/usr/home/grahamperrin compression lz4 inherited from hpelitebook8570p
hpelitebook8570p/usr/home/grahamperrin atime off inherited from hpelitebook8570p
hpelitebook8570p/usr/home/grahamperrin usedbysnapshots 2.13G -
hpelitebook8570p/usr/home/grahamperrin usedbydataset 76.8G -
hpelitebook8570p/usr/home/grahamperrin usedbychildren 0 -
hpelitebook8570p/usr/home/grahamperrin compressratio 1.29x -
hpelitebook8570p/usr/home/grahamperrin logicalused 102G -
hpelitebook8570p/usr/home/grahamperrin logicalreferenced 97.9G -
$