dbnewbie

3 ms·

1. 1.▲
   by dbnewbie 7y ago

   Excellent, thanks for the suggestion. I hadn’t heard of this lib until now. And, seeing that this is developed by Citus makes it automatically 10x better.
2. 2.▲
   by dbnewbie 7y ago

   Interesting, that does sound like an advanced indexing technique, but also sounds like a really good idea. It reminds me of the old flat file database formats I read about.
3. 3.▲
   by dbnewbie 7y ago

   Thanks! That’s awesome. I know roughly how to understand PG query plans, but it doesn’t ever seem to actually help me figure out a solution. This service looks like it will help quite a bit.
4. 4.▲
   by dbnewbie 7y ago

   Thank you for the suggestion. I don’t know for certain that it’s a tenable solution, because we are using some services that would take some time to vertically integrated if we were to go to a colo. But when we reach that scale that will de
5. 5.▲
   by dbnewbie 7y ago

   OK that makes sense, and I’ll do a bit of reading on materialized view functionality before actually implementing anything.
6. 6.▲
   by dbnewbie 7y ago

   Ok awesome, and thanks again!
7. 7.▲
   by dbnewbie 7y ago

   I have not looked into “index encoding”. In fact, I haven’t even heard of that, thank you for the suggestion! In terms of execution plan, the query we are doing is relatively basic even though it includes some aggregation. The aggregation i
8. 8.▲
   by dbnewbie 7y ago

   Thank you an absolute ton! I’m gonna be watching that scaling video from Pycon this afternoon! We definitely have a decent configuration, in terms of using the hardware best for our typical workload. We also have indexes on the fields we ar
9. 9.▲
   by dbnewbie 7y ago

   Thanks a ton for the help, I will take a look into what we might be able to do in terms of adding a materialized aggregate view!
10. 10.▲
    Ask HN: 120M rows Postgres – how can I speed up queries?

    23 points by dbnewbie 7y ago|20 comments