Postgres Pro
Downloads
Home   >   mailing lists

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?  ("Scott Marlowe" <smarlowe@qwest.net>)
Re: Postgres tuning?  (<wespvp@syntegra.com>)
Re: Postgres tuning?  (Paul Thomas <paul@tmsl.demon.co.uk>)
List pgsql-general
Tree view 
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?