| From: | Simon Windsor <simon(dot)windsor(at)cornfield(dot)org(dot)uk> |
|---|---|
| To: | Postgres List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Postgres tuning? |
| Date: | 2004-06-29 21:30:51 |
| Message-ID: | 1088544650.7811.60.camel@celt.cornfield.org.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)windsor(at)cornfield(dot)org(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2004-06-29 21:36:11 | Re: Can I interrupt queries already processing in the server? |
| Previous Message | Eric Wright | 2004-06-29 20:39:03 | postgresql install: jdbc: No such file or directory. |