Dror Matalon wrote:
Let me try and say it again. I know that setting effective_cache_size
doesn't affect the OS' cache. I know it just gives Postgres the *idea*
of how much cache the OS is using. I know that. I also know that a
correct hint helps performance.
I've read Matt Dillon's discussion abo
On Thursday 26 February 2004 13:30, David Pradier wrote:
> Hi everybody,
>
> i'd like to know if it exists a system of cache for the results of
> queries.
>
> What i'd like to do :
>
> select whatever_things from (selection_in_cache) where special_conditions;
>
> The interesting thing would be to h
Hi everybody,
i'd like to know if it exists a system of cache for the results of
queries.
What i'd like to do :
select whatever_things from (selection_in_cache) where special_conditions;
The interesting thing would be to have a precalculated
selection_in_cache, especially when selection_in_cach
Hi,
We have postgres running on freebsd 4.9 with 2 Gigs of memory. As per
repeated advice on the mailing lists we configured effective_cache_size
= 25520 which you get by doing `sysctl -n vfs.hibufspace` / 8192
Which results in using 200Megs for disk caching.
Is there a reason not to increase t
On Fri, Feb 27, 2004 at 05:47:47AM +0800, Christopher Kings-Lynne wrote:
> > We have postgres running on freebsd 4.9 with 2 Gigs of memory. As per
> > repeated advice on the mailing lists we configured effective_cache_size
> > = 25520 which you get by doing `sysctl -n vfs.hibufspace` / 8192
> >
> >
> We have postgres running on freebsd 4.9 with 2 Gigs of memory. As per
> repeated advice on the mailing lists we configured effective_cache_size
> = 25520 which you get by doing `sysctl -n vfs.hibufspace` / 8192
>
> Which results in using 200Megs for disk caching.
effective_cache_size does nothin
David Pradier wrote:
i'd like to know if it exists a system of cache for the results of
queries.
If you are willing to do this at an application level, you could
calculate a MD5 for every query you plan to run and then SELECT INTO a
temporary table that's based on the MD5 sum (e.g. TMP_CACHE_4512
On Thu, 26 Feb 2004, Dror Matalon wrote:
> On Thu, Feb 26, 2004 at 11:55:31AM -0700, scott.marlowe wrote:
> > On Thu, 26 Feb 2004, Dror Matalon wrote:
> >
> > > Hi,
> > >
> > > We have postgres running on freebsd 4.9 with 2 Gigs of memory. As per
> > > repeated advice on the mailing lists we con
I sent this to the admin list the other day and got no responses. Maybe this
list can give me some pointers.
Hello
I am working on installing and configuring a Postgres database
server. I am running Redhat Enterprise ES 3.0 and Redhat Database 3.0.
"Postgres version 7.3.4-11". This server
On Thu, 26 Feb 2004, David Pradier wrote:
> Hi everybody,
>
> i'd like to know if it exists a system of cache for the results of
> queries.
I believe there are some external libs that provide this at the
application level. PHP's adodb is purported to do so.
---(end of
Thanks for the pointer. So
maxbufspace = nbuf * BKVASIZE;
Which is confirmed in
http://unix.derkeiler.com/Mailing-Lists/FreeBSD/performance/2003-09/0045.html
and it looks like there's a patch by Sean Chittenden at
http://people.freebsd.org/~seanc/patches/patch-HEAD-kern.nbuf
that does what I
John,
> and Postgres server runtime parameters and other settings relating to
> tuning. Also is there any benchmarking tools available that will help me
> tune this server.
Check out
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
Also, I'd like to see what you get under heavy load
On Thu, Feb 26, 2004 at 11:55:31AM -0700, scott.marlowe wrote:
> On Thu, 26 Feb 2004, Dror Matalon wrote:
>
> > Hi,
> >
> > We have postgres running on freebsd 4.9 with 2 Gigs of memory. As per
> > repeated advice on the mailing lists we configured effective_cache_size
> > = 25520 which you get b
On 26 Feb 2004 at 13:58, Dror Matalon wrote:
>
> which brings me back to my question why not make Freebsd use more of its
> memory for disk caching and then tell postgres about it.
>
I think there is some confusion about maxbufsize and hibufspace. I looking at a
comment in the FreeBSB s
Josh Berkus wrote:
John,
and Postgres server runtime parameters and other settings relating to
tuning. Also is there any benchmarking tools available that will help me
tune this server.
Check out
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
Also, I'd like to see what you
On Thu, 26 Feb 2004, Dror Matalon wrote:
> Hi,
>
> We have postgres running on freebsd 4.9 with 2 Gigs of memory. As per
> repeated advice on the mailing lists we configured effective_cache_size
> = 25520 which you get by doing `sysctl -n vfs.hibufspace` / 8192
>
> Which results in using 200Megs
16 matches
Mail list logo