Minetest logo

IRC log for #minetest-dev, 2016-09-11

| Channels | #minetest-dev index | Today | | Google Search | Plaintext

All times shown according to UTC.

Time Nick Message
00:21 MrIbby joined #minetest-dev
01:55 alkotob_ joined #minetest-dev
02:37 STHGOM joined #minetest-dev
02:37 STHGOM joined #minetest-dev
03:25 Void7 joined #minetest-dev
03:27 MrIbby joined #minetest-dev
03:41 padgaland joined #minetest-dev
04:17 DI3HARD139 joined #minetest-dev
05:08 ssieb joined #minetest-dev
05:10 lordfingle joined #minetest-dev
05:19 alkotob_ joined #minetest-dev
06:34 froike__ joined #minetest-dev
06:50 Hunterz joined #minetest-dev
07:51 red-001 joined #minetest-dev
07:56 Krock joined #minetest-dev
08:56 nrzkt joined #minetest-dev
09:06 Darcidride joined #minetest-dev
09:10 Zeno` joined #minetest-dev
09:15 Kray joined #minetest-dev
09:16 Fritigern joined #minetest-dev
09:22 Kray joined #minetest-dev
09:43 Fixer joined #minetest-dev
09:55 proller joined #minetest-dev
10:45 damiel_ joined #minetest-dev
11:03 Megaf Dear devs, how is it going? I have this question about sqlite compression. There's this too
11:04 Megaf Tool, called sqlitebrowser, it has an option to compress the db
11:05 Megaf I wonder if I could use it to compress my map.sqlite. Have you ever tried that?
11:06 Krock mapblocks are already gzipped
11:06 Krock and double compression usually lacks of effectivity
11:07 Megaf If it is so then the engine is pretty inefficient in storing information on the db
11:09 Janaton joined #minetest-dev
11:10 Krock yesterday appeared a potential metadata issue, where empty inventories were saved in a mapblock.
11:10 Krock maybe cleaning that up would free some space
11:12 Megaf Krock: I read that, I was wondering how possible would it be to clean/fix that
11:12 Krock me too
11:16 proller__ joined #minetest-dev
11:30 T4im joined #minetest-dev
11:31 AcidNinjaFWHR joined #minetest-dev
11:57 everamzah joined #minetest-dev
12:15 Grandolf joined #minetest-dev
12:27 xunto joined #minetest-dev
12:47 proller joined #minetest-dev
12:57 Fixer Megaf: try unexplore script
13:00 Megaf Fixer: I read about it Fixer, I'm almost sure it will mess up my world pretty badly, specially because we have lots of things built with trees, stone and dirt
13:00 Megaf I also have nether, and things build with nether stuff
13:02 Megaf Fixer: What I'm doing right now is a /clearobjects, then I will vacuum it and rebuild the index
13:03 Megaf and in a backup copy I will try to compact the db with sqlitebrowser
13:06 Megaf Never mind then
13:16 Megaf up #1620
13:16 ShadowBot https://github.com/minetest/minetest/issues/1620 -- Progress bar/status/info for /clearobjects.
13:35 est31 joined #minetest-dev
13:48 hmmmm joined #minetest-dev
14:47 red-001 joined #minetest-dev
14:52 HonoredGlory joined #minetest-dev
14:54 nrzkt joined #minetest-dev
15:00 Tmanyo joined #minetest-dev
15:02 Taoki joined #minetest-dev
15:02 Void7 joined #minetest-dev
15:05 KaadmY joined #minetest-dev
15:13 Megaf The DB got 129.624 MB after VACUUM. It's not a huge reduction is it?
15:14 Megaf original size was 4453.74 MB
15:15 Megaf Krock: ^
15:15 Megaf reindex don't change the size at all
15:15 rubenwardy joined #minetest-dev
15:16 Krock indeed, that's not much
15:16 Megaf and that was after a /clearobjects
15:17 Megaf I'm backing up the db now and will run a compression on it to see if there's any significant change
15:18 Megaf it will be fun handling a 4.4 GB db on this AMD E1 at 1.3 GHz CPU with 4 GB of RAM
15:25 Megaf well, no size difference at all after compression
15:25 Megaf [12:06:14] <Krock> mapblocks are already gzipped
15:25 Megaf [12:06:33] <Krock> and double compression usually lacks of effectivity
15:25 Megaf You are right
15:37 Icedream joined #minetest-dev
15:47 Fixer joined #minetest-dev
15:49 nrzkt vacuum is the only way to reduce size in pg
15:50 nrzkt you sould enable auto vacuum & use recent pgsql
15:52 Megaf and how would that help? What's the benefit?
15:53 padgaland joined #minetest-dev
15:54 halt_ joined #minetest-dev
16:08 STHGOM joined #minetest-dev
16:08 STHGOM joined #minetest-dev
16:09 nrzkt perf + automatic vacuum cleanup
16:09 Megaf I can setup automatic vacuum on sqlite too, and we don't know that pgsql is faster with minetest
16:12 nrzkt then just ask skype why they use pgsql instance of sqlite :p
16:16 padgaland left #minetest-dev
16:30 Void7 joined #minetest-dev
16:31 MrIbby joined #minetest-dev
16:46 damiel_ joined #minetest-dev
17:23 srifqi joined #minetest-dev
17:31 lordfingle joined #minetest-dev
18:40 srifqi joined #minetest-dev
18:54 AcidNinjaFWHR joined #minetest-dev
19:07 est31 joined #minetest-dev
19:15 fling joined #minetest-dev
19:15 fling joined #minetest-dev
19:16 torgdor joined #minetest-dev
19:17 Darcidride joined #minetest-dev
19:23 Void7 joined #minetest-dev
19:36 rubenwardy joined #minetest-dev
20:09 kruug joined #minetest-dev
20:09 est31 https://lists.x.org/archives/xorg​-devel/2016-September/050975.html
20:09 est31 nice nice nice
20:09 est31 may fix bug #1763
20:09 ShadowBot https://github.com/minetest/minetest/issues/1763 -- Spinning frustum on Xwayland
20:10 kruug Is there an "on_point" function similar to "on_drop" or "on_place"?
20:16 MrIbby joined #minetest-dev
20:21 Hijiri no
20:22 kruug Hmmm...
20:23 kruug is there a channel designated for modding?  I don't want to muddy up the main dev chat with the rest of my questions.
20:23 est31 kruug, #minetest or #minetest-project
20:23 Hijiri #minetest is where mod discussion usually goes
20:23 kruug still on freenode?
20:23 Hijiri both yes
20:23 est31 yes
20:23 kruug thanks.
20:24 kruug left #minetest-dev
20:26 ptv joined #minetest-dev
20:52 MrIbby joined #minetest-dev
20:54 lordfingle joined #minetest-dev
21:52 everamzah joined #minetest-dev
21:59 alkotob joined #minetest-dev
23:39 nolsen Looks like collect_static isn't working properly anymore.
23:48 MrIbby joined #minetest-dev

| Channels | #minetest-dev index | Today | | Google Search | Plaintext