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 r
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 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 c
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 lo
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 Lewis
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
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 an
