solana-accountsdb-plugin-postgres
solana-accountsdb-plugin-postgres copied to clipboard
solana-labs
Is it possible to store `amount` and `owner` of token account in `spl_token_owner_index` table and update it same way the items of `account` table is kept up to date? @lijunwangs
I think that with concurrent writes to DB there is a small chance that insert into slot table will create invalid data. Scenario: function `update_slot` from RPC produce 3 updates...
I think that there should be `ON CONFLICT` that make UPSERT instead of INSERT. To make sure that all block are overwriten correctly. ``` Failed to update block metadata: (Error...
I had this plugin feeding into a Postgres, and then overnight it stopped working, and my log was filled with: `[2022-09-13T15:27:51.193907033Z ERROR solana_geyser_plugin_postgres::postgres_client] Failed to update account: (Error updating account....
- Fixes default thread count from `100` to `10`, as initially specified in code comments. From the code comments: ``` /// * "threads" optional, specifies the number of worker threads...
- Per a comment in the file, the default is supposed to be 10.
I believe that this: https://github.com/solana-labs/solana-accountsdb-plugin-postgres/pull/23/files Doesn't actually fix the transaction order in the blocks. Requires this: https://github.com/solana-labs/solana/pull/25688
This is related to: https://github.com/lijunwangs/solana-postgres-rpc-server/issues/3 When slots that were on forks end up being skipped, we're storing inconsistent state data in the `accounts` table. Proposed solution: Add a trigger that...
Currently you need to activate historical data storage to be able to run the RPC server (https://github.com/lijunwangs/solana-postgres-rpc-server) as it can otherwise not return the correct commitment level data. If the...
https://github.com/solana-labs/solana-accountsdb-plugin-postgres/blob/736d3f98d8aa0f8da2219ece2d692fba54dbd168/.gitignore#L5-L7 And the provided link claims it exactly vice versa. I mean the plugin is somehow "executable" by solana-validator than library used to build another executable. > > [Why do...