# Clean PGQ Subconsumers

DevFeed: [Clean PGQ Subconsumers](<https://devfeed.tech/articles/clean-pgq-subconsumers-34466.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2012/04/clean-pgq-subconsumers/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2012-04-26T13:05:00Z

Content type: tutorial

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [Development](<https://devfeed.tech/topics/development.md>), [Transactions](<https://devfeed.tech/topics/transactions.md>)

Tags: [development](<https://devfeed.tech/tags/development.md>), [queues](<https://devfeed.tech/tags/queues.md>), [transactions](<https://devfeed.tech/tags/transactions.md>)

## AI overview

A tutorial on resetting a PGQ development environment by unregistering subconsumers and consumers, then dropping queues. The process can lose events, including events from currently active batches.

## Source excerpt

Now that you're all using the wonders of Cooperative Consumers to help you efficiently and reliably implement your business constraints and offload them from the main user transactions, you're reaching a point where you have to clean up your development environment (because that's what happens to development environments, right?), and you want a way to start again from a clean empty place. Here we go. It used to be much more simple than that, so if you're still using PGQ from Skytools2, just jump to the next step.