Re: Switched to PostgreSQL

Dne čtvrtek 11. dubna 2019 9:39:19 CEST, Martin Steigerwald napsal(a):
> So far the performance is really quite a bit better. The stalls during
> filtering are gone. About the crashes I am not sure yet. Also I found
> that there are no stalls anymore on deleting a mail.
> Did anyone with PostgreSQL setup did any tuning on the database?
> I see that the various PostgreSQL processes do not take all that much
> RAM yet. They take quite a bit of RSS, but apparently share lots of it,
> so the PSS is quite a bit lower (see in atop, memory display with "m",
> enable PSIZE gathering with "R").
> Is there something like mysqltuner for PostgreSQL? Otherwise I can use
> my own training slides or official documentation.
> However, as long as it stays as fast as it currently is, I might just
> let the configuration alone for now.
> Let's see how this goes.
> Thanks again for the hint to switch to PostgreSQL and the instructions
> for how to do it.

Regarding PostgreSQL, I always had feeling that upgrade of PostgreSQL is not 
so straightforward as upgrade of MySQL. PostgreSQL DB must be exported, than 
cluster upgraded, settings restored and old DB imported. How do users of 
PostgreSQL and Akonadi handle this when upgrading their distribution?

-- 
Vojtěch Zeisek

Komunita openSUSE GNU/Linuxu
Community of the openSUSE GNU/Linux

https://www.opensuse.org/
https://trapa.cz/

-----BEGIN PGP SIGNATURE-----

iQIzBAABCAAdFiEES97LYVdqIgW2UhmwtBndlZHSOVEFAlyvLe4ACgkQtBndlZHS
OVHKkg/9Fj9oDP6upGWSGujvi4w4gLXVfrkNJlYlDUpR02TqHEn+v2EyzElpstHU
ovqtOo+Apd5W786MP+nlHSxrNP2R7coeYiurYDEybI72ibIWKAHkYbA08IRiWxVx
XMcObque+kuFRFTjKblvzXbhuoPHK2LbQGJ/uOI9vFwTHaPXDcE2rUQ1DI9xgjEf
XrI9f1ofpGe1mZ/CH9K2JzD67wHyLNlZW8sh77Wr9cRwLsg00Jree2tf/kEobh7d
2GLwawaj3eJ16v8g47nl3sfJVyRXtbNsGGlF4eGEnuqlvrowL4Fpdb6BPo5X9hbR
1sAddEyBeiT8e2D+CTPF5DtwLwinWpunu7UhtiT0Ps0KHFrtGoAubhd5B6aUFg+8
pKdqlQIuUxYrRbDpasV/JTvAs4BxlgU3QKK5HlWhM+UVeg5iUL4YwtL2qsp5vv11
y1YNbZIIIwvcVGYbmdGC82yxU5Bwl7Am+1DPd2xwN+9LAaRZ/3BDJ+Ygi61gWXNW
sCJTeZwx/cqG8qg6tSLRpDME3IwM3v1nWSO7eAbK+YEjfPSSbV8F7qwsf9EAt31Z
plAFdNe1yczj4uuxfpLgpVGWt9aKmeKBreiHUoWdakJd05LGdg+fXLvIru38tiP4
feDSWckYjswZDhBMY8LV6I9c+JSlbJNhAPYafy2CkSbOFqyWpyA=
=cl2G
-----END PGP SIGNATURE-----