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