| From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: about effective_cache_size |
| Date: | 2010-02-18 08:47:18 |
| Message-ID: | 20100218084718.GC23676@a-kretschmer.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
In response to AI Rumman :
> * What is the difference between shared_buffers and effective_cache_size?
effective_cache_size:
Sets the planner's assumption about the effective size of the disk cache
that is available to a single query. This parameter has no effect on the
size of shared memory allocated by PostgreSQL, nor does it reserve
kernel disk cache; it is used only for estimation purposes.
shared_buffers:
Sets the amount of memory the database server uses for shared memory
buffers.
It's all copied from the doc, there are much more details about this
parameters. Read the doc!
Regards, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99
| From | Date | Subject | |
|---|---|---|---|
| Next Message | dipti shah | 2010-02-18 08:53:20 | Define permissions at database level |
| Previous Message | Jayadevan M | 2010-02-18 08:10:22 | Re: One solution for Packages in Postgre |