Postgres Pro
Downloads
Home   >   mailing lists

Re: Query slow for new participants - Mailing list pgsql-performance

From Justin Pryzby
Subject Re: Query slow for new participants
Date
Msg-id 20190225161607.GQ28750@telsasoft.com
Whole thread Raw
In response to Query slow for new participants  (Kim <support@mekong.be>)
Responses Re: Query slow for new participants  ("support@mekong.be" <support@mekong.be>)
Re: Query slow for new participants  ("support@mekong.be" <support@mekong.be>)
List pgsql-performance
Tree view 
On Mon, Feb 25, 2019 at 03:41:18AM -0700, Kim wrote:
> Is there any way how I can make the queries fast for new participants? This
> is a big problem, because for new participants, speed is even more
> important.
> 
> Thank you for your help.

Could you include information requested here ?
https://wiki.postgresql.org/wiki/Slow_Query_Questions

Justin

pgsql-performance by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Idle backends outside a transaction holding onto large amounts ofmemory / swap space?
Next
From: Corey Huinker
Date:
Subject: Re: Massive parallel queue table causes index deterioration, butREINDEX fails with deadlocks.