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