Gan Jiadong <ga...@huawei.com> writes: > we have PG 8.3.13 in our system. When running performance cases, we find the > startup recovery cost about 3 minutes. It is too long in our system.
Maybe you should rethink the assumption that dropping 40000 tables is a cheap operation. Why do you have that many in the first place, let alone that many that you drop and recreate frequently? Almost certainly, you need a better-conceived schema. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers