Connector Improvement: Heroku Postgres: syncing a subset of a table
Hi!
In certain cases we are interested in a very narrow subset of heavily used and/or very large tables. The subset is easily identified with a simple where clause, e.g.
select *
from <table>
where <table>.type = 'specific_type'
Currently there are no sync methods that support loading a selected subset like this (and, at least for XMIN and Teleport, I can somewhat understand why) - but it would be great if there was one.
Our hopes would be that this would allow us to reduce storage used in our destination, and reduce compute costs incurred as part of loading unnecessary data.
Please sign in to leave a comment.
Comments
0 comments