template1 is a default database in PostgreSQL which is used as a template when you create new databases and should never be dropped.
The vacuuming was a shot in the dark but is always what you should try first in table bloat situations because PostgreSQL never deleted things when you tell it to it instead marks all versions of the column as invalid and recyclable.
I'll get back to you with some more ideas when I get back into the office on Sunday and can tinker with my test instance a little
-- Sent from my HP Pre3
On Dec 19, 2013 4:41, Balint Szigeti <[email protected]> wrote:
hello
I've run the command and got this:
bash-4.1$ vacuumdb -azf
vacuumdb: vacuuming database "postgres"
vacuumdb: vacuuming database "spaceschema"
vacuumdb: vacuuming database "template1"
vacuumdb: could not connect to database template1: FATAL: no pg_hba.conf entry for host "[local]", user "postgres", database "template1", SSL off
I don't think, I have template1. Maybe is it a default schema? The used space didn't change.
Balint
On 18/12/13 20:42, Paul Robert Marino wrote:
I've run the command and got this:
bash-4.1$ vacuumdb -azf
vacuumdb: vacuuming database "postgres"
vacuumdb: vacuuming database "spaceschema"
vacuumdb: vacuuming database "template1"
vacuumdb: could not connect to database template1: FATAL: no pg_hba.conf entry for host "[local]", user "postgres", database "template1", SSL off
I don't think, I have template1. Maybe is it a default schema? The used space didn't change.
Balint
On 18/12/13 20:42, Paul Robert Marino wrote:
I know I say this often but if you are running PostgreSQL8.x first try a "vacuumdb -azf"On Wed, Dec 18, 2013 at 1:51 AM, Balint Szigeti <[email protected]> wrote:Hello All, Do you all have a 'best practise' about how should be maintained the DB? It's growing and growing. I think, it stores history data or what else but, my disk capacity is almost reached the end of it. What should I do? Adding new disk, is the final scenario. At first I'd like to purge the unwanted or obsolete data from DB. Do you have any advice how I should do it? Balint _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
