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 1qW8YO-002FBH-2o for pgsql-general@arkaria.postgresql.org; Wed, 16 Aug 2023 04:54:44 +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 1qW8YM-0032P7-FS for pgsql-general@arkaria.postgresql.org; Wed, 16 Aug 2023 04:54:42 +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 1qW8YM-0032Ow-3v for pgsql-general@lists.postgresql.org; Wed, 16 Aug 2023 04:54:42 +0000 Received: from mail-yw1-x1129.google.com ([2607:f8b0:4864:20::1129]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qW8YJ-000Npp-8b for pgsql-general@lists.postgresql.org; Wed, 16 Aug 2023 04:54:41 +0000 Received: by mail-yw1-x1129.google.com with SMTP id 00721157ae682-58c92a2c52dso3194777b3.2 for ; Tue, 15 Aug 2023 21:54:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1692161678; x=1692766478; 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=5EVrnpWVyKtauFDFAXTkwbCXPDsWVwGi53JZA6AGdi8=; b=Ce5YRpIoikpRVZ65aJvLDq94fsNrpednq9Lu+V3ckGpFjGDlOib+SsPUPCeEXEtkGr XtwNKUv6ykndfAt1MlQUMh2bX9rKNJe9B7/QnksWsVi8BZbkSNZb9esiNOzu4C8Pgljp yt3yk+l0h9gPEQThc6eRzyszeg/x4X2bBg3XUJ6AaeX76IUzrbW9Osc/KfEBFlkS2GRf JXJ9VmM/fMUyuHShnxEEhJjzBp4MqiBlVp9M4l8HSm5R5i8+vjkxrYmEXM9ryFx6MiE+ YEt8UWBZUO/hIwajh0CHBLVAzncENVVXmo2rwkqFsU0kmRK7w57BJ3O6wciopKL87KLo gMYQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1692161678; x=1692766478; 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=5EVrnpWVyKtauFDFAXTkwbCXPDsWVwGi53JZA6AGdi8=; b=i0PdPWvIst37q8QdnkOq/wNUcK3cAitHDw8jo1lgM57OaorBw58gWnwNFfPcPCfE5b L8YsWrv7Cxz9VNJmWgiWEVPi+sY2jm2i4Si/0Sf+zXUyYRXAyhWgFKhvTksJ8bdMuMO0 FULNz+n3WnmmdwHaVIwZOqvNfWFo6QoWrdzYUfX9DAcRPvRAlBVHvPNFABX4UyUjNyGi J/fklxJ/8dUKVUZHyAABTM9dkrXyam8EvJkVCf12hZJORnGRYGwUbBDdnWT+OIAtlaAn xyZzfxvVpK4Lx5cHW7hgeqHoiuQ5l8Q1eJksB7YdWHMcIto97UePQQXUegLHPcyCRHlP HXrg== X-Gm-Message-State: AOJu0Yw1Dj77REaDXCYppLPHQsUe11I7Fmc3o/stFXahkNMrr+JUFIIe DUMsmgN/YIT0ZnZmvTKIL6Djv5SuaS4= X-Google-Smtp-Source: AGHT+IHJ7/NQQOwTlxqR547cHsHcE4wgzA/TIFUyhmK9pBWN569B2pUXGIkimu7oAvn0MFde+cliUA== X-Received: by 2002:a81:a204:0:b0:586:a597:a002 with SMTP id w4-20020a81a204000000b00586a597a002mr734117ywg.6.1692161677996; Tue, 15 Aug 2023 21:54:37 -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 em3-20020a05690c2b0300b005869e1d8c41sm3759441ywb.29.2023.08.15.21.54.37 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 15 Aug 2023 21:54:37 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------dfRwMud8c6eJWBLf7NoG0d8p" Message-ID: Date: Tue, 15 Aug 2023 23:54:35 -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: PostgreSQL General References: <868525317.2467108.1692084222719.ref@mail.yahoo.com> <868525317.2467108.1692084222719@mail.yahoo.com> <49645ea0-9b4d-02fa-dabb-4390916bfe1f@gmail.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. --------------dfRwMud8c6eJWBLf7NoG0d8p Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 8/15/23 23:48, Olivier Gautherot wrote: > > El mié, 16 ago 2023 5:39, Ron escribió: > > 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? > > > I mean inefficient design, which won't be solved by changing the storage. Ah, the normal aspects of physical design... -- Born in Arizona, moved to Babylonia. --------------dfRwMud8c6eJWBLf7NoG0d8p Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit On 8/15/23 23:48, Olivier Gautherot wrote:

El mié, 16 ago 2023 5:39, Ron <ronljohnsonjr@gmail.com> escribió:
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?

I mean inefficient design, which won't be solved by changing the storage.

Ah, the normal aspects of physical design...

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