For instance PostgreSQL's performance might be very different depending on the size of data query has to operate.
Also if you deal with something like search results, it gets pretty annoying to deal with "well, I don't have enough data locally for this particular thing I develop".
Again, talking here about the "run the world and click on things" approach vs developing against tests / API schemas / whatnot.