enykeev/1.sql

Last active April 20, 2022 07:39

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/enykeev/19f145af03d92ec6b2b1df9c57fb1aa3.js"></script>
Save enykeev/19f145af03d92ec6b2b1df9c57fb1aa3 to your computer and use it in GitHub Desktop.

Download ZIP

PG partitioning

Raw

1.sql

	-- Kafka-like partitioning

	select abs(hashtext(id)) % 10 as partition, count(*) from events group by partition

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment