Commit Graph

220 Commits

Author SHA1 Message Date
Ashwin Phatak
00897cef2c
Merge pull request #76 from vulcanize/pm-v4-merge
Merge latest changes from main into sharding branch
2022-05-11 15:22:53 +05:30
bc68969abb Fix migrations naming after merge 2022-05-10 19:34:01 +05:30
Ashwin Phatak
916af4f832
Merge pull request #75 from deep-stack/pm-image-migrations
Update Dockerfile to run migrations
2022-05-10 16:58:51 +05:30
526bda7090 Temporarily skip on-pr CI checks 2022-05-10 16:43:52 +05:30
d0f5110dec Update Dockerfile to run migrations 2022-05-10 16:22:35 +05:30
Ashwin Phatak
7312b330cd
Merge pull request #74 from deep-stack/pm-cleanup-migrations
Create distributed hypertables directly, skipping hypertables
2022-05-10 10:07:46 +05:30
0ccb54c770 Skip migration to create hypertables 2022-05-10 10:05:28 +05:30
33b293f2bb Fix migrations naming 2022-05-09 17:22:19 +05:30
Ashwin Phatak
045120ce20
Merge pull request #72 from deep-stack/pm-v4-multi-node
Multi-node setup to run the migrations
2022-05-04 16:04:10 +05:30
70cf01ff27 Create stored functions after creating distributed hypertables 2022-05-04 15:48:20 +05:30
06d9ef96e7 Multi-node setup to run the migrations 2022-04-29 10:51:40 +05:30
Ashwin Phatak
96bd0b5d9a
Merge pull request #70 from deep-stack/pm-v4-schema-fixes
Remove foreign keys to hypertables and fix schema dump
2022-04-26 09:55:37 +05:30
9b917746e4 Remove triggers blocking inserts 2022-04-22 18:54:43 +05:30
ee2f43a849 Remove foreign keys to hypertables 2022-04-22 18:53:43 +05:30
Ian Norden
b8f713d518
Merge pull request #67 from vulcanize/release-v4.0.0-alpha
Fixes + new schema dump
2022-04-18 09:34:45 -05:00
i-norden
c38394ad49 updated schema 2022-04-12 21:56:43 -05:00
i-norden
673ae7b265 fixes, PKs need to include partition key 2022-04-12 21:56:27 -05:00
Ian Norden
aa73e30b32
Merge pull request #65 from vulcanize/release-v4.0.0-alpha
[v4] TimescaleDB support
2022-04-12 21:12:18 -05:00
i-norden
3b4e097f00 remove pre and post migrations sets 2022-04-12 21:12:03 -05:00
i-norden
caf99f7194 use state leaf key in storage_cids FK 2022-04-12 21:11:36 -05:00
i-norden
b3832dd23d script for generating/updating the migration file for adding and attaching data nodes for distributed hypertables 2022-04-06 19:08:09 -05:00
i-norden
2816de15a3 migrations for hypertables and distributed hypertables 2022-04-06 18:44:19 -05:00
Ian Norden
f89ea6134f
Merge pull request #56 from vulcanize/release-v4.0.0-alpha
v4.0.0 alpha
2022-04-05 19:12:30 -05:00
Ian Norden
05600e51d2
Merge pull request #59 from vulcanize/release-v3.2.0
update the pre- and post- batch sets with new meta schema and tables
2022-03-31 12:47:32 -05:00
i-norden
201cadbd49 update the pre- and post- batch sets with new meta schema and tables 2022-03-31 12:45:27 -05:00
Ian Norden
82f28ae6ba
Merge pull request #53 from vulcanize/feature/known_table
Add `known_gaps` table
2022-03-31 11:12:54 -05:00
Abdul Rabbani
63e3d66cc1 Merge branch 'main' into feature/known_table 2022-03-31 12:07:28 -04:00
Abdul Rabbani
2ffb98c6f7 Change file name 2022-03-31 12:06:11 -04:00
Abdul Rabbani
b2f8f63a65 Update file name 2022-03-31 10:47:29 -04:00
Abdul Rabbani
e99787242e Add Migration file 2022-03-31 10:45:11 -04:00
i-norden
2162e73524 update schema 2022-03-28 18:23:30 -05:00
i-norden
da8d0af6df updates order of columns in compound PKs, update indexes e.g. we don't need a btree index on a column if it is the first column in the compound PK index but we do need a btree index for the later columns in a compound PK (searches on first column of a compound index are just as fast as searches on a btree index for that column alone, but searches on the 2nd or 3rd column in a compound index are significantly slower than on dedicated indexes) 2022-03-28 18:22:57 -05:00
i-norden
82de252160 stored functions for creating state and storage snapshots from the set of all diffs in Postgres 2022-03-28 18:20:29 -05:00
Ian Norden
d8dbd14af8
Merge pull request #54 from deep-stack/ng-watched-addresses-v3
Add a table for watched addresses (v3)
2022-03-23 07:08:59 -05:00
Ian Norden
20c320ac68
Merge pull request #51 from vulcanize/release-v4.0.0-alpha
denormalize tables by block_number
2022-03-21 20:02:44 -05:00
i-norden
ba2550cc01 update pre- and post- sets 2022-03-21 19:53:48 -05:00
679f3e8d79 Remove GO111MODULE flag when installing goose in makefile
Passing GO111MODULE=off with go get throws error. The CI fails due to this when using the makefile.
2022-03-21 17:07:46 +05:30
Abdul Rabbani
a1b75c31e9 Update schema.sql 2022-03-19 09:17:48 -04:00
Abdul Rabbani
35b40e6ff7 Add known_gaps table - DO NOT MERGE YET!!
We will probably need to change the `modulus_block_number` columns name
2022-03-18 14:35:07 -04:00
a500c1a49a Add table for watched addresses in eth_meta schema 2022-03-17 19:02:05 +05:30
i-norden
1dc12460dc denormalize tables by block_number so that we can partition all tables by block_number for purposes of sharding 2022-03-15 16:06:13 -05:00
Ian Norden
bba8a410f8
Merge pull request #50 from vulcanize/release-v3.0.7
Release v3.0.7
2022-03-07 11:12:09 -06:00
i-norden
f59582ab42 indexes on receipt cid and mh_key should not be unique, as it is possible (but improbable) that two receipts can be identical 2022-02-16 14:11:23 -06:00
Ian Norden
16e17abb7e
Merge pull request #47 from vulcanize/release-v3.0.6
split pk application into two parts
2022-01-26 13:09:24 -06:00
i-norden
9e7e0377a5 split pk application into two parts 2022-01-26 13:01:41 -06:00
Ian Norden
36de257357
Merge pull request #46 from vulcanize/release-v3.0.5
drop un-unique indexes
2022-01-25 12:33:34 -06:00
i-norden
0710ed1bb1 drop un-unique indexes 2022-01-25 12:31:59 -06:00
Ian Norden
c4254bdff1
Merge pull request #45 from vulcanize/release-v3.0.3
prep for integrated node of v3
2022-01-25 09:29:26 -06:00
i-norden
1088313ab7 prep for integrated node of v3 2022-01-25 08:29:25 -06:00
Ian Norden
ffdf0a0d4d
Merge pull request #43 from vulcanize/release-v3.0.2
v3.0.2
2022-01-19 15:31:13 -06:00