Could it be that your CPUs is warming and throttling? You didn't mention the
platform used, so I'm not sure whether it's a server or a laptop
Nicolas
Le 16 décembre 2019 21:50:17 GMT+01:00, Tom Lane a écrit :
>Peter Geoghegan writes:
>> Why do the first and the twentieth executions of the q
Le 07/07/2019 à 16:33, Thomas Kellerer a écrit :
Omar Roth schrieb am 07.07.2019 um 15:43:
Currently, the query I'm using to generate a user's feed is:
```
SELECT * FROM channel_videos WHERE ucid IN (SELECT
unnest(subscriptions) FROM
users WHERE email = $1) ORDER BY published DESC;
```
You
Le 29/01/2019 à 07:15, Saurabh Nanda a écrit :
c) I tried another cloud hosting provider (E2E Networks) and just
the raw performance numbers (with default configuration) are
blowing Hetzner out of the water.
I noticed that on E2E, the root filesystem is mounted with the
following
Le 28/01/2019 à 16:55, Saurabh Nanda a écrit :
You should probably include the detailed hardware you are working
on -
especially for the SSD, the model can have a big impact, as well
as its
wear.
What's the best tool to get meaningful information for SSD drives?
smartctl
Le 28/01/2019 à 15:03, Saurabh Nanda a écrit :
An update. It seems (to my untrained eye) that something is wrong with
the second SSD in the RAID configuration. Here's my question on
serverfault related to what I saw with iostat -
https://serverfault.com/questions/951096/difference-in-utilisatio
Le 18/07/2018 à 03:16, Neto pr a écrit :
2018-07-17 22:13 GMT-03:00 Neto pr :
2018-07-17 20:04 GMT-03:00 Mark Kirkwood :
Ok, so dropping the cache is good.
How are you ensuring that you have one test setup on the HDDs and one on the
SSDs? i.e do you have 2 postgres instances? or are you using
Le 17/07/2018 à 16:00, Neto pr a écrit :
2018-07-17 10:44 GMT-03:00 Nicolas Charles :
Hi Neto,
You should list the SSD model also - there are pleinty of Samsung EVO drives
- and they are not professional grade.
Among the the possible issues, the most likely (from my point of view) are
Le 17/07/2018 à 15:50, Robert Zenz a écrit :
On 17.07.2018 15:44, Nicolas Charles wrote:
- Partitions is not correctly aligned on the SSD blocks
Does that really make a noticeable difference? If yes, have you got some further
reading material on that?
I was pretty sure it was, but looking at
details on your system, we can only try to guess the
real issues
Nicolas
Nicolas CHARLES
Le 17/07/2018 à 15:19, Neto pr a écrit :
2018-07-17 10:04 GMT-03:00 Neto pr :
Sorry.. I replied in the wrong message before ...
follows my response.
-
Thanks all, but I still have not figured it
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
10 matches
Mail list logo
