On Tue, 2023-01-31 at 09:34 -0300, Marcos Pegoraro wrote:
> Simon Riggs escreveu:
> > On Tue, 13 Sept 2022 at 13:29, Marcos Pegoraro wrote:
> > > >
> > > > What problem do they cause you?
> > >
> > >
> > > They don't cause any problem, I was just trying to get my database as
> > > clean as po
Simon Riggs escreveu:
> On Tue, 13 Sept 2022 at 13:29, Marcos Pegoraro wrote:
> >>
> >> What problem do they cause you?
> >
> >
> > They don'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
>
Gesendet: Dienstag, 13. September 2022 um 19:13 Uhr
Von: "Ron"
An: pgsql-general@lists.postgresql.org
Betreff: Re: toast useless
On 9/13/22 08:18, Simon Riggs wrote:
On Tue, 13 Sept 2022 at 13:29, Marcos Pegoraro wrote:
What problem do they cause you?
They don't cause
On 9/13/22 08:18, Simon Riggs wrote:
On Tue, 13 Sept 2022 at 13:29, Marcos Pegoraro wrote:
What problem do they cause you?
They don'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
e
On Tue, 13 Sept 2022 at 13:29, Marcos Pegoraro wrote:
>>
>> What problem do they cause you?
>
>
> They don'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 t
>
> What problem do they cause you?
>
They don'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
On Tue, 13 Sept 2022 at 12:45, Marcos Pegoraro wrote:
> So, there is a way to eliminate these useless toast tables ?
What problem do they cause you?
--
Simon Riggshttp://www.EnterpriseDB.com/
create table test(x integer, y integer, w varchar(50), z varchar(80));
When a table has well defined sizes all their data is stored on heap, so
they doesn´t need to be toasted, and no toast table is created. Fine.
But then I want to store last modification of that record, so I do ...
alter table t
