Request a Demo
Home   >   mailing lists

Re: Fillfactor effectiveness on existing table - Mailing list pgsql-general

From Durgamahesh Manne
Subject Re: Fillfactor effectiveness on existing table
Date
Msg-id CAJCZkoLBd1A14rCVW6=xH7mUncxVzyYd8dNgQ+z6d36pOcXdFg@mail.gmail.com
Whole thread
In response to Re: Fillfactor effectiveness on existing table  (Durgamahesh Manne <maheshpostgres9@gmail.com>)
List pgsql-general
Tree view
Hi

All updates are HOT as per my observation 

With one day bloat I see about 70 gb 
Actual size of table is around 10gb only 

I see strange behaviour even of completing repack activity for 14 and as well as for 16  in the log

I think there was an issue at code side 
How to fix this 

2026-02-14 00:14:31.662 UTC,"offer","offer",674993,"127.0.0.1:28840",698fb1a0.a4cb1,376,"idle",2026-02-13 23:20:00 UTC,67/0,0,ERROR,26000,"unnamed prepared statement does not exist",,,,,,,,,"e3d","client backend",,2064869707185898531 2026-02-14 00:14:31.792 UTC,"offer","offer",675945,"127.0.0.1:50690",698fb3f8.a5069,482,"ROLLBACK",2026-02-13 23:30:00 UTC,113/111425,3142683,LOG,00000,"temporary file: path ""base/pgsql_tmp/pgsql_tmp675945.44"", size 62053892",,,,,,"ROLLBACK",,,"e3d","client backend",,3749380189022910195 2026-02-14 00:14:32.849 UTC,"offer","offer",673259,"127.0.0.1:17360",698facf0.a45eb,842,"ROLLBACK",2026-02-13 23:00:00 UTC,65/168038,3142686,LOG,00000,"temporary file: path ""base/pgsql_tmp/pgsql_tmp673259.41"", size 64701020",,,,,,"ROLLBACK",,,"e3d","client backend",,3749380189022910195 2026-02-14 00:14:33.299 UTC,"offer","offer",675945,"127.0.0.1:50690",698fb3f8.a5069,483,"idle",2026-02-13 23:30:00 UTC,113/0,0,ERROR,26000,"unnamed prepared statement does not exist",,,,,,,,,"e3d","client backend",,2064869707185898531 2026-02-14 00:14:33.299 UTC,"offer","offer",675945,"127.0.0.1:50690",698fb3f8.a5069,484,"idle",2026-02-13 23:30:00 UTC,113/0,0,ERROR,26000,"unnamed prepared statement does not exist",,,,,,,,,"e3d","client backend",,2064869707185898531 2026-02-14 00:14:34.159 UTC,"offer","offer",674349,"127.0.0.1:61350",698fb074.a4a2d,396,"ROLLBACK",2026-02-13 23:15:00 UTC,49/153459,3142912,LOG,00000,"temporary file: path ""base/pgsql_tmp/pgsql_tmp674349.29"", size 44533064",,,,,,"ROLLBACK",,,"e3d","client backend",,3749380189022910195

Regards

Durga Mahesh

On Wed, 11 Feb, 2026, 14:23 Durgamahesh Manne, <maheshpostgres9@gmail.com> wrote:


On Wed, 11 Feb, 2026, 12:07 Laurenz Albe, <laurenz.albe@cybertec.at> wrote:
On Wed, 2026-02-11 at 07:58 +0530, Durgamahesh Manne wrote:
> Hi 
> @Laurenz Albe 
> offer=> SELECT relname AS table_name, n_tup_upd AS updates, n_tup_hot_upd AS hot_updates FROM pg_stat_all_tables WHERE relname = 'market'; 
> table_name | updates | hot_updates 
> market | 5997455764 | 3752865557

Did you read my e-mail?

Yours,
Laurenz Albe


Hi

Yes I have read. Will check get back to you soon. On fly info given earlier 

Regards
Durga Mahesh

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Best practice for granting folder read/write permission on Windows
Next
From: Igor Korot
Date:
Subject: PRIMARY KEY parameters