> On Sep 13, 2020, at 23:09, Matthias Apitz wrote:
> Why a SELECT COUNT(*) of the
> full table takes around 1 minute:
There's an explanation here:
https://wiki.postgresql.org/wiki/Slow_Counting
--
-- Christophe Pettus
x...@thebuild.com
Hello,
I've setup a relatively big database on RH 8.2 with PG 11.4. The table
in question has aroung 38 millions of rows. Why a SELECT COUNT(*) of the
full table takes around 1 minute:
# date ; printf "select count(*) from d01buch ;\n" |
/usr/local/sisis-pap/pgsql/bin/psql -Usisis -dsisis ; da
Hi Team,
I have the postgresql database with 11.4 Version in AWS RDS. Some of the
columns have lattin collate format. I need to migrate the database to Azure
postgresql and need to convert UTF8 column format.
How to find which columns are in Latin format. How to convert the data and
columns to UTF
On Sun, 2020-09-13 at 13:49 +0200, Mike Noordermeer wrote:
> Hi,
>
> I am currently working on a data sync solution, where data is synced
> from external systems to Postgres. As I do not know what data changed
> in the source data store, I have opted for the following flow:
>
> - Load all data in
Hi,
I am currently working on a data sync solution, where data is synced
from external systems to Postgres. As I do not know what data changed
in the source data store, I have opted for the following flow:
- Load all data in a temp table
- Update existing rows main table based on contents of temp
Thank you!
