Apollon

Hey guys...need help. Running PostgreSQL 11 with postgis on a server with 100 gb ram and two tablespaces. The default one is on system ssd. The working tablespace (also temp_t...

HELP: Quick questeion: my table is 100 GB+. I want to to some group by and save the result as a new table. Query fills my memory (ram) and my swap and than fails. is this a no...

i am already connected to the database...i can run it there?

I will see temp logs in PostgreSQL-11-main.log?

\set VERBOSITY verbose and then the query?

Nice source...but what to do know?