impact of auto explain on overall performance

Hello, i’m currently working on a high Performance Database and want to make sure that whenever there are slow queries during regular operations i’ve got all Information about the query in my logs. So auto_explain come to mind, but the documentation explicitly states that it Comes at a cost. My

AW: Performance issue with order by clause on

Have you tried creating an sorted index like CREATE INDEX table_modificationtime_idx ON “TABLE“ USING btree(modificationtime DESC) WHERE (enabled=1)? Best Regards Stephan Von: Corey Huinker Gesendet: Mittwoch, 20. März 2019 18:34 An: Maracska Ádám

endless quere when upsert with ON CONFLICT clause

PostgreSQL version: 11.2 Operating system: Linux Description: We have a wuite complex CTE which collects data fast enough for us and has a ok execution plan. When we insert the result into a table like With _some_data AS ( SELECT…. ), _some_other_data AS ( SELECT …. ) INSERT INTO table1

Best Filesystem for PostgreSQL

What would be the best filesystem to run PostgreSQL on, in Terms of Performance and data Integrity? Best regards, stephan

AW: Best Filesystem for PostgreSQL

my Question was meant for a Debian 9 environment with heavy read/wright load and very high requirements towards Performance and data Consistency Stephan Von: Bruce Momjian Gesendet: Wednesday, April 17, 2019 11:07:21 PM An: Stephan Schmidt Cc: pgsql