Re: Where **not** to use PostgreSQL? - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Where **not** to use PostgreSQL?
Date
Msg-id 7d39e5cf-95d2-2101-9a2d-aa31e48f2494@gmx.net
Whole thread Raw
In response to Where **not** to use PostgreSQL?  (Thomas Güttler <guettliml@thomas-guettler.de>)
List pgsql-general
Thomas Güttler schrieb am 28.02.2019 um 12:47:
> where would you suggest someone to **not** use PostgreSQL?
> 
> Why would you do this?
> 
> What alternative would you suggest instead?

Due to the MVCC implementation, I would hesitate to use Postgres in environments that have an extremely high and
constantrate of DELETE an UPDATE statements, e.g. several thousands or even tens of thousands transactions per second
withoutany "quiet" times where vacuum could "catch up" clean out dead tuples. 
 

Tuning autovacuum to cope with that is very challenging 
(at least until the new UNDO log implementation is ready ;) 






pgsql-general by date:

Previous
From: Perumal Raj
Date:
Subject: Re: Question about pg_upgrade from 9.2 to X.X
Next
From: Nicola Contu
Date:
Subject: Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2