Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nOtbD-0005lm-Lu for pgsql-performance@arkaria.postgresql.org; Tue, 01 Mar 2022 03:54:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nOtbC-0001kL-FO for pgsql-performance@arkaria.postgresql.org; Tue, 01 Mar 2022 03:54:54 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nOtbC-0001kC-3S for pgsql-performance@lists.postgresql.org; Tue, 01 Mar 2022 03:54:54 +0000 Received: from mail-qv1-xf2d.google.com ([2607:f8b0:4864:20::f2d]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nOtb7-0003D3-2v for pgsql-performance@lists.postgresql.org; Tue, 01 Mar 2022 03:54:53 +0000 Received: by mail-qv1-xf2d.google.com with SMTP id d3so15804882qvb.5 for ; Mon, 28 Feb 2022 19:54:48 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=message-id:date:mime-version:user-agent:subject:content-language:to :references:from:in-reply-to; bh=e0YLQ3fFyYsE9xALmbH6rd+QkgfjnX/p6lRIl9C08T4=; b=HGyWkC4k1ITgnkB+KEc1UT/JS5Q1/axtosZsXkeJ+oMOxNcVraSwH9o8Dv9JPrPMgM cRsMtK4BXj+0xtcLH3IE4iO/H2kxccMNi560vryqKSJME7ayFbTj6som5Vg3TZNbkwDX R+azjPgLMqW7BZS+dNW5jmuSNMO2Zl1l4RDG967mwVUzZa4oaccos90yDavFtEkpse9O XNV8fd7SFcms0gIAcpuVXjndRoAU6Jlu5h7xBpNE4xRUDsAwBQACOVjsinZnpILLWmPo Hg+wq6MAGnVOMz+ENRKFnG9r9/i3CoFlKtk4kYAE0SDXRnqx4IsFVirfk10kBKPgzH4R nuxg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:message-id:date:mime-version:user-agent:subject :content-language:to:references:from:in-reply-to; bh=e0YLQ3fFyYsE9xALmbH6rd+QkgfjnX/p6lRIl9C08T4=; b=b9EWyG7/TuaaVhWm47EvznFmhvX7f33JXl9OyjE3ujCWOHXdAyq2LRISZT/N+efGWN Ct/BBwX/06kxzOMDq16f4bhlphjyV5SuNUUsxK9g5zzlAsT5VknlrC2ulG0Q1zSnHej4 nQ0DReYbc0Fc63Di2qf4J6Iw6QarMI1dKk1WNWItLJPjjjObFeCfhesn9qllLUfKIzRE Oj4E8CT8z4RBngrTZ8N2NUT0dxoPrFIYTZjK8KDUXlYsz5pBiSRR/phOsqdPIV/9jlk/ +h8UYHX+jMCC/bPfDv91oHVr6/OGbPS+NiEsqFBa+cB79OUYrEY3bgSF/CjOh490DODl q2eQ== X-Gm-Message-State: AOAM531ok3TGbaatc8/9z7shQ3dhN+bW1R3kLxKKowG72jfiAlhm3MyS 5hmzUc03Io2ag4oba5TROyB3UJvpGiY= X-Google-Smtp-Source: ABdhPJzFWIlFXiI84cmm+2TpFerwURzZXNJ8UbN7dRvzCQ3+KWJ6Ih/rBjNySx7M7R1sqaZ7j3wTyA== X-Received: by 2002:ad4:576a:0:b0:432:8c87:783e with SMTP id r10-20020ad4576a000000b004328c87783emr16248263qvx.60.1646106886145; Mon, 28 Feb 2022 19:54:46 -0800 (PST) Received: from [192.168.2.100] (pool-72-79-19-93.nwrknj.east.verizon.net. [72.79.19.93]) by smtp.gmail.com with ESMTPSA id f15-20020ac86ecf000000b002d58a639121sm7704763qtv.97.2022.02.28.19.54.45 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 28 Feb 2022 19:54:45 -0800 (PST) Content-Type: multipart/alternative; boundary="------------w9j1ifcj1VTA0ThV77y5zwWP" Message-ID: <4cddaa9b-6435-709a-78bb-419fa8a78495@gmail.com> Date: Mon, 28 Feb 2022 22:54:44 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.5.0 Subject: Re: Never Ending query in PostgreSQL Content-Language: en-US To: pgsql-performance@lists.postgresql.org References: From: Mladen Gogala 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. --------------w9j1ifcj1VTA0ThV77y5zwWP Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 2/27/22 12:20, Jeff Janes wrote: > Several hours is not all that long. Well, the pyramids in the Valley of the Kings last for around 4500 years. Dinosaurs have ruled the Earth for approximately 120 million years. Solar system is 5 billion years old. Cosmos is around 13 billion years old. Compared to those numbers, indeed, several hours isn't that long. Furthermore, you have to account for the time dilatation. One hour on the planet that's evolving and revolving at 900 miles an hour is not the same as one hour of standing still. To make things even more interesting, it's orbiting at 19 miles a second, so it's reckoned,The sun that is the source of all our power. So, several hours is relative.  Each object has its relative time so it's not possible to conclude whether several hours is a long time or not. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com --------------w9j1ifcj1VTA0ThV77y5zwWP Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit
On 2/27/22 12:20, Jeff Janes wrote:
Several hours is not all that long.

Well, the pyramids in the Valley of the Kings last for around 4500 years. Dinosaurs have ruled the Earth for approximately 120 million years. Solar system is 5 billion years old. Cosmos is around 13 billion years old. Compared to those numbers, indeed, several hours isn't that long. Furthermore, you have to account for the time dilatation. One hour on the planet that's evolving and revolving at 900 miles an hour is not the same as one hour of standing still. To make things even more interesting, it's orbiting at 19 miles a second, so it's reckoned, The sun that is the source of all our power. So, several hours is relative.  Each object has its relative time so it's not possible to conclude whether several hours is a long time or not.

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com
--------------w9j1ifcj1VTA0ThV77y5zwWP--