Christophe Pettus writes:
>> On Feb 1, 2023, at 10:45, David G. Johnston
>> wrote:
>> The system just isn't that intelligent for "sequential scan", instead it
>> does literally what the label says, goes through the table one page at a
>> time and returns any live rows it finds.
> Although th
> On Feb 1, 2023, at 10:45, David G. Johnston
> wrote:
> The system just isn't that intelligent for "sequential scan", instead it does
> literally what the label says, goes through the table one page at a time and
> returns any live rows it finds.
Although this does raise a question: Could
On Wed, Feb 1, 2023 at 11:27 AM Dimitrios Apostolou wrote:
> I have now run simple VACUUM but it didn't change anything, the simple
> SELECT is still slow.
>
> My understanding by reading the docs is that it should reclaim all unused
> space, just not return it to the OS. Which is fine by me. Any
Thanks everyone for the help.
I have now run simple VACUUM but it didn't change anything, the simple
SELECT is still slow.
My understanding by reading the docs is that it should reclaim all unused
space, just not return it to the OS. Which is fine by me. Any idea why it
failed to reclaim the spa
