[PERFORM] Memory question on win32 systems

------=_Part_26075_5744849.1212049570475
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On Thu, May 29, 2008 at 2:11 AM, Douglas McNaught <doug@[EMAIL PROTECTED]
>
wrote:

> On Wed, May 28, 2008 at 7:05 PM, Sabbiolina <sabbiolina@[EMAIL PROTECTED]
>
wrote:
> > Hello, in my particular case I need to configure Postgres to handle
only
> a
> > few concurrent connections, but I need it to be blazingly fast, so I
need
> it
> > to cache everything possible. I've changed the config file and
multiplied
> > all memory-related values by 10, still Postgres uses only less than 50
Mb
> of
> > my RAM.
>
> How are you measuring this?


Task Manager


>
> > I have 4 Gigs of RAM, how do I force Postgres to use a higher part of
> such
> > memory in order to cache more indexes, queries and so on?
>
> Post the settings values you're using and people will be better able
> to help you.
>
> -Doug
>



config:
****t = 5432                # (change requires restart)
max_connections = 50                    # (change requires restart)

shared_buffers = 320MB            # min 128kB or max_connections*16kB
temp_buffers = 80MB            # min 800kB
max_prepared_transactions = 10        # can be 0 or more
work_mem = 10MB                # min 64kB
maintenance_work_mem = 160MB        # min 1MB
Max_stack_depth = 20MB            # min 100kB
max_fsm_pages = 2048000            # min max_fsm_relations*16, 6 bytes
each
max_fsm_relations = 10000        # min 100, ~70 bytes each
shared_preload_libraries = '$libdir/plugins/plugin _debugger.dll'        #
(change requires restart)
wal_buffers = 640kB            # min 32kB

log_destination = 'stderr'        # Valid values are combinations of
logging_collector = on        # Enable capturing of stderr and csvlog
log_line_prefix = '%t '            # special values:

datestyle = 'iso, dmy'
lc_messages = 'Italian_Italy.1252'            # locale for system error
message
lc_monetary = 'Italian_Italy.1252'            # locale for monetary
formatting
lc_numeric = 'Italian_Italy.1252'            # locale for number
formatting
lc_time = 'Italian_Italy.1252'                # locale for time formatting
default_text_search_config = 'pg_catalog.italian'

------=_Part_26075_5744849.1212049570475
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div class="gmail_quote"><div>On Thu, May 29, 2008 at 2:11 AM, Douglas
McNaught &lt;<a href="mailto:doug@[EMAIL PROTECTED]
"
target="_blank">doug@[EMAIL PROTECTED]
>&gt; wrote:<br><blockquote
class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204);
margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">


<div>On Wed, May 28, 2008 at 7:05 PM, Sabbiolina &lt;<a
href="mailto:sabbiolina@[EMAIL PROTECTED]
"
target="_blank">sabbiolina@[EMAIL PROTECTED]
>&gt; wrote:<br>
&gt; Hello, in my particular case I need to configure Postgres to handle
only a<br>
&gt; few concurrent connections, but I need it to be blazingly fast, so I
need it<br>
&gt; to cache everything possible. I&#39;ve changed the config file and
multiplied<br>
&gt; all memory-related values by 10, still Postgres uses only less than
50 Mb of<br>
&gt; my RAM.<br>
<br>
</div>How are you measuring this?</blockquote></div><div><br>Task Manager
<br><br></div><div><blockquote class="gmail_quote" style="border-left: 1px
solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">

<br>
<div><br>
&gt; I have 4 Gigs of RAM, how do I force Postgres to use a higher part of
such<br>
&gt; memory in order to cache more indexes, queries and so on?<br>
<br>
</div>Post the settings values you&#39;re using and people will be better
able<br>
to help you.<br>
<br>
-Doug<br>
</blockquote></div></div><br><br><br>config:<br>****t =
5432&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; # (change requires restart)<br>max_connections =
50&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
# (change requires restart)<br><br>shared_buffers = 320MB&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; # min 128kB or
max_connections*16kB<br>


temp_buffers = 80MB&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; # min 800kB<br>max_prepared_transactions =
10&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; # can be 0 or more<br>work_mem =
10MB&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; # min 64kB<br>maintenance_work_mem =
160MB&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; # min 1MB<br>Max_stack_depth =
20MB&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; # min
100kB<br>


max_fsm_pages = 2048000&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; # min max_fsm_relations*16, 6 bytes
each<br>max_fsm_relations = 10000&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; #
min 100, ~70 bytes each<br>shared_preload_libraries =
&#39;$libdir/plugins/plugin<div>
_debugger.dll&#39;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; # (change requires
restart)<br>
wal_buffers = 640kB&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; # min 32kB<br><br>log_destination =
&#39;stderr&#39;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; # Valid values are
combinations of<br>logging_collector = on&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; # Enable capturing of stderr and
csvlog<br>log_line_prefix = &#39;%t &#39;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; # special values:<br>


<br>datestyle = &#39;iso, dmy&#39;<br>lc_messages =
&#39;Italian_Italy.1252&#39;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; # locale for system error message<br>lc_monetary =
&#39;Italian_Italy.1252&#39;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; # locale for monetary formatting<br>lc_numeric =
&#39;Italian_Italy.1252&#39;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; # locale for number formatting<br>


lc_time = &#39;Italian_Italy.1252&#39;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; # locale for time
formatting<br>default_text_search_config =
&#39;pg_catalog.italian&#39;</div>

------=_Part_26075_5744849.1212049570475--