Postgres tuning? - Mailing list pgsql-general

From Simon Windsor
Subject Postgres tuning?
Date
Msg-id 1088544650.7811.60.camel@celt.cornfield.org.uk
Whole thread Raw
Responses Re: Postgres tuning?
Re: Postgres tuning?
Re: Postgres tuning?
List pgsql-general
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

Many thanks

Simon

--
Simon Windsor
Email: simon.windsor@cornfield.org.uk
Tel: 01454 617689
Mob: 07960 321599


--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
Mailscanner thanks transtec Computers for their support.


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Can I interrupt queries already processing in the server?
Next
From: Stan Y
Date:
Subject: What is the prevalent naming convention in RDBMS?