Re: [Firebird-devel] Meltdown and Spectre

Anything doing a lot of user-mode to kernel-mode transitions is affected the most. That's why i.e. IO intensive code suffers more than just computations. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ On Wed, Jan 10, 2018, at 17:47, Carlos H. Cantu wrote: > I saw a performance comparison

Re: [Firebird-devel] Meltdown and Spectre

I saw a performance comparison (using comercial benchmarks tools, not specific for databases) and the most impact seems to be on Disk (even SSD), followed by RAM and CPU. The only area that isn't impacted seems to be GPU. []s Carlos http://www.firebirdnews.org FireBase -

Re: [Firebird-devel] Meltdown and Spectre

10.01.2018 18:43, Leyne, Sean пишет: Tests are different, so results cannot be compared "as is". I appreciate that the tests are different, I was commenting on the relative performance impact. Slowdown mostly depends on % of syscalls. R/O vs R/W tests would show different relative impact

Re: [Firebird-devel] Meltdown and Spectre

10.01.2018 18:25, Leyne, Sean wrote: It is most interesting that FB's post-patch numbers show a much larger impact (~36% slower) than the Postgres results (~24%). Tests are different, so results cannot be compared "as is". Dmitry

Re: [Firebird-devel] Meltdown and Spectre

András, > -Original Message- > From: Omacht András [mailto:aoma...@mve.hu] > Sent: Wednesday, January 10, 2018 9:08 AM > finally we choose the easiest way, backup the system and update it to > Debian SID. > > # uname -a > Linux firebirdtest 4.14.0-3-amd64 #1 SMP Debian 4.14.12-2

Re: [Firebird-devel] Meltdown and Spectre

age was checked by ESET Mail Security. http://www.eset.com __ Information from ESET Mail Security, version of virus signature database 16713 (20180110) __ The message was checked by ESET Mail Security. http://www.eset.com --

Re: [Firebird-devel] Meltdown and Spectre

Here are a few details on Linux related distros https://lwn.net/Articles/742999/ Also Intel already prepared microcode patches and they push it trough OS update channels https://hothardware.com/news/microsoft-windows-10-pcs-haswell-intel-cpus-significant-slowdowns-post-spectre-patch On Tue,

Re: [Firebird-devel] Meltdown and Spectre

> The performance impact of the recent fixes hinge, mainly, on whether > the host OS/kernel has PCID support. First of all, the CPU must support PCID. > PCID support was only added to linux kernel 4.14, released November > 2017. ... and only to recent CPUs. Michal Kubecek

Re: [Firebird-devel] where is ':' valid in Firebird SQL?

On Wed, 3 Jan 2018 22:45:30 +0100, Lionel Elie Mamane wrote: > On Wed, Jan 03, 2018 at 06:57:21AM +0100, Lionel Elie Mamane wrote: > > Thanks everybody for your help. I see my idea was not realistic. After > sleeping on it, I realised I could reengineer some part of LibreOffice