Aw: Re: toast useless

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Aw: Re: toast useless
Date: 2022-09-13 17:16:22
Message-ID: trinity-91a26717-4775-459e-b785-88dc139cfa1f-1663089382384@3c-app-gmx-bap59
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>
<div><b>Gesendet:</b>&nbsp;Dienstag, 13. September 2022 um 19:13 Uhr
<div name="quote" style="margin:10px 5px 5px 10px; padding: 10px 0 10px 10px; border-left:2px solid #C3D9E5; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">
<div style="margin:0 0 10px 0;"><b>Von:</b>&nbsp;&quot;Ron&quot; &lt;ronljohnsonjr(at)gmail(dot)com&gt;<br/>
<b>An:</b>&nbsp;pgsql-general(at)lists(dot)postgresql(dot)org<br/>
<b>Betreff:</b>&nbsp;Re: toast useless</div>

<div name="quoted-content">On 9/13/22 08:18, Simon Riggs wrote:
<blockquote>
<pre class="moz-quote-pre">On Tue, 13 Sept 2022 at 13:29, Marcos Pegoraro <a class="moz-txt-link-rfc2396E" href="mailto:marcos(at)f10(dot)com(dot)br" onclick="parent.window.location.href=&#39;mailto:marcos(at)f10(dot)com(dot)br&#39;; return false;" target="_blank">&lt;marcos(at)f10(dot)com(dot)br&gt;</a> wrote:
</pre>

<blockquote>
<blockquote>
<pre class="moz-quote-pre">What problem do they cause you?
</pre>
</blockquote>

<pre class="moz-quote-pre">They don&#39;t cause any problem, I was just trying to get my database as clean as possible.
I have some thousands of these toast tables with 8k bytes, so I was trying to eliminate them
But if there is no way, ok
</pre>
</blockquote>

<pre class="moz-quote-pre">They might be optimized away one day, but for now, they are essential.</pre>
</blockquote>

<div><br/>
&gt; Why are they <b>essential</b>?<br/>
&nbsp;</div>

<div>Essential to proper operation of the database code as of now.</div>

<div>&nbsp;</div>

<div>Best, Karsten</div>
</div>
</div>
</div>
</div></div></body></html>

Attachment Content-Type Size
unknown_filename text/html 1.6 KB

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bryn Llewellyn 2022-09-13 18:23:29 Re: Is it possible to stop sessions killing eachother when they all authorize as the same role?
Previous Message Ron 2022-09-13 17:13:30 Re: toast useless