Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.
For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email email@example.com.
Go in to phpmyadmin and DELETE FROM `catalog_product_entity` WHERE attribute_set_id =NNN if you only want to delete your products with your custom attribute set (in which case you will have to look up NNN from your catalog_product_entity table. In that way you can keep ‘demo’ products that have their own attribute sets.
Alternatively, truncate the table, as per the instructions in the wiki.