Re: [PERFORM] getting better performance

2006-07-07 Thread Markus Schaber
Hi, Eugeny, Eugeny N Dzhurinsky wrote: >> Do you add / remove tables a lot? Could be you've got system catalog >> bloat. > > Yes, almost each table is dropped and re-created in 3-5 days. If your really recreate the same table, TRUNCATE may be a better solution than dropping and recreation. HT

Re: [PERFORM] getting better performance

2006-07-06 Thread Scott Marlowe
On Thu, 2006-07-06 at 10:11, Eugeny N Dzhurinsky wrote: > On Thu, Jul 06, 2006 at 09:28:39AM -0500, Scott Marlowe wrote: > > On Thu, 2006-07-06 at 01:40, Eugeny N Dzhurinsky wrote: > > Do you add / remove tables a lot? Could be you've got system catalog > > bloat. > > Yes, almost each table is dr

Re: [PERFORM] getting better performance

2006-07-06 Thread Merlin Moncure
On 7/6/06, Eugeny N Dzhurinsky <[EMAIL PROTECTED]> wrote: Hello! I have a postgresql server serving thousands of tables. Sometime there are queries which involves several tables. In postgresql.conf I have these settings: shared_buffers = 4 work_mem = 8192 maintenance_work_mem = 16384 max

Re: [PERFORM] getting better performance

2006-07-06 Thread Eugeny N Dzhurinsky
On Thu, Jul 06, 2006 at 09:28:39AM -0500, Scott Marlowe wrote: > On Thu, 2006-07-06 at 01:40, Eugeny N Dzhurinsky wrote: > Do you add / remove tables a lot? Could be you've got system catalog > bloat. Yes, almost each table is dropped and re-created in 3-5 days. > do you have autovacuum running?

Re: [PERFORM] getting better performance

2006-07-06 Thread Scott Marlowe
On Thu, 2006-07-06 at 01:40, Eugeny N Dzhurinsky wrote: > Hello! > > I have a postgresql server serving thousands of tables. Sometime there are > queries which involves several tables. Do you add / remove tables a lot? Could be you've got system catalog bloat. do you have autovacuum running? W

Re: [PERFORM] getting better performance

2006-07-06 Thread Ivan Zolotukhin
On 7/6/06, A. Kretschmer <[EMAIL PROTECTED]> wrote: am 06.07.2006, um 9:40:16 +0300 mailte Eugeny N Dzhurinsky folgendes: > In postgresql.conf I have these settings: > > shared_buffers = 4 > work_mem = 8192 > maintenance_work_mem = 16384 > max_stack_depth = 2048 > > all other settings are l

Re: [PERFORM] getting better performance

2006-07-05 Thread A. Kretschmer
am 06.07.2006, um 9:40:16 +0300 mailte Eugeny N Dzhurinsky folgendes: > In postgresql.conf I have these settings: > > shared_buffers = 4 > work_mem = 8192 > maintenance_work_mem = 16384 > max_stack_depth = 2048 > > all other settings are left by default (except ones needed for pg_autovacuum

[PERFORM] getting better performance

2006-07-05 Thread Eugeny N Dzhurinsky
Hello! I have a postgresql server serving thousands of tables. Sometime there are queries which involves several tables. In postgresql.conf I have these settings: shared_buffers = 4 work_mem = 8192 maintenance_work_mem = 16384 max_stack_depth = 2048 all other settings are left by default (e