pgsql中有一个表原来有1千6百万条数据,查询该表很慢, 就把他给清空了,可是查询还是很慢 使用 select count(1) from table_name ; 耗时260秒后,返回0。 这个怎么回事?
postgres@mars0808:/usr/local/pgsql/bin$ initdb The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with locale en_US.UTF-8. The default database encoding has accordingly been set to UTF8. initdb: directory "/usr/local/pgsql/data" exists but is not empty If you want to create a new datab...