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
What would be the best filesystem to run PostgreSQL on, in Terms of Performance
and data Integrity?
Best regards,
stephan
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
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.
