I understand that PostGIS allows us to set SRID on geometry or geography. But I am just wondering if it would actually impact the rendering performance on the client side.
For instance, let's say I have set 4326 as SRID on my geometry column in postgis and visualize it on Google Maps which uses EPSG3857. I assume, in this case, there need to be some sort of computation to project 4326 geometry values into 3857 geometry values. Does that mean I should have set 3857 as SRID so that there is no need for unnecessary geometry transformation?
Probably this does not really matter for small datasets but does it make any differences for bigger datasets, say 500GB?