Hello,
FWIW, I do have the same issue.
Unfortunately our application is running on a standard laptop/desktop
computers, not dedicated servers.
Restarting the computer leads to a restart of the database server, which slow
down all queries for several minutes.
Are you on Windows or Linux?
On Fri, Jan 12, 2018 at 12:03 AM, Nandakumar M wrote:
> Hello Jeff,
>
> Thanks for the insights.
>
> >Don't keep closing and reopening connections.
>
> Even if I close a connection and open a new one and execute the same
> query, the planning time is considerably less than the first time. Only
>
On 16/01/18 23:14, Neto pr wrote:
2018-01-15 20:04 GMT-08:00 Mark Kirkwood :
On 16/01/18 13:18, Fernando Hevia wrote:
The 6 Gb/s interface is capable of a maximum throughput of around 600
Mb/s. None of your drives can achieve that so I don't think you are limited
to the interface speed. Th
Le 16/01/2018 à 11:14, Neto pr a écrit :
2018-01-15 20:04 GMT-08:00 Mark Kirkwood :
On 16/01/18 13:18, Fernando Hevia wrote:
The 6 Gb/s interface is capable of a maximum throughput of around 600
Mb/s. None of your drives can achieve that so I don't think you are limited
to the interface spee
Nandakumar M schrieb am 12.01.2018 um 09:03:
> Even if I close a connection and open a new one and execute the same
> query, the planning time is considerably less than the first time.
> Only when I restart the Postgres server then I face high planning
> time again.
Yes, because the data is cached
Missed to have mailing list in to address.. forwarding now.
-- Forwarded message --
From: "Nandakumar M"
Date: 15 Jan 2018 12:16
Subject: Re: Query is slow when run for first time; subsequent execution is
fast
To: "Pavel Stehule"
Cc:
Hi,
On Fri, Jan 12, 2018 at 3:34 PM, Pavel S
2018-01-15 20:04 GMT-08:00 Mark Kirkwood :
> On 16/01/18 13:18, Fernando Hevia wrote:
>
>>
>>
>>
>> The 6 Gb/s interface is capable of a maximum throughput of around 600
>> Mb/s. None of your drives can achieve that so I don't think you are limited
>> to the interface speed. The 12 Gb/s interface s
