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
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 |