Re: CLUSTER details

2024-06-09 Thread David G. Johnston
On Friday, June 7, 2024, Bernd Eckenfels wrote: > > > As a user I want to know if CLUSTERing also frees space, and since it > has the effect of doing so (and not pre-allocates, which is a bit odd),why > not mention it. > Yeah, it doesn’t make it clear that rewriting the table means that only live

Re: I get ERROR: column "table_name" does not exist

2024-06-09 Thread Florian Koch
I made a gist with the error. https://gist.github.com/floratmin/a4b404f0fd66b03a0428c07686b71410 On Fri, Jun 7, 2024 at 3:24 AM Erik Wienhold wrote: > > On 2024-06-06 15:08 +0200, Florian Koch wrote: > > This is the working example, when I replace any of e.g. > > 'PG_EXCEPTION_HINT' with 'TABLE_N

Re: CLUSTER details

2024-06-09 Thread Bernd Eckenfels
I am mostly „hung up“ on extending the doc to make it even more usedul (by sharing my use cases). As a user I want to know if CLUSTERing also frees space, and since it has the effect of doing so (and not pre-allocates, which is a bit odd),why not mention it. Btw where is that friendly community t

Re: CLUSTER details

2024-06-09 Thread Bernd Eckenfels
Hello, David G. Johnston wrote on 7. June 2024 15:24 (GMT +02:00): > All of that is already covered on the page. You are right, I missed the note about the two modes and their storage consumption, I guess that part is described enough > If you think it needs > rewording I suggest you specify exa