--On Mittwoch, August 24, 2005 16:26:40 -0400 Chris Hoover
<[EMAIL PROTECTED]> wrote:
On 8/24/05, Merlin Moncure <[EMAIL PROTECTED]> wrote:
Linux does a pretty good job of deciding what to cache. I don't think
this will help much. You can always look at partial indexes too.
Yes, but won't
On 8/24/05, Merlin Moncure <[EMAIL PROTECTED]> wrote:
> > Ok, there is always a lot of talk about tuning PostgreSQL on linux and
> > how PostgreSQL uses the linux kernel cache to cache the tables and
> > indexes.
> [...]
> >
> > 1. Implement a partition type layout using views and rules - This
> >
"Merlin Moncure" <[EMAIL PROTECTED]> writes:
>> Right now, we are still on 7.3.4. However, these ideas would be
>> implemented as part of an upgrade to 8.x (plus, we'll initialize the
>> new clusters with a C locale).
> yes, do this!
Moving from 7.3 to 8.0 is alone likely to give you a noticeabl
On Wed, Aug 24, 2005 at 12:56:54PM -0400, Chris Hoover wrote:
> I don't have real numbers to give you, but we know that our systems
> are hurting i/o wise and we are growing by about 2GB+ per week (net).
> We actually grow by about 5GB/week/server. However, when I run my
> weekly maintenance of
> Ok, there is always a lot of talk about tuning PostgreSQL on linux and
> how PostgreSQL uses the linux kernel cache to cache the tables and
> indexes.
[...]
>
> 1. Implement a partition type layout using views and rules - This
> will allow me to have one table in each view with the "active" dat
Ok, there is always a lot of talk about tuning PostgreSQL on linux and
how PostgreSQL uses the linux kernel cache to cache the tables and
indexes.
My question is, is there anyway to see what files linux is caching at
this moment?
My reasoning behind this question is:
I have several database syst
