From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp2 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id ABJbGjSC+V97BQAA0tVLHw (envelope-from ) for ; Sat, 09 Jan 2021 10:15:16 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp2 with LMTPS id 550kFjSC+V+hZgAAB5/wlQ (envelope-from ) for ; Sat, 09 Jan 2021 10:15:16 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id F0A7B940483 for ; Sat, 9 Jan 2021 10:15:15 +0000 (UTC) Received: from localhost ([::1]:47790 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kyBH8-0002IR-L5 for larch@yhetil.org; Sat, 09 Jan 2021 05:15:14 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]:57400) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kyBFx-00019c-V7 for guix-devel@gnu.org; Sat, 09 Jan 2021 05:14:01 -0500 Received: from relay6-d.mail.gandi.net ([217.70.183.198]:38929) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kyBFv-0002ay-L6; Sat, 09 Jan 2021 05:14:01 -0500 X-Originating-IP: 86.247.16.87 Received: from bababa (lfbn-idf2-1-709-87.w86-247.abo.wanadoo.fr [86.247.16.87]) (Authenticated sender: mail@ambrevar.xyz) by relay6-d.mail.gandi.net (Postfix) with ESMTPSA id D1802C0003; Sat, 9 Jan 2021 10:13:54 +0000 (UTC) From: Pierre Neidhardt To: Mathieu Othacehe Subject: Re: Cuirass logo - artwork. In-Reply-To: <87a6tjqoji.fsf@gnu.org> References: <87bldzu64t.fsf@gnu.org> <87sg7bzrj8.fsf@ambrevar.xyz> <87a6tjqoji.fsf@gnu.org> Date: Sat, 09 Jan 2021 11:13:54 +0100 Message-ID: <87bldy5sf1.fsf@ambrevar.xyz> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="=-=-="; micalg=pgp-sha256; protocol="application/pgp-signature" Received-SPF: pass client-ip=217.70.183.198; envelope-from=mail@ambrevar.xyz; helo=relay6-d.mail.gandi.net X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 5.0 requ) BAYES_00=-1.9, FROM_SUSPICIOUS_NTLD=0.499, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H2=-0.001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: guix-devel@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: "Development of GNU Guix and the GNU System distribution." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Cc: guix-devel@gnu.org Errors-To: guix-devel-bounces+larch=yhetil.org@gnu.org Sender: "Guix-devel" X-Migadu-Flow: FLOW_IN X-Migadu-Spam-Score: -4.45 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=none; spf=pass (aspmx1.migadu.com: domain of guix-devel-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=guix-devel-bounces@gnu.org X-Migadu-Queue-Id: F0A7B940483 X-Spam-Score: -4.45 X-Migadu-Scanner: scn1.migadu.com X-TUID: /Po9b1NwsHmI --=-=-= Content-Type: text/plain Mathieu Othacehe writes: > At first I thought that all the performance issues we had were caused by > unoptimized SQL queries. Turns out it was only half of the problem. > > As we have multiple processes accessing the database (cuirass, > cuirass-web, cuirass-send-events and now remote-server), we are falling > into the architecture model that is very badly supported by SQLite: many > readers and many readers across several processes[1]. > > I also noticed that SQLite doesn't handle I/O pressure on the hard drive > the database is sitting on. I had to mount the database file on a tmpfs > directory to get around this issue[2]. > > Finally, SQLite doesn't offer any real monitoring solution, requires > periodical vacuuming and is really hard to configure[3]. > > As stated on SQLite website: "SQLite does not compete with client/server > databases. SQLite competes with fopen()." > > I've been running Cuirass using a PostgreSQL database, and without any > particular tuning everything works smooth, which makes me regret to have > waited so long to leap the breach. > > Thanks for you interest, Very interesting, thanks for sharing your experience. Worth a blog post in my opinion ;) Cheers! --=-=-= Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQFGBAEBCAAwFiEEUPM+LlsMPZAEJKvom9z0l6S7zH8FAl/5geISHG1haWxAYW1i cmV2YXIueHl6AAoJEJvc9Jeku8x/8YEH/0O6uCTqYT8bWfDq1crqoUmFQlPqp/zW R/Zf3p240hWQwOkdxoL6/b67pmobrbPoKReiV+0L/4apSzLLTiWhY0awkf2acKAL PaM8ycqZsWtha+DDXQ3rL3kWTDrzVPHFFc7bOrPOV+SkemPkJ33Nl/TWsFbhfPmr F/LMyRaBtnYFijVWgNGEMwfzNgY8/O/zf2jGflX2c8WFzC7KakNQfWZUzeOq56Rh Snlb5yRQhYW2njxHMprdtYY7cBeWZhvAxbc3sMJyaoomWZuLARSwfypvY50MaiVQ hngEpPxQcQU+65hw5wNSz+ljs0mUJlF443NExzrMsvfXsYKPGe5R7SM= =v2CT -----END PGP SIGNATURE----- --=-=-=--