This may or may not be an issue with bulkifying your trigger. Most likely you just have a lot of data in production, and you didn't account for the fact that you can only query 10000 rows in a session. Look at your query and determine if you really need all that data. Most likely you can be more specific in the query, and that will reduce the amount of data you get back.
Post your trigger code if this doesn't make sense.
hi! u have to bulk your trigger because of the goverment limits SF.
http://blog.jeffdouglas.com/2009/04/20/writing-bulk-triggers-for-salesforce/
This may or may not be an issue with bulkifying your trigger. Most likely you just have a lot of data in production, and you didn't account for the fact that you can only query 10000 rows in a session. Look at your query and determine if you really need all that data. Most likely you can be more specific in the query, and that will reduce the amount of data you get back.
Post your trigger code if this doesn't make sense.
Jeremy