- Notifications
You must be signed in to change notification settings - Fork1.2k
postgres version 16 onwards is consuming entire disk space within container (possible disk spill is happenning)#1320
Uh oh!
There was an error while loading.Please reload this page.
Uh oh!
There was an error while loading.Please reload this page.
-
I have created a stored procedure: CREATEOR REPLACE PROCEDURE TEL1PrepUploadTables(IN Datasettext) LANGUAGE PLPGSQLAS \$\$BEGIN EXECUTE format('CREATE TABLE "add_cell_raw_%s" PARTITION OF add_cell_raw FOR VALUES IN (''%s'');',Dataset,Dataset); EXECUTE format('CREATE TABLE "del_cell_id_raw_%s" PARTITION OF del_cell_id_raw FOR VALUES IN (''%s'');',Dataset,Dataset); EXECUTE format('CREATE OR REPLACE VIEW add_cell_raw_latest AS SELECT * FROM "add_cell_raw_%s";',Dataset); EXECUTE format('CREATE OR REPLACE VIEW del_cell_id_raw_latest AS SELECT * FROM "del_cell_id_raw_%s";', Dataset); END; \$\$; in this procedure there is a step to create or replace view add_cell_raw_latest...
Now when this CREATE VIEW runs internally postgres runs the following step to create the VIEW
Now the ISSUE is i have created a kubernetes container using Observation
As I said this issue coming from postgres images 16 and onwards... I am reading some articles where to increase the query performance could lead to disk spill of the data in postgres... please look into it and fix it |
BetaWas this translation helpful?Give feedback.
All reactions
Replies: 5 comments
Uh oh!
There was an error while loading.Please reload this page.
Uh oh!
There was an error while loading.Please reload this page.
-
Can you run
|
BetaWas this translation helpful?Give feedback.
All reactions
-
This is the screen shot of version 17 postgres image... but the database is still in healthy state... i can't give you the same data when it gets corrupted as when the container goes bad and i cannot run this command. |
BetaWas this translation helpful?Give feedback.
All reactions
-
How many time has the corrupted db pod restarted? |
BetaWas this translation helpful?Give feedback.
All reactions
-
Can you give this a try?https://stackoverflow.com/a/72740536 |
BetaWas this translation helpful?Give feedback.
All reactions
-
I waited
I waited for couple of hours for it to restore... But it was in same state |
BetaWas this translation helpful?Give feedback.
All reactions
This discussion was converted from issue #1317 on February 18, 2025 21:26.