Re: [PERFORM] shared_buffers advice

2010-05-28 Thread Konrad Garus
hing less critical first (but still with a good amount of memory mapped by page buffers). What system have you tested it on? Has it ever run on a few-gig system? :-) -- Konrad Garus -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscript

Re: [PERFORM] shared_buffers advice

2010-05-27 Thread Konrad Garus
#x27;t check what is the optimum > projection size yet) > So both yes at your questions :) So when I map 12 GB, this process will consume 1 GB and the time needed to browse through the whole 12 GB buffer? -- Konrad Garus -- Sent via pgsql-performance mailing list (pgsql-performance@postgres

Re: [PERFORM] shared_buffers advice

2010-05-27 Thread Konrad Garus
2010/5/27 Cédric Villemain : > pgmincore() and pgmincore_snapshot() both are able to mmap up to 1GB. Does it mean they can occupy 1 GB of RAM? How does it relate to amount of page buffers mapped by OS? -- Konrad Garus -- Sent via pgsql-performance mailing list (pgsql-performa

Re: [PERFORM] shared_buffers advice

2010-05-27 Thread Konrad Garus
there any interaction between it and PG/OS, when it's not executing a command explicitly invoked by me? -- Konrad Garus -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

Re: [PERFORM] shared_buffers advice

2010-05-27 Thread Konrad Garus
with postgresql and deliver very usefull > information : > http://www.postgresql.org/docs/8.4/interactive/pgbuffercache.html Thank you. I already am using it. I've already found a few hogs with it. -- Konrad Garus -- Sent via pgsql-performance mailing list (pgsql-performance@postgre

Re: [PERFORM] shared_buffers advice

2010-05-25 Thread Konrad Garus
d view over all the performance concerns. It should be part of documentation or the first page of performance wiki. Have you copied it from somewhere? -- Konrad Garus -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://ww

Re: [PERFORM] shared_buffers advice

2010-05-24 Thread Konrad Garus
here a tool or built-in statistic that tells when/how often/how much a table is read from disk? I mean physical read, not poll from OS cache to shared_buffers. -- Konrad Garus -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

[PERFORM] Paritioning vs. caching

2010-03-08 Thread Konrad Garus
k (because they were not found in RAM)? Thank you. -- Konrad Garus -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance