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 <luisrobe...@siscobra.com.br>, 10 Şub 2020 Pzt, 15:31 tarihinde şunu yazdı: > ---------- Forwarded message --------- > Gönderen: Asya Nevra Buyuksoy <ayisan1...@gmail.com> > Date: 10 Şub 2020 Pzt, 10:51 > Subject: Re: TOAST table performance problem > To: Andreas Joseph Krogh <andr...@visena.com> > > > 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 front side, I want to visualize my data on > the web page effectively. > When I select my data one by one with a limit clause, the query executes > 200 ms. For example, If I create a function that takes data with a loop, > the execution time will be 200 ms*1000=200 sec. > > > Andreas Joseph Krogh <andr...@visena.com>, 7 Şub 2020 Cum, 18:15 > tarihinde şunu yazdı: > >> Try \o <filename> in psql, to redirect the output to file, and prevent it >> from processing the json (ie. format it) >> >> Den 7. februar 2020 15:59:05 CET, skrev Asya Nevra Buyuksoy < >> ayisan1...@gmail.com>: >>> >>> I try it, but there is no enhancement. >>> I read this link is about TOAST and also its sub_links; >>> https://blog.gojekengineering.com/a-toast-from-postgresql-83b83d0d0683 >>> When I execute this query, except JSON data like; >>> SELECT paramuser_id, paramperson_id, paramisdeleted, paramactiontime >>> FROM zamazin; >>> It takes 94 ms. :) >>> >>> >>> Andreas Joseph Krogh <andr...@visena.com>, 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). pgAdmin might use >>>> time presenting the results etc. which is easy to overlook. >>>> >>>> -- >>>> Andreas Joseph Krogh >>>> >>> >> -- >> Sendt fra min Android-enhet med K-9 e-post. Unnskyld min kortfattethet. >> > > What Andreas is trying to say is that it's not PostgreSQL that is slow to > read the JSON, but your client app that is slow to parse it. >
