Re: Top -N Query performance issue and high CPU usage

From: Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Top -N Query performance issue and high CPU usage
Date: 2026-02-02 07:45:31
Message-ID: 444efcf3-845b-424e-8311-0bd29ad9d9e1@gelassene-pferde.biz
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message yudhi s 2026-02-02 11:39:21 Re: Top -N Query performance issue and high CPU usage
Previous Message yudhi s 2026-02-02 06:33:08 Re: Top -N Query performance issue and high CPU usage