Re: getting better performance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



am  06.07.2006, um  9:40:16 +0300 mailte Eugeny N Dzhurinsky folgendes:
> In postgresql.conf I have these settings:
> 
> shared_buffers = 40000
> work_mem = 8192
> maintenance_work_mem = 16384
> max_stack_depth = 2048
> 
> all other settings are left by default (except ones needed for pg_autovacuum).
> 
> Is there anything I can tune to get better performance?

You can set "log_min_duration_statement" to log slow querys and then
analyse this querys.


HTH, Andreas
-- 
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    === 


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux