But I use windows server 2012R.
pgfincore can not run on the windows.
Is there some replacements in windows system?
At 2018-09-19 15:44:06, "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(
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
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.
And it is slower than Oracle, both of Oracle and Postgresql
