Comments (2)
roadscape
commented on June 28, 2024
reference: #51
from hivemind.
roadscape
commented on June 28, 2024
table_name | rows | total_size | index_size | toast_size | table_size | total_size_per_row | index_size_per_row | table_size_per_row
------------------+-------------+------------+------------+------------+------------+--------------------+--------------------+--------------------
hive_posts_cache | 2.32118e+07 | 84 GB | 3675 MB | 39 GB | 41 GB | 3866 bytes | 166 bytes | 3700 bytes
hive_posts | 2.545e+07 | 9381 MB | 5334 MB | 8192 bytes | 4047 MB | 387 bytes | 220 bytes | 167 bytes
hive_accounts | 971922 | 8538 MB | 265 MB | 75 MB | 8198 MB | 9211 bytes | 286 bytes | 8926 bytes
hive_follows | 3.47918e+07 | 4388 MB | 2591 MB | | 1797 MB | 132 bytes | 78 bytes | 54 bytes
hive_blocks | 1.8288e+07 | 4073 MB | 1638 MB | | 2435 MB | 234 bytes | 94 bytes | 140 bytes
hive_post_tags | 1.64726e+07 | 3228 MB | 2372 MB | | 855 MB | 205 bytes | 151 bytes | 54 bytes
hive_feed_cache | 6.92214e+06 | 894 MB | 566 MB | | 329 MB | 135 bytes | 86 bytes | 50 bytes
hive_reblogs | 2.51230e+06 | 356 MB | 222 MB | | 134 MB | 149 bytes | 93 bytes | 56 bytes
from hivemind.
Related Issues (20)
- clarify startup config output
- nsfw validation HOT 1
- resolve feed/blog inconsistency HOT 1
- schema changes
- openmic tag missing HOT 2
- standardize new vs. legacy mute logic
- notifs: mark read HOT 1
- iredeemables/blacklists issues
- additional community props HOT 5
- iredeemables spamming reply notifications
- get_community timings HOT 1
- Allow pagination for method 'list_subscribers'
- master merge prep
- Fat Node without market_history is apparently useless for hivemind
- I can't specify specialized endpoints
- Issue with the bridge.get_ranked_posts API
- The community title contains unexpected string HOT 1
- sqlalchemy.exc.DataError: (psycopg2.errors.StringDataRightTruncation) value too long for type character varying(100)
- Error: assert post['active_votes'] or int(post['net_rshares']) == 0 HOT 1
- reply page error
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from hivemind.