Basic configuration advices

Поиск
Список
Период
Сортировка
От VizjereX
Тема Basic configuration advices
Дата
Msg-id 1303809192006-4340447.post@n5.nabble.com
обсуждение исходный текст
Список pgsql-novice
Hello!
We are using PostgreSQL as a data storage for C++ application. We are using
full-text search within Postgre and trying to reduce search time. I am a
novice in configuring Postgre and wanna ask you for help.

We've got single server with 24GB RAM (approx. 8GB for PostgreSQL, rest for
our another applications) and standard configuration, trying only to change:

shared_buffers = 24MB
temp_buffers = 8MB

May I ask you for some advices in configuration? Search using indexes is OK,
but fulltext is soooo sloooooowwwww...



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Basic-configuration-advices-tp4340447p4340447.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.

В списке pgsql-novice по дате отправления:

Предыдущее
От: Chetan Suttraway
Дата:
Сообщение: Re: Advise with a select statement
Следующее
От: JORGE MALDONADO
Дата:
Сообщение: Getting null values in an update statement