Andres Olarte <olarte(dot)andres(at)gmail(dot)com> writes:
> I need to load and drop my schema multiple times during my unit tests.
> This happens several thousand times per run of my test suite. I'm
> loading the schema from the file that's generated by pg_dump, and it
> works, but it's SLOW.
Sounds to me like you've been neglecting to vacuum the system catalogs.
regards, tom lane