search

tembo-io / pg_tier

Postgres Extension written in Rust, to enable data tiering to AWS S3
Apache License 2.0
108 stars 2 forks source link

Performance and size benchmarks #18

Open andyatkinson opened 4 days ago

andyatkinson commented 4 days ago

Would it be useful to show some examples of querying full tables with 1000 rows, 100K, 1 million, etc.?

Would it be useful to show comparisons of space consumption between a regular table, and a S3-based foreign table? I think showing the reduced space consumption could help explain the benefit.

I can possibly help put these together, but I was curious whether there was interest in that.

ChuckHend commented 3 days ago

This would be very useful to have although we don't expect it to have incredibly high performance at this time. It would be good to have the baseline though and maybe get some community help!

andyatkinson commented 3 days ago

Hey @ChuckHend I'm thinking about at least a basic blog post showing a tiering approach, possibly without pg_tier to start, then maybe where pg_tier helps. If I get something going, I'll be sure to share it here.