Received-SPF: pass (ha01s018.org-dns.com: connection is authenticated)
Date: Mon, 2 Feb 2026 08:45:31 +0100
From: Thiemo Kellner <thiemo@gelassene-pferde.biz>
To: pgsql-general@lists.postgresql.org
Message-ID: <444efcf3-845b-424e-8311-0bd29ad9d9e1@gelassene-pferde.biz>
In-Reply-To: 
 <CAEzWdqfZ6mbtjM1GPBp1LthS=MGUYng3Pw6hj+g6+054BA4VqA@mail.gmail.com>
References: 
 <CAEzWdqf+b+7JDRNzJVqWKyF8N8Aa2CZC5B_o1xZLDWozqV-RUA@mail.gmail.com>
 <63F54040-608A-4ED4-A23C-E6767FF87088@gmail.com>
 <CAEzWdqfZ6mbtjM1GPBp1LthS=MGUYng3Pw6hj+g6+054BA4VqA@mail.gmail.com>
Subject: Re: Top -N Query performance issue and high CPU usage
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_3_139367495.1770018331826"
Archived-At: <https://www.postgresql.org/message-id/444efcf3-845b-424e-8311-0bd29ad9d9e1%40gelassene-pferde.biz>
Precedence: bulk

------=_Part_3_139367495.1770018331826
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

Hi

Would it do any good to restrict the transaction date for the limit to something like "current timestamp - 1 day/hour/month". How about partitioning?

My two dimes

Thiemo

------=_Part_3_139367495.1770018331826
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<html>
 <head>
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
 </head>
 <body>
  <span dir="ltr" style="margin-top:0; margin-bottom:0;">Hi</span>
  <br>
  <br><span dir="ltr" style="margin-top:0; margin-bottom:0;">Would it do any good to restrict the transaction date for the limit to something like "current timestamp - 1 day/hour/month". How about partitioning?</span>
  <br>
  <br><span dir="ltr" style="margin-top:0; margin-bottom:0;">My two dimes</span>
  <br>
  <br><span dir="ltr" style="margin-top:0; margin-bottom:0;">Thiemo</span>
  <br>
 </body>
</html>
------=_Part_3_139367495.1770018331826--