Re: [GENERAL] relpages sudden increase

2012-05-09 Thread Richard Harley
On 09/05/12 00:00, Tomas Vondra wrote: On 8.5.2012 19:27, Richard Harley wrote: I currently do nightly database dumps on a ton of small dbs that are increasing around 2-3mb per day. Suddenly, in a recent backup file, one db in particular jumped from 55mb to 122mb overnight. Well, I wouldn't cal

Re: [GENERAL] relpages sudden increase

2012-05-08 Thread Tomas Vondra
On 8.5.2012 19:27, Richard Harley wrote: > I currently do nightly database dumps on a ton of small dbs that are > increasing around 2-3mb per day. Suddenly, in a recent backup file, one > db in particular jumped from 55mb to 122mb overnight. Well, I wouldn't call that 'massive size' but in my expe

[GENERAL] relpages sudden increase

2012-05-08 Thread Richard Harley
I currently do nightly database dumps on a ton of small dbs that are increasing around 2-3mb per day. Suddenly, in a recent backup file, one db in particular jumped from 55mb to 122mb overnight. I did some investigation - One table increased from 8mb to 31mb during a 24hr period. The table is