Re: [GENERAL] How to free disk space
On Wed, Oct 22, 2008 at 2:46 AM, Grzegorz Jaśkiewicz <[EMAIL PROTECTED]> wrote: > what's the version you're running ? you shouldn't run into that problem too > often with 8.3 I'm running 8.3.3 soon to be 8.3.4 or .5 if there's a bug fix due out. There's only so much the autovacuum daemon can do when a rogue query runs an update on a whole table several times in a row. The rogue query has been eliminated from our app, but the damage was already done. -- When fascism comes to America, it will be draped in a flag and carrying a cross - Sinclair Lewis -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] How to free disk space
what's the version you're running ? you shouldn't run into that problem too often with 8.3 just like guys said here, regular vacuum, and reindex once in a while.
Re: [GENERAL] How to free disk space
On Tue, Oct 21, 2008 at 10:46 AM, Robert Treat <[EMAIL PROTECTED]> wrote: > On Tuesday 21 October 2008 09:00:30 postgres Emanuel CALVO FRANCO wrote: >> After run VACUUM, you must run REINDEXDB to decrease indexes. >> > > This is probably overkill, as you won't need to do this for a lot of tables in > your database, and the locking issues are probably unhelpful. Note, however, that if you have scheduled downtime and your db server is fast enough, you can schedule a vacuum full / reindexdb during that time. We had a rogue query that made a few of our largest tables very very bloated (like 95% bloat) and we had some downtime to fix it and it was way easier to just do the whole db with vacuum full verbose, then reindex. I also had a chacne to set fill factors on some of the tables that I'd wanted new fill factors on. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] How to free disk space
On Tuesday 21 October 2008 09:00:30 postgres Emanuel CALVO FRANCO wrote: > After run VACUUM, you must run REINDEXDB to decrease indexes. > This is probably overkill, as you won't need to do this for a lot of tables in your database, and the locking issues are probably unhelpful. > You can pg_resetxlog too, but you need restart server to do that. > No No No!!! You should never ever ever run pg_resetxlog on a production machine!! I'm not sure where you got this idea, but it is a bad one to be sure! > 2008/10/21 Ruben Blanco <[EMAIL PROTECTED]>: > > Hi: > > > > My database is growing fast taking too much disk space. How can I free > > disk space without performing a VACCUM FULL? It locks the database for > > several hours, and that is not a solution. > > > > I guess a backup-restore would do the work but, isn't there a better way > > to do this without shutting down postgres? > > > > Thanks in advandce. > > -- > Emanuel Calvo Franco > Syscope Postgresql DBA > BaPUG Member -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] How to free disk space
On 21/10/2008 11:59, Ruben Blanco wrote: > My database is growing fast taking too much disk space. How can I free > disk space without performing a VACCUM FULL? It locks the database for > several hours, and that is not a solution. You shouldn't need to do VACUUM FULL - plain VACUUM should do the job. Have a trawl through the archives, as this topic comes up regularly. Ray. -- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals -- -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] How to free disk space
On Tue, 2008-10-21 at 11:59 +0100, Ruben Blanco wrote: > My database is growing fast taking too much disk space. Are you running regular vacuum? -- Devrim GÜNDÜZ, RHCE devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc Description: This is a digitally signed message part
Re: [GENERAL] How to free disk space
After run VACUUM, you must run REINDEXDB to decrease indexes. You can pg_resetxlog too, but you need restart server to do that. 2008/10/21 Ruben Blanco <[EMAIL PROTECTED]>: > Hi: > > My database is growing fast taking too much disk space. How can I free disk > space without performing a VACCUM FULL? It locks the database for several > hours, and that is not a solution. > > I guess a backup-restore would do the work but, isn't there a better way to > do this without shutting down postgres? > > Thanks in advandce. > > -- Emanuel Calvo Franco Syscope Postgresql DBA BaPUG Member -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general