fiatjaf on Nostr: On https:/github.com/fiatjaf/relayer I've done just event table, with fancy Postgres ...
On https:/github.com/fiatjaf/relayer I've done just event table, with fancy Postgres indexes for the tags, but I have no idea about performance. I believe
scsibug (npub1xhf…4xw3) used a separate table for tags on nostr-rs-relay, but I am not sure.
cameri (npub1qqq…n47m)?
As far as I know randomness of keys affect insert performance, not read.
Published at
2023-03-24 23:44:30Event JSON
{
"id": "762e0cfb18c8ebe07cdd42f3fce8fdd64e43d4c854671f55be289c0fc8c7f616",
"pubkey": "3bf0c63fcb93463407af97a5e5ee64fa883d107ef9e558472c4eb9aaaefa459d",
"created_at": 1679701470,
"kind": 1,
"tags": [
[
"p",
"00000000827ffaa94bfea288c3dfce4422c794fbb96625b6b31e9049f729d700"
],
[
"p",
"35d26e4690cbe1a898af61cc3515661eb5fa763b57bd0b42e45099c8b32fd50f"
],
[
"p",
"460c25e682fda7832b52d1f22d3d22b3176d972f60dcdc3212ed8c92ef85065c"
],
[
"e",
"c1f3b19b33f7bc4ebff97720a9f70664cf011952211686c5c0c45ef92938941a",
"wss://relay.nostr.bg/",
"root"
]
],
"content": "On https:/github.com/fiatjaf/relayer I've done just event table, with fancy Postgres indexes for the tags, but I have no idea about performance. I believe #[1] used a separate table for tags on nostr-rs-relay, but I am not sure. #[0]?\n\nAs far as I know randomness of keys affect insert performance, not read.",
"sig": "cbd28dda54fb01a0c9c2e4ce57101cac1487a5601cafbe2c403c6e69f35f8c3500c6161e58c8ddedfd410c3b2a30331b38d1f638e82f03db51ad317bd570d1b1"
}
