Re: ayuda- memoria-utiliza-postgresql

On Tue, Aug 31, 2004 at 03:44:31PM -0500, tgutierrez(at)unipamplona(dot)edu(dot)co wrote:

> name | setting | context | vartype | source | min_val | max_val
> ----------------------+---------+---------+---------+---------+---------+--------------
> effective_cache_size | 1000 | user | real | default | 0 | 1.79769e+308
> (1 fila)
>
> el valor de setting es en kB, B o en MB?
> y en ese campo coloco los 700 MB?

Que tal si lees la documentacion relevante? Es bastante explicita.

effective_cache_size (floating point)
Sets the planner's assumption about the effective size of
the disk cache (that is, the portion of the kernel's disk cache that
will be used for PostgreSQL data files). This is measured in disk pages,
which are normally 8192 bytes each. The default is 1000.

Tambien tienes que dejar memoria para shared_buffers, sort_mem y
vacuum_mem. Y obviamente tambien para el resto de los procesos y el
kernel ...

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Un poeta es un mundo encerrado en un hombre" (Victor Hugo)