Pinecone tests - remove namespaces at test suite end/failure #2817
Description
In Pinecone, our test instance is limited to 100 namespaces.
For each test, we create a namespace and delete it when the individual test ends.
Over time, it happens that some namespaces are not properly deleted, causing the namespace limit to be hit.
It could be worth exploring if, instead of deleting the namespace for each test, we could remove all namespaces when the test suite ends/fails. This might also speed up tests a bit.
Since integration tests do not run on PR from forks, it's better to handle this internally.