mirror of
https://github.com/logos-messaging/docs.waku.org.git
synced 2026-01-16 11:43:13 +00:00
1 line
28 KiB
JavaScript
1 line
28 KiB
JavaScript
|
"use strict";(self.webpackChunkwaku_guide=self.webpackChunkwaku_guide||[]).push([[6663],{978:(e,s,t)=>{t.d(s,{A:()=>n});const n=t.p+"assets/images/insert-time-dist-2-46dc8832866df6316c3c4198f72f7933.png"},3267:(e,s,t)=>{t.d(s,{A:()=>n});const n=t.p+"assets/images/query-time-dist-postgres-2-347ba236b22fccce5efa56b29dae2021.png"},4587:(e,s,t)=>{t.d(s,{A:()=>n});const n=t.p+"assets/images/query-time-dist-4-03ae15c83b1b754a6716b8d25593e7be.png"},9080:(e,s,t)=>{t.d(s,{A:()=>n});const n=t.p+"assets/images/query-time-dist-f40e2f9ea1b96e1288c924f5c600d948.png"},11423:(e,s,t)=>{t.d(s,{A:()=>n});const n=t.p+"assets/images/jmeter-results-b7c1925776dc6b56d42d959250eefe05.png"},14082:(e,s,t)=>{t.d(s,{A:()=>n});const n=t.p+"assets/images/query-time-dist-5-eae87929d2d1e5a8399131d2492664f3.png"},15272:(e,s,t)=>{t.d(s,{A:()=>n});const n=t.p+"assets/images/topology-only-store-protocol-4c1704db48f330abda7f925618c485b4.png"},21150:(e,s,t)=>{t.r(s),t.d(s,{assets:()=>h,contentTitle:()=>o,default:()=>l,frontMatter:()=>a,metadata:()=>n,toc:()=>c});const n=JSON.parse('{"id":"learn/research/benchmarks/postgres-adoption","title":"PostgreSQL","description":"Document that describes why Nim-Waku started to use Postgres and shows some benchmark and comparison results.","source":"@site/docs/learn/research/benchmarks/postgres-adoption.md","sourceDirName":"learn/research/benchmarks","slug":"/learn/research/benchmarks/postgres-adoption","permalink":"/learn/research/benchmarks/postgres-adoption","draft":false,"unlisted":false,"editUrl":"https://github.com/waku-org/docs.waku.org/tree/develop/docs/learn/research/benchmarks/postgres-adoption.md","tags":[],"version":"current","lastUpdatedAt":null,"frontMatter":{"title":"PostgreSQL","description":"Document that describes why Nim-Waku started to use Postgres and shows some benchmark and comparison results."},"sidebar":"learn","previous":{"title":"Research","permalink":"/learn/research/"},"next":{"title":"Performance Benchmarks and Test Reports","permalink":"/learn/research/benchmarks/test-results-summary"}}');var r=t(74848),i=t(28453);const a={title:"PostgreSQL",description:"Document that describes why Nim-Waku started to use Postgres and shows some benchmark and comparison results."},o=void 0,h={},c=[{value:"Introduction",id:"introduction",level:2},{value:"How to connect the <em>nwaku</em> to <em>Postgres</em>",id:"how-to-connect-the-nwaku-to-postgres",level:2},{value:"Examples of <em>nwaku</em> using <em>Postgres</em>",id:"examples-of-nwaku-using-postgres",level:2},{value:"Stress tests",id:"stress-tests",level:2},{value:"Insert test results",id:"insert-test-results",level:3},{value:"Maximum insert throughput",id:"maximum-insert-throughput",level:4},{value:"Query test results (jmeter)",id:"query-test-results-jmeter",level:3},{value:"Query test results (only Store protocol)",id:"query-test-results-only-store-protocol",level:3},{value:"Comparing archive SQLite & Postgres performance in nwaku-b6dd6899",id:"comparing-archive-sqlite--postgres-performance-in-nwaku-b6dd6899",level:4},{value:"Comparing archive SQLite & Postgres performance in nwaku-b452ed8",id:"comparing-archive-sqlite--postgres-performance-in-nwaku-b452ed8",level:4},{value:"Conclusions",id:"conclusions",level:4},{value:"Multiple nodes & one single database",id:"multiple-nodes--one-single-database",level:3},{value:"Results",id:"results",level:4}];function d(e){const s={a:"a",code:"code",em:"em",h2:"h2",h3:"h3",h4:"h4",hr:"hr",img:"img",li:"li",ol:"ol",p:"p",pre:"pre",strong:"strong",ul:"ul",...(0,i.R)(),...e.components};return(0,r.jsxs)(r.Fragment,{children:[(0,r.jsx)(s.h2,{id:"introduction",children:"Introduction"}),"\n",(0,r.jsxs)(s.p,{children:["The ",(0,r.jsx)(s.em,{children:"Nim Waku Node"}),", ",(0,r.jsx)(s.em,{children:"nwaku"}),", has the capability of archiving messages until a certain limit (e.g. 30 days) so that other nodes can synchronize their message history throughout the ",(0,r.jsx)(s.em,{children:"Store"})," protocol."]}),"\n",(0,r.jsxs)(s.p,{children:["The ",(0,r.jsx)(s.em,{children:"nwaku"})," originally used ",(0,r.jsx)
|