Re: Never Ending query in PostgreSQL

From: Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com>
To: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Never Ending query in PostgreSQL
Date: 2022-03-01 03:54:44
Message-ID: 4cddaa9b-6435-709a-78bb-419fa8a78495@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Peter Adlersburg 2022-03-01 07:29:04 Re: Advice needed: query performance deteriorates by 2000% within 1 minute
Previous Message Mladen Gogala 2022-03-01 03:44:09 Re: Never Ending query in PostgreSQL