Re: Inserts get slower as table gets bigger - Mailing list pgsql-general

From Tom Lane
Subject Re: Inserts get slower as table gets bigger
Date
Msg-id 722.1080354981@sss.pgh.pa.us
Whole thread Raw
In response to Inserts get slower as table gets bigger  (Jack Orenstein <jorenstein@archivas.com>)
List pgsql-general
Jack Orenstein <jorenstein@archivas.com> writes:
> Is this expected behavior? Is there something I need to tune to avoid
> this problem? I've left postgresql.conf alone, except for sort_mem (8
> meg).

The default shared_buffers in pre-7.4 releases is too small for any but
tiny databases.  Try putting it up to 1000 or more buffers.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problem with memory in C function
Next
From: Tom Lane
Date:
Subject: Re: License on PostgreSQL