On Tue, Sep 30, 2008 at 4:02 PM, Martijn van Oosterhout
<[EMAIL PROTECTED]> wrote:
> On Tue, Sep 30, 2008 at 03:51:44PM +0200, Denis Gasparin wrote:
>> It seems like postgres or the operating system (linux) is keeping in
>> cache that old data even if it has been deleted.
>
> Just remember: "free m
On Tue, Sep 30, 2008 at 03:51:44PM +0200, Denis Gasparin wrote:
> It seems like postgres or the operating system (linux) is keeping in
> cache that old data even if it has been deleted.
Just remember: "free memory" is "memory you paid for and are not
using" == "wasted memory". The OS knows damn we
If its the OS cache the kernel ought to free the memory when there is
something else worth caching. Its not a big deal if the cache is full so
long as the system still performs well.
On Tue, Sep 30, 2008 at 9:51 AM, Denis Gasparin <[EMAIL PROTECTED]> wrote:
> Tom Lane ha scritto:
> > Denis Gaspa
On Tue, Sep 30, 2008 at 7:51 AM, Denis Gasparin <[EMAIL PROTECTED]> wrote:
> Tom Lane ha scritto:
>> Denis Gasparin <[EMAIL PROTECTED]> writes:
>>
>>> I'm evaluating to issue the drop_caches kernel command (echo 3 >
>>> /proc/sys/vm/drop_caches) in order to free unused pagecache, directory
>>> entr
Tom Lane ha scritto:
> Denis Gasparin <[EMAIL PROTECTED]> writes:
>
>> I'm evaluating to issue the drop_caches kernel command (echo 3 >
>> /proc/sys/vm/drop_caches) in order to free unused pagecache, directory
>> entries and inodes.
>>
>
> Why in the world would you think that's a good idea
Denis Gasparin <[EMAIL PROTECTED]> writes:
> I'm evaluating to issue the drop_caches kernel command (echo 3 >
> /proc/sys/vm/drop_caches) in order to free unused pagecache, directory
> entries and inodes.
Why in the world would you think that's a good idea?
regards, tom la
On Tue, Sep 30, 2008 at 3:33 AM, Denis Gasparin <[EMAIL PROTECTED]> wrote:
> Hi.
>
> I'm evaluating to issue the drop_caches kernel command (echo 3 >
> /proc/sys/vm/drop_caches) in order to free unused pagecache, directory
> entries and inodes.
>
> I'm thinking to schedule the command during low lo
Hi.
I'm evaluating to issue the drop_caches kernel command (echo 3 >
/proc/sys/vm/drop_caches) in order to free unused pagecache, directory
entries and inodes.
I'm thinking to schedule the command during low load moments after
forcing a sync command.
I wonder if this can cause pgsql problems of
