Re: About the performance of startup after dropping many tables - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: About the performance of startup after dropping many tables
Date
Msg-id 1315422909-sup-6411@alvh.no-ip.org
Whole thread Raw
In response to Re: About the performance of startup after dropping many tables  (Gan Jiadong <ganjd@huawei.com>)
List pgsql-hackers
Excerpts from Gan Jiadong's message of vie feb 18 03:42:02 -0300 2011:
> Hi,
> 
>   Thanks for your reply. 
>   Of course, we will think about whether 40000 relations dropping is
> reasonable. In fact, this happens in a very special scenario . 
>   But when we analyzed this issue, we found the PG code can be rewritten to
> achieve better performance. Or we can say the arithmetic of this part is not
> good enough. 
>   For example, by doing the refactoring as we done, the startup time can be
> reduced from 3 minutes to 8 seconds, It is quite a great improvement,
> especially for the systems with low TTR (time to recovery) requirement.
> 
>   There is any problem or risk to change this part of code as we suggested?

The only way to know would be to show the changes.  If you were to
submit the patch, and assuming we agree on the design and
implementation, we could even consider including it (or, more likely,
some derivate of it).

-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: custom variables and PGC_SUSET issue
Next
From: Andrew Dunstan
Date:
Subject: Re: custom variables and PGC_SUSET issue