Basic configuration advices - Mailing list pgsql-novice

From VizjereX
Subject Basic configuration advices
Date
Msg-id 1303809192006-4340447.post@n5.nabble.com
Whole thread Raw
List 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 by date:

Previous
From: Chetan Suttraway
Date:
Subject: Re: Advise with a select statement
Next
From: JORGE MALDONADO
Date:
Subject: Getting null values in an update statement