[PERFORM] loading increase into huge table with 50.000.000 records

Hello, Sorry for my poor english, My problem : I meet some performance problem during load increase. massive update of 50.000.000 records and 2.000.000 insert with a weekly frequency in a huge table (+50.000.000 records, ten fields, 12 Go on hard disk) current performance obtained : 120

Re: [PERFORM] loading increase into huge table with 50.000.000 records

Hi Larry, Do you run vacuum and analyze frequently? Did you check PowerPostgresql.com for hints about PostgreSQL tuning? http://www.powerpostgresql.com/Docs/ You can increase wal_buffers, checkpoint_segments and checkpoint_timeout much higher. Here is a sample which works for me. wal_buffers =

Re: [PERFORM] loading increase into huge table with 50.000.000 records

Hi, Larry, Hi, Sven, Sven Geisler wrote: You can increase wal_buffers, checkpoint_segments and checkpoint_timeout much higher. You also should increase the free space map settings, it must be large enough to cope with your weekly bunch. Markus -- Markus Schaber | Logical TrackingTracing

Re: [PERFORM] loading increase into huge table with 50.000.000 records

On 7/26/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hello, Sorry for my poor english, My problem : I meet some performance problem during load increase. massive update of 50.000.000 records and 2.000.000 insert with a weekly frequency in a huge table (+50.000.000 records, ten fields, 12