View Attach Info

Add new attachment

Only authorized users are allowed to upload new attachments.

This page (revision-52) was last changed on 10-Sep-2010 17:52 by Maianti Alberto  

This page was created on 14-Apr-2010 14:30 by Administrator

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Difference between version and

At line 5 added one line
!!INSTALLAZIONE
At line 7 added 46 lines
Installare i pacchetti postgresql postgresql-client postgresql-contrib
!!TUNING
Per un tuning di base di postgres si può utilizzare questa utility: pg-tune
Per una macchina con circa 4GB una configurazione "decente" di postgres potrebbe essere questa:
%%prettify
{{{
maintenance_work_mem = 288MB # pgtune wizard 2010-02-24
checkpoint_completion_target = 0.7 # pgtune wizard 2010-02-24
effective_cache_size = 3584MB # pgtune wizard 2010-02-24
work_mem = 24MB # pgtune wizard 2010-02-24
wal_buffers = 4MB # pgtune wizard 2010-02-24
checkpoint_segments = 8 # pgtune wizard 2010-02-24
shared_buffers = 960MB # pgtune wizard 2010-02-24
max_connections = 200 # pgtune wizard 2010-02-24
}}}
/%
Se si aumentano le connessioni e lo shared_buffers di postgres è possibile/probabile che serva aumentare anche la shared memory di linux questo è possibile attraverso questi comandi:
%%prettify
{{{
cp /etc/sysctl.conf /etc/sysctl.conf-orig
vi /etc/sysctl.conf
}}}
/%
Aggiungere la riga con il valore appropriato:
%%prettify
{{{
kernel.shmmax = 104857600
}}}
/%
Salvare il file e far ricaricare i parametri al kernel con:
%%prettify
{{{
sysctl -p
}}}
/%
Version Date Modified Size Author Changes ... Change note
52 10-Sep-2010 17:52 7.124 kB Maianti Alberto to previous
51 10-Sep-2010 17:51 7.084 kB Maianti Alberto to previous | to last
50 10-Sep-2010 17:50 7.176 kB Maianti Alberto to previous | to last
49 14-Apr-2010 14:30 5.957 kB RaffaelePedrini to previous | to last
48 14-Apr-2010 14:30 5.694 kB RaffaelePedrini to previous | to last
47 14-Apr-2010 14:30 5.564 kB RaffaelePedrini to previous | to last
46 14-Apr-2010 14:30 5.555 kB RaffaelePedrini to previous | to last
45 14-Apr-2010 14:30 5.441 kB RaffaelePedrini to previous | to last
44 14-Apr-2010 14:30 5.52 kB RaffaelePedrini to previous | to last
43 14-Apr-2010 14:30 5.145 kB RaffaelePedrini to previous | to last
42 14-Apr-2010 14:30 4.95 kB RaffaelePedrini to previous | to last
41 14-Apr-2010 14:30 4.949 kB RaffaelePedrini to previous | to last
« This page (revision-52) was last changed on 10-Sep-2010 17:52 by Maianti Alberto