select performance.

From: Dhandapani Shanmugam <postgresql95(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: select performance.
Date: 2018-08-10 08:12:21
Message-ID: CAAj4MFFfjh5kFcDbsWHCFQ=5b=nFYagQ1hkZQABLGtutCoE3uQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All,

My application does select with were condition using IN function on only
one table and I see slow response from front end. Please clarify me, do we
have options like memory tables or is it possible to pin entire table in
memory or do we have any option to improve only select statement.

-Dhandapani

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Fabio Pardi 2018-08-10 08:35:11 Re: select performance.
Previous Message Achilleas Mantzios 2018-08-10 06:42:37 Re: Logical Replication in Postgres 10.4