Re: [Condor-users] How to shrink quill database?

["Steven Platt" <Steven.Platt@xxxxxxxxxx>]

Hi Greg,

Here's the output of the command...

quill=# select relname, relpages from pg_class order by relpages desc
limit 20;
             relname             | relpages 
---------------------------------+----------
 pg_toast_16857                  |   169365
 jobs_horizontal_history         |    70703
 jobs_vertical_history_pkey      |    55845
 jobs_vertical_history           |    51525
 machines_vertical_history       |    20161
 jobs_horizontal_history_pkey    |      666
 transfers                       |      351
 jobs_hor_his_ix1                |      298
 jobs_hor_his_ix2                |      254
 runs                            |       91
 error_sqllogs                   |       87
 pg_statistic                    |       69
 matches                         |       46
 pg_proc                         |       44
 pg_attribute                    |       43
 pg_toast_16857_index            |       43
 pg_attribute_relid_attnam_index |       42
 pg_proc_proname_args_nsp_index  |       41
 pg_depend                       |       36
 events                          |       29
(20 rows)

So pg_toast_16857 is the culprit, however...

quill=# SELECT pg_size_pretty(pg_total_relation_size('pg_toast_16857'));
ERROR:  relation "pg_toast_16857" does not exist

Can pg_toast_16857 be emptied without crippling the database? What do
you advise?

Thanks
Steve


-----Original Message-----
From: condor-users-bounces@xxxxxxxxxxx
[mailto:condor-users-bounces@xxxxxxxxxxx] On Behalf Of Greg Thain
Sent: 18 August 2011 17:06
To: Condor-Users Mail List
Subject: Re: [Condor-users] How to shrink quill database?

On 08/18/2011 10:20 AM, Steven Platt wrote:
> Hello,
>
> Our quill database has ballooned recently to the point where it takes
> over 75% of its partition. I've had to disable the quill&  dbmsd
daemons
> to allow condor to continue to run.

Sometimes, postgres seems to grow without bounds.  Let's first see what 
tables or indexes are the problem.  Run the following interactive psql 
query, and it should be clear where the bloat is:

select relname, relpages from pg_class order by relpages desc limit 20;



_______________________________________________
Condor-users mailing list
To unsubscribe, send a message to condor-users-request@xxxxxxxxxxx with
a
subject: Unsubscribe
You can also unsubscribe by visiting
https://lists.cs.wisc.edu/mailman/listinfo/condor-users

The archives can be found at:
https://lists.cs.wisc.edu/archive/condor-users/
-----------------------------------------
**************************************************************************
The information contained in the EMail and any attachments is
confidential and intended solely and for the attention and use of
the named addressee(s). It may not be disclosed to any other person
without the express authority of the HPA, or the intended
recipient, or both. If you are not the intended recipient, you must
not disclose, copy, distribute or retain this message or any part
of it. This footnote also confirms that this EMail has been swept
for computer viruses, but please re-sweep any attachments before
opening or saving. HTTP://www.HPA.org.uk
**************************************************************************