Query is sometimes fast and sometimes slow: what could be the reason?

From: tiaswin(at)gmx(dot)de
To: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Query is sometimes fast and sometimes slow: what could be the reason?
Date: 2022-09-14 15:02:07
Message-ID: trinity-e7635062-7f0a-42dc-985c-6af74dfa1787-1663167727005@3c-app-gmx-bs70
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>What could be the reason of a query, which is sometimes fast and sometimes slow (factor &gt;10x)?</div>

<div>(running on a large table).</div>

<div>&nbsp;</div>

<div>&nbsp;</div></div></body></html>

Attachment Content-Type Size
unknown_filename text/html 288 bytes

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Justin Pryzby 2022-09-14 15:59:53 Re: Query is sometimes fast and sometimes slow: what could be the reason?
Previous Message Gunther Schadow 2022-09-13 09:42:40 Faster more low-level methods of having hot standby / secondary read-only servers?