Mixing
postgres lo_unlink not deleting objects
Im little bit new in postgres, but I have problem related with disk space. now I have 2GB free space, I need to delete some of largeobjects. Situation is like this:
I have table espbidocuments that stores OID with ID to pg_largeobject table where is stored my files. pg_largeobject now is 87,201,636,352 bytes size and I need to shrink. I tried deleting references from espbidocuments, so LO will be orphans, then I ran function lo_unlink(oid) and get result 1, so I think that my files are deleted, but still when I selecting from pg_largeobject table, I get that they exist in that table and pg_largeobject table size is not lesser, size is the same. I cant do vacuum because tables size is 80+GB and free space is ~2GB... how remove those darn largeobject?
postgresql
asked Nov 21 '18 at 7:39
Paulius JanuleviciusPaulius Janulevicius
1
add a comment |
Im little bit new in postgres, but I have problem related with disk space. now I have 2GB free space, I need to delete some of largeobjects. Situation is like this:
I have table espbidocuments that stores OID with ID to pg_largeobject table where is stored my files. pg_largeobject now is 87,201,636,352 bytes size and I need to shrink. I tried deleting references from espbidocuments, so LO will be orphans, then I ran function lo_unlink(oid) and get result 1, so I think that my files are deleted, but still when I selecting from pg_largeobject table, I get that they exist in that table and pg_largeobject table size is not lesser, size is the same. I cant do vacuum because tables size is 80+GB and free space is ~2GB... how remove those darn largeobject?
postgresql
asked Nov 21 '18 at 7:39
Paulius JanuleviciusPaulius Janulevicius
1
This is not a programming question so it is off-topic on stackoverflow. See stackoverflow.com/help/on-topic , Minimal, Complete, and Verifiable example and How to Ask for further informations.
– quant
Nov 21 '18 at 7:55
But alot of questions about this are in stackoverflow. So I asked it. I did not found answer in other questions, why my largeobejcts is not deleting from database, what commands should I use.
– Paulius Janulevicius
Nov 21 '18 at 8:24
Please come up with a reproducible test case that illustrates your claim. SQL, not words, will make the case clear.
– Laurenz Albe
Nov 21 '18 at 19:22
add a comment |
Im little bit new in postgres, but I have problem related with disk space. now I have 2GB free space, I need to delete some of largeobjects. Situation is like this:
I have table espbidocuments that stores OID with ID to pg_largeobject table where is stored my files. pg_largeobject now is 87,201,636,352 bytes size and I need to shrink. I tried deleting references from espbidocuments, so LO will be orphans, then I ran function lo_unlink(oid) and get result 1, so I think that my files are deleted, but still when I selecting from pg_largeobject table, I get that they exist in that table and pg_largeobject table size is not lesser, size is the same. I cant do vacuum because tables size is 80+GB and free space is ~2GB... how remove those darn largeobject?
postgresql
asked Nov 21 '18 at 7:39
Paulius JanuleviciusPaulius Janulevicius
1
Im little bit new in postgres, but I have problem related with disk space. now I have 2GB free space, I need to delete some of largeobjects. Situation is like this:
I have table espbidocuments that stores OID with ID to pg_largeobject table where is stored my files. pg_largeobject now is 87,201,636,352 bytes size and I need to shrink. I tried deleting references from espbidocuments, so LO will be orphans, then I ran function lo_unlink(oid) and get result 1, so I think that my files are deleted, but still when I selecting from pg_largeobject table, I get that they exist in that table and pg_largeobject table size is not lesser, size is the same. I cant do vacuum because tables size is 80+GB and free space is ~2GB... how remove those darn largeobject?
postgresql
postgresql
asked Nov 21 '18 at 7:39
Paulius JanuleviciusPaulius Janulevicius
1
asked Nov 21 '18 at 7:39
Paulius JanuleviciusPaulius Janulevicius
1
asked Nov 21 '18 at 7:39
Paulius JanuleviciusPaulius Janulevicius
1
asked Nov 21 '18 at 7:39
Paulius JanuleviciusPaulius Janulevicius
1
asked Nov 21 '18 at 7:39
Paulius JanuleviciusPaulius Janulevicius
1
1
This is not a programming question so it is off-topic on stackoverflow. See stackoverflow.com/help/on-topic , Minimal, Complete, and Verifiable example and How to Ask for further informations.
– quant
Nov 21 '18 at 7:55
But alot of questions about this are in stackoverflow. So I asked it. I did not found answer in other questions, why my largeobejcts is not deleting from database, what commands should I use.
– Paulius Janulevicius
Nov 21 '18 at 8:24
Please come up with a reproducible test case that illustrates your claim. SQL, not words, will make the case clear.
– Laurenz Albe
Nov 21 '18 at 19:22
add a comment |
This is not a programming question so it is off-topic on stackoverflow. See stackoverflow.com/help/on-topic , Minimal, Complete, and Verifiable example and How to Ask for further informations.
– quant
Nov 21 '18 at 7:55
But alot of questions about this are in stackoverflow. So I asked it. I did not found answer in other questions, why my largeobejcts is not deleting from database, what commands should I use.
– Paulius Janulevicius
Nov 21 '18 at 8:24
Please come up with a reproducible test case that illustrates your claim. SQL, not words, will make the case clear.
– Laurenz Albe
Nov 21 '18 at 19:22
This is not a programming question so it is off-topic on stackoverflow. See stackoverflow.com/help/on-topic , Minimal, Complete, and Verifiable example and How to Ask for further informations.
– quant
Nov 21 '18 at 7:55
This is not a programming question so it is off-topic on stackoverflow. See stackoverflow.com/help/on-topic , Minimal, Complete, and Verifiable example and How to Ask for further informations.
– quant
Nov 21 '18 at 7:55
But alot of questions about this are in stackoverflow. So I asked it. I did not found answer in other questions, why my largeobejcts is not deleting from database, what commands should I use.
– Paulius Janulevicius
Nov 21 '18 at 8:24
But alot of questions about this are in stackoverflow. So I asked it. I did not found answer in other questions, why my largeobejcts is not deleting from database, what commands should I use.
– Paulius Janulevicius
Nov 21 '18 at 8:24
Please come up with a reproducible test case that illustrates your claim. SQL, not words, will make the case clear.
– Laurenz Albe
Nov 21 '18 at 19:22
Please come up with a reproducible test case that illustrates your claim. SQL, not words, will make the case clear.
– Laurenz Albe
Nov 21 '18 at 19:22
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53407281%2fpostgres-lo-unlink-not-deleting-objects%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53407281%2fpostgres-lo-unlink-not-deleting-objects%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
This is not a programming question so it is off-topic on stackoverflow. See stackoverflow.com/help/on-topic , Minimal, Complete, and Verifiable example and How to Ask for further informations.
– quant
Nov 21 '18 at 7:55
But alot of questions about this are in stackoverflow. So I asked it. I did not found answer in other questions, why my largeobejcts is not deleting from database, what commands should I use.
– Paulius Janulevicius
Nov 21 '18 at 8:24
Please come up with a reproducible test case that illustrates your claim. SQL, not words, will make the case clear.
– Laurenz Albe
Nov 21 '18 at 19:22