Gakkiyomi 👋🏼

如果需要在同一个Spring Boot应用程序中同时使用PostgreSQL和Oracle数据库，你可以配置多个数据源来实现这一目标。 添加依赖 dependencies { implementation 'org.postgresql:postgresql:42.3.1' implementation 'com.oracle.database.jdbc:ojdbc8:19.3.0.0' //其他依赖项 } 配置文件 spring: primary: datasource: driver-class-name: org.postgresql.Driver jdbc-url: jdbc:postgresql://localhost:5432/nap username: xxx password: xxx test-on-borrow: true validationQuery: SELECT 1 name: HikariPool-1 minimum-idle: 15 maximum-pool-size: 30 idle-timeout: 600000....

查看数据量大的表 SELECT table_schema || '.' || table_name AS table_full_name, pg_size_pretty(pg_total_relation_size('"' || table_schema || '"."' || table_name || '"')) AS size FROM information_schema.tables ORDER BY pg_total_relation_size('"' || table_schema || '"."' || table_name || '"') DESC limit 100 查看数据量大的字段 select sum(pg_column_size(path_analyze_result)) as path, sum(pg_column_size(object_analyze_result)) as object, sum(pg_column_size(correlation_analyze_result)) as correlation from nap_pol....

关于 postgres 的一点记录