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 advice how can I load this d

Re: Fwd: TOAST table performance problem

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 advice how can I load this data fastly :) > You haven't told us anything about your client, so what advice can we offer? Unless the bottl

Re: Fwd: TOAST table performance problem

Ş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 front side, I want to visualize my data on >

Re: Fwd: TOAST table performance problem

-- Forwarded message - Gönderen: *Asya Nevra Buyuksoy* <mailto:ayisan1...@gmail.com>> Date: 10 Şub 2020 Pzt, 10:51 Subject: Re: TOAST table performance problem To: Andreas Joseph Krogh mailto:andr...@visena.com>> I copied my data to the CSV file, yes it is ver

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

Try \o 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 : >I try it, but there is no enhancement. >I read this link is about TOAST and also its sub_links; >https://blog.gojekengineering.c

Re: TOAST table performance problem

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

Re: TOAST table performance problem

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

Re: TOAST table performance problem

På fredag 07. februar 2020 kl. 15:16:13, skrev Asya Nevra Buyuksoy < ayisan1...@gmail.com >: 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 >:

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 slow network? > >It w

Re: TOAST table performance problem

Yes, I would concur that this planning time and execution time do not take into account the network time sending the data back to the client, especially since your are sending back the entire contents of the table. Regards, Michael Vitale Andreas Joseph Krogh wrote on 2/7/2020 8:41 AM: På fred

Re: TOAST table performance problem

På fredag 07. februar 2020 kl. 14:23:35, skrev Asya Nevra Buyuksoy < ayisan1...@gmail.com >: Sorry for the misunderstanding. I have a table like; CREATE TABLE zamazin ( paramuser_id text, paramperson_id integer, paramdata json, paramisdeleted boolean, paramac

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 encurraged to upgrade to latest version (12.1) >> as 9.4.1 is now 5 years o

Re: TOAST table performance problem

Sorry for the misunderstanding. I have a table like; CREATE TABLE zamazin ( paramuser_id text, paramperson_id integer, paramdata json, paramisdeleted boolean, paramactiontime timestamp without time zone ) paramdata row size is 110KB and over. When I execute this query like; *select * fro

Sv: TOAST table performance problem

På fredag 07. februar 2020 kl. 14:07:28, skrev Asya Nevra Buyuksoy < ayisan1...@gmail.com >: Hello everybody, [...] How I can achieve good performance? Nobody here understands anything unless you show the exact query and schema... And of course you'll be encurr

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