Archives de catégorie : system

Reading documentation on DKIM I found it usefull to be able to distribute public keys through DNS to allow recipient to check signed content against it. So, here is a couple of DomainKeysSigner and DomainKeysVerifier PHP classes that implement the sign … Continuer la lecture →

Edit your Apache conf and and %{mod_php_memory_usage}n to the LogFormat directive to log the PHP memory consumption in bytes : LogFormat « %h %l %u %t \ »%r\ » %>s %b » %{mod_php_memory_usage}n Save and reload Apache.

I discovered that one can set the work_mem from PHP after connecting to the database and before issuing heavy requests : <?php $conn = pg_connect(« service=test »); // Set work_mem to 128MB $res = pg_query(sprintf(« SET work_mem = ‘%s’ », pg_escape_string(’128MB’))); // Run your query … Continuer la lecture →

Here is a Postgresql requests which will allows you to view the size of your tables with their idx_scan and seq_scan counts. SELECT s.schemaname, s.relname, c.oid, c.relfilenode, s.seq_scan,s.idx_scan, c.relpages AS pages FROM pg_stat_all_tables AS s, pg_class AS c WHERE s.relname … Continuer la lecture →