Why are there different size pixels for CCD's?

The first CCD's were produced using the technology available at the time. This limited the amount of pixels a CCD could hold. Subsequent advances in technology reduced the size of the pixels, thus increasing the resolution.