On Wed, Sep 19, 2018 at 7:44 PM Cédric Villemain wrote:
> Le 19/09/2018 à 05:29, Thomas Munro a écrit :
> > On Wed, Sep 19, 2018 at 1:35 PM jimmy wrote:
> >> I use select pg_prewarm('table1','read','main') to load data of table1
> >> into the memory.
> >> when I use select count(1) from table1
Le 19/09/2018 à 05:29, Thomas Munro a écrit :
> On Wed, Sep 19, 2018 at 1:35 PM jimmy wrote:
>> I use select pg_prewarm('table1','read','main') to load data of table1 into
>> the memory.
>> when I use select count(1) from table1 group by aa to query data.
>> I find the speed of query is not fast
@Thomas, this tool looks very interesting!
@Jimmy:
Back to the question,you might approach the problem from a different
perspective..
If you run a query 2 consecutive times, from the secondon, you should be at
'full speed'.
Therefore if the first run takes X seconds but the consecutive runs t
On Wed, Sep 19, 2018 at 1:35 PM jimmy wrote:
> I use select pg_prewarm('table1','read','main') to load data of table1 into
> the memory.
> when I use select count(1) from table1 group by aa to query data.
> I find the speed of query is not fast, I wonder whether it query data from
> memory.
> A
