Re: Mnogosearch (Was: Re: website doc search is ... )

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Mnogosearch (Was: Re: website doc search is ... )
Date: 2004-01-02 17:35:40
Message-ID: 3FF5ABEC.6050108@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


>
>Note that I haven't made many changes to the postgresql.conf file, so
>there might be something really obvious I've overlooked, but here are the
>uncommented ones (ie. ones I've modified from defaults):
>
>tcpip_socket = true
>max_connections = 512
>shared_buffers = 10000 # min 16, at least max_connections*2, 8KB each
>sort_mem = 10240 # min 64, size in KB
>vacuum_mem = 81920 # min 1024, size in KB
>
>

what about effective_cache_size and random_page_cost?

Sincerely,

Joshua D. Drake

>syslog = 2 # range 0-2; 0=stdout; 1=both; 2=syslog
>syslog_facility = 'LOCAL0'
>syslog_ident = 'postgres'
>log_connections = true
>log_duration = false
>log_statement = false
>lc_messages = 'C' # locale for system error message strings
>lc_monetary = 'C' # locale for monetary formatting
>lc_numeric = 'C' # locale for number formatting
>lc_time = 'C' # locale for time formatting
>
>
>----
>Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
>Email: scrappy(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-222-2783 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
Editor-N-Chief - PostgreSQl.Org - http://www.postgresql.org

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2004-01-02 18:00:09 Re: Bug and/or feature? Complex data types in tables...
Previous Message Dave Page 2004-01-02 17:11:27 Re: [webmaster] website doc search is extremely SLOW