Postgres Pro
Downloads
Home   >   mailing lists

Re: TOAST table performance problem - Mailing list pgsql-performance

From Asya Nevra Buyuksoy
Subject Re: TOAST table performance problem
Date
Msg-id CADA48rE2DNh__WfU8v=CVL4wNypPXqrm_ikRDZiuahERoDCnbA@mail.gmail.com
Whole thread Raw
In response to Sv: TOAST table performance problem  (Andreas Joseph Krogh <andreas@visena.com>)
Responses Re: TOAST table performance problem  (Asya Nevra Buyuksoy <ayisan1096@gmail.com>)
Re: TOAST table performance problem  (Andreas Joseph Krogh <andreas@visena.com>)
List pgsql-performance
Tree view
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 * from zamazin
it takes 600 seconds.
But when analyze the query ;
"Seq Scan on public.zamazin  (cost=0.00..21.77 rows=1077 width=49) (actual time=0.008..0.151 rows=1077 loops=1)"
"  Output: paramuser_id, paramperson_id, paramdata, paramisdeleted, paramactiontime"
"  Buffers: shared hit=11"
"Planning time: 0.032 ms"
"Execution time: 0.236 ms"
 Why the query takes a long time, I do not understand. I assume that this relates to the TOAST structure.


Andreas Joseph Krogh <andreas@visena.com>, 7 Şub 2020 Cum, 16:12 tarihinde şunu yazdı:
På fredag 07. februar 2020 kl. 14:07:28, skrev Asya Nevra Buyuksoy <ayisan1096@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 encurraged to upgrade to latest version (12.1) as 9.4.1 is now 5 years old..
 
--
Andreas Joseph Krogh
Attachment

pgsql-performance by date:

Previous
From: Andreas Joseph Krogh
Date:
Subject: Sv: TOAST table performance problem
Next
From: Asya Nevra Buyuksoy
Date:
Subject: Re: TOAST table performance problem