Postgres Pro
Downloads
Home   >   mailing lists

Re: loading increase into huge table with 50.000.000 records - Mailing list pgsql-performance

From Markus Schaber
Subject Re: loading increase into huge table with 50.000.000 records
Date
Msg-id 44C79ACB.5010507@logix-tt.com
Whole thread Raw
In response to Re: loading increase into huge table with 50.000.000 records  (Sven Geisler <sgeisler@aeccom.com>)
List pgsql-performance
Tree view 
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 Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

pgsql-performance by date:

Previous
From: Sven Geisler
Date:
Subject: Re: loading increase into huge table with 50.000.000 records
Next
From: "Merlin Moncure"
Date:
Subject: Re: loading increase into huge table with 50.000.000 records