Re: TOAST table performance problem

From: Asya Nevra Buyuksoy <ayisan1096(at)gmail(dot)com>
To: MichaelDBA <MichaelDBA(at)sqlexec(dot)com>
Cc: Andreas Joseph Krogh <andreas(at)visena(dot)com>, pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: TOAST table performance problem
Date: 2020-02-07 14:16:13
Message-ID: CADA48rEzqEWoJhYaTb1PU6C9=Qr8PB-SAUxA=9_vuJa5wv=ZiA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>
>
> Andreas Joseph Krogh wrote on 2/7/2020 8:41 AM:
>
> På fredag 07. februar 2020 kl. 14:23:35, skrev Asya Nevra Buyuksoy <
> ayisan1096(at)gmail(dot)com>:
>
>
> My guess is the time is spent in the *client* retrieving the data, not in
> the DB itself. Are you on a slow network?
>
> It works in my local area and speed is 1 Gbps. When I use
another local computer that has SSD disk the query execution time reduced
to 12 seconds. But this query has to execute my local computer.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andreas Joseph Krogh 2020-02-07 14:19:19 Re: TOAST table performance problem
Previous Message MichaelDBA 2020-02-07 13:52:26 Re: TOAST table performance problem