Re: Postgres tuning?

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;