Postgres tuning?

Поиск
Список
Период
Сортировка
От Simon Windsor
Тема Postgres tuning?
Дата
Msg-id 1088544650.7811.60.camel@celt.cornfield.org.uk
обсуждение исходный текст
Ответы Re: Postgres tuning?  ("Scott Marlowe" <smarlowe@qwest.net>)
Re: Postgres tuning?  (<wespvp@syntegra.com>)
Re: Postgres tuning?  (Paul Thomas <paul@tmsl.demon.co.uk>)
Список 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 по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Can I interrupt queries already processing in the server?
Следующее
От: Stan Y
Дата:
Сообщение: What is the prevalent naming convention in RDBMS?