Horton
Menu

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

Thiemo Kellner <thiemo@gelassene-pferde.biz>

View thread
From: Thiemo Kellner <thiemo@gelassene-pferde.biz>
To: pgsql-general@lists.postgresql.org
Date: 2026-02-02T07:45:31Z
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