PostgreSQL, ZFS, FreeBSD, Linux

Data publikacji: Nov 25, 2013 8:4:20 PM

Uwaga: Nie ważne co piszą poniżej: primarycache=all + limit rozmiaru ARC (suma tego limitu + shared_buffers = effective_cache_size).

Obliczenie efektywnego shared_buffers - kolumna count_desc (dla usagecount = 3).

# select usagecount,pg_size_pretty(count*8192),pg_size_pretty(sum(count) over(order by usagecount)*8192) as count_asc, pg_size_pretty(sum(count) over (order by usagecount desc)*8192) as count_desc from (select usagecount,count(usagecount) as count from pg_buffercache group by usagecount order by usagecount) as s;

usagecount | pg_size_pretty | count_asc | count_desc

------------+----------------+-----------+------------

5 | 8570 MB | 40 GB | 8570 MB

4 | 5227 MB | 32 GB | 13 GB

3 | 2692 MB | 27 GB | 16 GB

2 | 3444 MB | 24 GB | 19 GB

1 | 10021 MB | 21 GB | 29 GB

0 | 11 GB | 11 GB | 40 GB

Aktualne:

http://olavgg.com/post/62799347118/postgresql-9-3-on-zfs-with-lz4-compression-on-freebsd

https://www.kib.kiev.ua/kib/pgsql_perf_v2.0.pdf

http://lethargy.org/~jesus/misc/PostgreSQLonSolaris.pdf