彭占元_个人页

没有场景谈tps都是耍流氓，这个还是自己测试的好

数据库重启了吧？

确实应该是huge_page参数导致的，官方手册里有详细描述huge_page的配置方法：Linux Huge Pages如果要开启这个参数，请参照这个方法

可以试一下pg_rewindpg_rewind -- synchronize a PostgreSQL data directory with another data directory that was forked from it但是分叉之后的数据就丢失了 被抹掉了

-- 有权限 zhanyuanpeng@zhanyuanpeng-HP-ProBook-430-G5:~$ psql -U test psql (10.5) Type 'help' for help. test=> \d List of relations Schema | Name | Type | Owner --------+------+-------+-------------- public | test | table | zhanyuanpeng (1 row) test=> \d test Table 'public.test' Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- id | integer | | | test=> \q # 移除权限 zhanyuanpeng@zhanyuanpeng-HP-ProBook-430-G5:~$ psql -d test psql (10.5) Type 'help' for help. test=# revoke ALL ON SCHEMA public from public; REVOKE test=# \q # 重新登录 zhanyuanpeng@zhanyuanpeng-HP-ProBook-430-G5:~$ psql -U test psql (10.5) Type 'help' for help. test=> \d Did not find any relations. test=>