Skip site navigation (1) Skip section navigation (2)

Re: Postgres tuning?

From: "Scott Marlowe" <smarlowe(at)qwest(dot)net>
To: "Simon Windsor" <simon(dot)windsor(at)cornfield(dot)org(dot)uk>
Cc: "Postgres List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgres tuning?
Date: 2004-06-29 22:33:48
Message-ID: 1088548428.12350.41.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-general
On Tue, 2004-06-29 at 15:30, Simon Windsor wrote:
> Hi
> 
> I am in the process of converting a small multi-user application from
> MySQL, and most queries are performing better. The only noticeable
> exception is a batch load, which is half the speed of MySQL version.
> 
> What are the basic parameters I should be focusing on for best
> performance ?
> 
> - sort_mem
> - shared_buffers

How does the batch insert work?  Just one insert after another?  Try
wrapping them in a transaction:

begin;
insert into ... (repeat a few thousand to million times)
commit;


In response to

pgsql-general by date

Next:From: Paul ThomasDate: 2004-06-29 23:01:47
Subject: Re: Postgres tuning?
Previous:From: Stan YDate: 2004-06-29 22:09:19
Subject: What is the prevalent naming convention in RDBMS?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group