Re: impact of stats_command_string - Mailing list pgsql-performance

From Michael Fuhr
Subject Re: impact of stats_command_string
Date
Msg-id 20051025160408.GA53661@winnie.fuhr.org
Whole thread Raw
In response to impact of stats_command_string  (jnevans@gmail.com)
List pgsql-performance
On Thu, Oct 20, 2005 at 01:33:07PM -0700, jnevans@gmail.com wrote:
> If I turn on stats_command_string, how much impact would it have on
> PostgreSQL server's performance during a period of massive data
> INSERTs?

Do you really need to be doing "massive data INSERTs"?  Can you use
COPY, which is much more efficient for bulk loads?

http://www.postgresql.org/docs/8.0/interactive/populate.html

--
Michael Fuhr

pgsql-performance by date:

Previous
From: Rodrigo Madera
Date:
Subject: Re: Inefficient escape codes.
Next
From: "Merlin Moncure"
Date:
Subject: Re: impact of stats_command_string