Request a Demo
Home   >   mailing lists

Re: Top -N Query performance issue and high CPU usage - Mailing list pgsql-general

From Thiemo Kellner
Subject Re: Top -N Query performance issue and high CPU usage
Date
Msg-id 444efcf3-845b-424e-8311-0bd29ad9d9e1@gelassene-pferde.biz
Whole thread Raw
In response to Re: Top -N Query performance issue and high CPU usage  (yudhi s <learnerdatabase99@gmail.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: yudhi s
Date:
Subject: Re: Top -N Query performance issue and high CPU usage
Next
From: yudhi s
Date:
Subject: Re: Top -N Query performance issue and high CPU usage