Re: PostgreSQL 9.3 abd CentOS 7 memory usage
От | Jan Lentfer |
---|---|
Тема | Re: PostgreSQL 9.3 abd CentOS 7 memory usage |
Дата | |
Msg-id | 543C1DBA.4020805@web.de обсуждение исходный текст |
Ответ на | PostgreSQL 9.3 abd CentOS 7 memory usage (Elías David <elias.moreno.tec@gmail.com>) |
Ответы |
Re: PostgreSQL 9.3 abd CentOS 7 memory usage
|
Список | pgsql-admin |
Am 13.10.2014 um 20:12 schrieb Elías David:
>> What's the on-disk size of your databases and can you estimate the actual working set? How long is this system up and being queried?
>> I have seen similar when upgrading from 8.4 to 9.3 on Solaris 10, Postgres running in zones. I could not yet investigate further and performance is perfect still.
Ok, here it goes:ccs1cl --> 41 MBdb_otrs_ub --> 14 MBelmap --> 207 MBelmap_int --> 182 MBinvent_equi --> 532 MBinvent_equi_fc --> 114 MBjasper --> 13 MBnetasis --> 23 MBotrs --> 361 MBpatint --> 615 MBseg_alt --> 75 MBseg_alt_par --> 75 MBThe average of transactions are around 85 per second and several of the databases (jasper, patint, elmap...) are accessed everyday, 365 days a year (it's part of an offering from the company that runs the services every single day of the year). Right now the system has been up for 17 days.
So, that sums up to 2,2GB of databases (is that the right unit? MB?) ... so even IF all of the data was read and stored in buffers that would not cause a significant amount of memory used data on a 128GB machine, When you look at "top" output, what the value for "cached" (5th line on the very right)?
В списке pgsql-admin по дате отправления: