Re: Fwd: TOAST table performance problem

Ok, you are right. Thanks for everything. Jeff Janes , 10 Şub 2020 Pzt, 15:54 tarihinde şunu yazdı: > On Mon, Feb 10, 2020 at 7:38 AM Asya Nevra Buyuksoy > wrote: > >> Got it, thanks! I understand and know it that PostgreSQL is not slow, but >> I want to a piece of advic

Re: Fwd: TOAST table performance problem

Got it, thanks! I understand and know it that PostgreSQL is not slow, but I want to a piece of advice how can I load this data fastly :) Luís Roberto Weck , 10 Şub 2020 Pzt, 15:31 tarihinde şunu yazdı: > -- Forwarded message - > Gönderen: Asya Nevra Buyuksoy > Date: 10

Fwd: TOAST table performance problem

-- Forwarded message - Gönderen: Asya Nevra Buyuksoy Date: 10 Şub 2020 Pzt, 10:51 Subject: Re: TOAST table performance problem To: Andreas Joseph Krogh I copied my data to the CSV file, yes it is very fast. However, this does not solve my problem. After deserializing the on the

Re: TOAST table performance problem

zamazin; It takes 94 ms. :) Andreas Joseph Krogh , 7 Şub 2020 Cum, 17:42 tarihinde şunu yazdı: > På fredag 07. februar 2020 kl. 15:35:04, skrev Asya Nevra Buyuksoy < > ayisan1...@gmail.com>: > > I use pgadmin3. > > > Try "psql", it has the lowest overhead (I think)

Re: TOAST table performance problem

> > > Andreas Joseph Krogh wrote on 2/7/2020 8:41 AM: > > På fredag 07. februar 2020 kl. 14:23:35, skrev Asya Nevra Buyuksoy < > ayisan1...@gmail.com>: > > > My guess is the time is spent in the *client* retrieving the data, not in > the DB itself. Are you on a

Re: TOAST table performance problem

> > Andreas Joseph Krogh , 7 Şub 2020 Cum, 16:12 > tarihinde şunu yazdı: > >> På fredag 07. februar 2020 kl. 14:07:28, skrev Asya Nevra Buyuksoy < >> ayisan1...@gmail.com>: >> >> >> >> *[...]* >> >> *And of course you'll be en

Re: TOAST table performance problem

permmsgid=msg-a:r3734143643823656667&view=att&disp=safe&realattid=f_k6c77tsa1> Andreas Joseph Krogh , 7 Şub 2020 Cum, 16:12 tarihinde şunu yazdı: > På fredag 07. februar 2020 kl. 14:07:28, skrev Asya Nevra Buyuksoy < > ayisan1...@gmail.com>: > > Hello everybody, > &

TOAST table performance problem

Hello everybody, I have trouble with my table that has four columns which their data types are text, JSON, boolean and timestamp. Also, I have 1K rows, but my JSON column size approximately 110KB and maybe over it. When I select all the data from my table, it takes 600 seconds. But I explain