Is there any performance consideration when using Custom Post Types?

No. All posts are stored in the wp_posts table. The post type is defined by post_type column.

Regardless to custom post types included in query, there is only one SQL query executed. Of course there may be some performance hit caused by a little bit more complex query (in vs. =), but it’s marginal.