It is kind of a purists fallacy. Point being if you could just write ASM
code it would be the best.
When in reality, a database is used not because it is the best technical
database, but is used by many people. Something that other developers can
pickup and use without reading a 200 page manual
I have been using pgx and seems to be working well.
I recommend if your just starting to use the v4 version.
On Tue, Aug 18, 2020 at 5:53 AM Stephen Frost wrote:
> Greetings,
>
> * Olivier Gautherot (ogauthe...@gautherot.net) wrote:
> > Le mar. 18 août 2020 à 09:36, Tony Shelver a écrit
> :
>
Also when you get in the multi TB data storage the bill gets a little
harder to digest in S3.
On Fri, May 15, 2020 at 11:49 Andreas 'ads' Scherbaum
wrote:
>
>
> On Fri, May 15, 2020 at 7:52 PM Ravi Krishna
> wrote:
>
>>
>> Why should the backup land in S3, and not local somewhere?
>> Any good
Hey,
So I finally found the culprit. Turns out to be the THP fighting with
itself.
After running on Ubuntu
echo never > /sys/kernel/mm/transparent_hugepage/enabled
echo never > /sys/kernel/mm/transparent_hugepage/defrag
It instantly went from a loadavg of 30 to 3
Also make sure you re-enable on
Alright will try the upgrade.
> Is it a few transactions updating a lot of rows each, or many transactions
> updating a few rows each?
It is a lot of transaction updating a few rows.
Then will look into a connection pooler.
Thanks for the response.
On Wed, Feb 27, 2019 at 2:01 PM Michael
Hi we are running a Postgresql Database 9.4.18 and we are noticing a
high CPU usage. Nothing is critical at the moment but if we were to
scale up more of what we are doing, I feel we are going to run into
issues.
It is a 2 x 6 core machine, 128GB ram, Raid 10 HDD
The iostat metrics for the HDD
Also leading wildcards can inhibit the use of indexes. Best to try to avoid
LIKE queries similar to '%TERM'
On Mon, Oct 22, 2018 at 12:23 AM Alban Hertroys wrote:
>
>
> > On 22 Oct 2018, at 7:56, aman gupta wrote:
> >
> > Issue:
> >
> > We have the base table which contains 22M records and we
