Re: [BUGS] Giant TOAST tables due to many almost empty pages

2010-05-13 Thread Rumko
On Thursday 13. of May 2010 17:24:47 Tom Lane wrote: Rumko rum...@gmail.com writes: Tom Lane wrote: There's something extremely wacko about that vacuum output. Regarding storage paramaters, you mean ALTER TABLE x SET STORAGE...? Then no. No, I was wondering about ALTER TABLE ... SET

[BUGS] Bug report (#5456) not showing up on the ML

2010-05-12 Thread Rumko
believe it was #5456, but am not 100% sure (bad memory and didn't save the number). Thank you -- Regards, Rumko signature.asc Description: This is a digitally signed message part.

Re: [BUGS] Giant TOAST tables due to many almost empty pages

2010-05-12 Thread Rumko
Tom Lane wrote: snip There's something extremely wacko about that vacuum output. A toast table should have few, if any, rows that short. And it's impossible to believe there's no free space at all in the table, especially since 122*3259181 bytes is still quite a lot less than 3259181