For the past few days, we've been seeing unexpected high CPU spikes in our
system. We observed the following:
- every single CPU spike was preceded by low 'free' memory even though
'cached' is quite high
- as soon as we shut down any of our applications which is occupying some
DB connections (e.g.
Please do not top-posts on these lists.
On Wednesday, June 4, 2014, Huang, Suya wrote:
> Thank you David, I copied the detailed activity from the report as below.
> As it shows, it has prepare and bind queries. One of the item has
> Bind/Prepare pretty high as 439.50. so that looks like a good
Thank you David, I copied the detailed activity from the report as below. As it
shows, it has prepare and bind queries. One of the item has Bind/Prepare
pretty high as 439.50. so that looks like a good value?
Another question is if bind only happens in a prepared statement?
Day HourP
Huang, Suya wrote
> Hello,
>
> I am using Pgbadger to analyze the postgresql database log recently and
> noticed a section "Prepared queries ratio". For my report, it has:
>
> 1.03 as Ratio of bind vs prepare
> 0.12% Ratio between prepared and "usual" statements
>
> I'm trying to understand what
Hello,
I am using Pgbadger to analyze the postgresql database log recently and noticed
a section "Prepared queries ratio". For my report, it has:
1.03 as Ratio of bind vs prepare
0.12% Ratio between prepared and "usual" statements
I'm trying to understand what the above metrics mean and if it's
For the past few days, we've been seeing unexpected extremely high CPU spikes
in our system. We observed the following: the 'free' memory would go down to
lower than 300 MB; at that point, 'cached' slowly starts to go down, and
then CPU starts to go way up.
It's almost as if the OS was not releas
On 04/06/14 22:57, Merlin Moncure wrote:
> On Wed, Jun 4, 2014 at 2:58 PM, Linos wrote:
>> On 04/06/14 21:36, Merlin Moncure wrote:
>>> On Wed, Jun 4, 2014 at 8:56 AM, Linos wrote:
Hello,
Some days ago I upgraded from 8.4 to 9.3, after the upgrade some queries
started perform
On Wed, Jun 4, 2014 at 2:58 PM, Linos wrote:
> On 04/06/14 21:36, Merlin Moncure wrote:
>> On Wed, Jun 4, 2014 at 8:56 AM, Linos wrote:
>>> Hello,
>>>
>>> Some days ago I upgraded from 8.4 to 9.3, after the upgrade some queries
>>> started performing a lot slower, the query I am using in this ex
On 04/06/14 21:36, Merlin Moncure wrote:
> On Wed, Jun 4, 2014 at 8:56 AM, Linos wrote:
>> Hello,
>>
>> Some days ago I upgraded from 8.4 to 9.3, after the upgrade some queries
>> started performing a lot slower, the query I am using in this example is
>> pasted here:
>>
>> http://pastebin.com/7
Evgeniy Shishkin wrote
> Hi,
>
> i just wanted to know if group commit (as described in
> https://wiki.postgresql.org/wiki/Group_commit ) was committed.
I guess that depends on whether this comment in the 9.2 release notes covers
the same material described in the linked wiki page (I would presu
On Wed, Jun 4, 2014 at 8:56 AM, Linos wrote:
> Hello,
>
> Some days ago I upgraded from 8.4 to 9.3, after the upgrade some queries
> started performing a lot slower, the query I am using in this example is
> pasted here:
>
> http://pastebin.com/71DjEC21
>
>
> Considering it is a production datab
Hi,
i just wanted to know if group commit (as described in
https://wiki.postgresql.org/wiki/Group_commit ) was committed.
And if parallel replication is going to be introduced.
Mysql 5.7 going to have intra-database parallel slave based on group commit on
master.
Hello,
Some days ago I upgraded from 8.4 to 9.3, after the upgrade some queries
started performing a lot slower, the query I am using in this example is pasted
here:
http://pastebin.com/71DjEC21
Considering it is a production database users are complaining because queries
are much slower tha
13 matches
Mail list logo
