How does connection pooling work in database systems?