Le 12 décembre 2011 01:42, Stefan Keller a écrit :
> I'd like to clear the PostgreSQL cache (e.g. for benchmarking purposes).
> And I'd like to preload all tuples of a table (say mytable_one) into the
> cache.
>
> AFAIK there is no way to force all caches to be cleared in PostgreSQL
> with an SQL
On Mon, Dec 12, 2011 at 8:33 AM, Craig Ringer wrote:
> On 12/12/2011 08:42 AM, Stefan Keller wrote:
>
>> I'd like to clear the PostgreSQL cache (e.g. for benchmarking purposes).
>> And I'd like to preload all tuples of a table (say mytable_one) into the
>> cache.
>>
>> AFAIK there is no way to fo
On 12/12/2011 08:42 AM, Stefan Keller wrote:
I'd like to clear the PostgreSQL cache (e.g. for benchmarking purposes).
And I'd like to preload all tuples of a table (say mytable_one) into the cache.
AFAIK there is no way to force all caches to be cleared in PostgreSQL
with an SQL command.
The onl
I'd like to clear the PostgreSQL cache (e.g. for benchmarking purposes).
And I'd like to preload all tuples of a table (say mytable_one) into the cache.
AFAIK there is no way to force all caches to be cleared in PostgreSQL
with an SQL command.
The only way to achieve this, seems to restart PG (ser
