| 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 |
