Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qW7Nc-002BcZ-85 for pgsql-general@arkaria.postgresql.org; Wed, 16 Aug 2023 03:39:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qW7Na-002R7f-VL for pgsql-general@arkaria.postgresql.org; Wed, 16 Aug 2023 03:39:31 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qW7Na-002R7X-Kp for pgsql-general@lists.postgresql.org; Wed, 16 Aug 2023 03:39:30 +0000 Received: from mail-yb1-xb36.google.com ([2607:f8b0:4864:20::b36]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qW7NY-000NII-7Y for pgsql-general@lists.postgresql.org; Wed, 16 Aug 2023 03:39:29 +0000 Received: by mail-yb1-xb36.google.com with SMTP id 3f1490d57ef6-d62bdd1a97dso6045242276.3 for ; Tue, 15 Aug 2023 20:39:28 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1692157167; x=1692761967; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=og3bXruMYq0gUMwAZqrGlYtVCB+8PeaNflVEXCGR9Bw=; b=SFNODLinv0aNZDeaqg8//jTCs/q9LNnRHe1ptFS0IrKyAHeCg0asx5EouUYEgNWP7y ro7eKvu6WG0ylazjVuif/jl/S1pfZnDbecvXhNfhDg0JTOLTZcyGXwC1ZjDXII8KiqOo rMS/MTa0WprV19UQcX+YIf4kUJ/fm47ywwgcjhdOtdfues3im3IYf61lYSqli7x/Gmmp apli9tL073OOtKl7XlgONPL6RAMclcIp2y1kGHq/zUxdEU97iPsZzdvclVBnOgt1Cg4V CBsLTlrsn6jqF91wHSqQGCEFDclcuyl8gZ8iEfuN3rqpqOLSsIQObXKhTHATaEF5Bhoi Al5Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1692157167; x=1692761967; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=og3bXruMYq0gUMwAZqrGlYtVCB+8PeaNflVEXCGR9Bw=; b=PcLYtLb/tMB5NDPhDkj2HsUwhucC1cvlOt5YprwUF1DiAF0Ax16lxhJvC7pt6RC24F A13Hi3NdBDoHes7yMUQ7TuHb5Diu2zxIF8YvSwuMmM1GuPhNWLrFmeGUvVymjSKYHMzj LJVWDhqw9O40OvWatOk0z3TfnFaJhE4rqIdTC6tN0v9AWOsYj7PZENY0X8sqVjGtAzTR i9WZBrqpjIhwMpxivV+0pULkSGMPuuoed2E++kOH15008UeXYb4PZE2eRiBCuhHRgthu 36+S/jPENFWm2x0lqS8bmpDoZhk6gviOnjxod91l/QryyUqalmep2KHA/KUyFkk5Qleh sOOA== X-Gm-Message-State: AOJu0Yx9R0ux3wNa8Q3auXqH8IzdI4aISwTRfK4FPTgEhOe4UmqmZPKy SVPiwr8zOBxTdVP2aFyvp7442y9K0aE= X-Google-Smtp-Source: AGHT+IEmktTFdSuSZW346+9o8yKH9DFWYgie9cJxexX1sQqzCXR4az9bMsMbVgN/eCYNt5/dHs8QkQ== X-Received: by 2002:a25:42d0:0:b0:d05:8c24:b81c with SMTP id p199-20020a2542d0000000b00d058c24b81cmr738529yba.8.1692157167092; Tue, 15 Aug 2023 20:39:27 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:f449:ced4:fba5:53d2? ([2600:1700:bd2c:b810:f449:ced4:fba5:53d2]) by smtp.googlemail.com with ESMTPSA id 21-20020a250415000000b00d712798a09bsm589165ybe.64.2023.08.15.20.39.26 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 15 Aug 2023 20:39:26 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------fwaAM08FfaiiJn3YdnncbDMu" Message-ID: <49645ea0-9b4d-02fa-dabb-4390916bfe1f@gmail.com> Date: Tue, 15 Aug 2023 22:39:25 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.11.0 Subject: Re: PostgreSQL and local HDD Content-Language: en-US To: pgsql-general@lists.postgresql.org References: <868525317.2467108.1692084222719.ref@mail.yahoo.com> <868525317.2467108.1692084222719@mail.yahoo.com> From: Ron In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------fwaAM08FfaiiJn3YdnncbDMu Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit On 8/15/23 04:24, Olivier Gautherot wrote: [snip] > > Does the database have to be on a storage like EMC or QNAP? > > > Faster storage can only help but I would start by discarding functional > overhead. Functional overhead? -- Born in Arizona, moved to Babylonia. --------------fwaAM08FfaiiJn3YdnncbDMu Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit On 8/15/23 04:24, Olivier Gautherot wrote:
[snip]
Does the database have to be on a storage like EMC or QNAP?

Faster storage can only help but I would start by discarding functional overhead.

Functional overhead?

--
Born in Arizona, moved to Babylonia.
--------------fwaAM08FfaiiJn3YdnncbDMu--