Re: Autovacuum, too often?

From: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
To: Bill Moran <wmoran(at)collaborativefusion(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Autovacuum, too often?
Date: 2008-09-19 12:37:50
Message-ID: 79501.75275.qm@web25805.mail.ukl.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> From: Bill Moran <wmoran(at)collaborativefusion(dot)com>

>
> Maybe that's not _always_ the right answer, but it
> seems to be a good
> answer 99% of the time. Sounds like your developers are
> using the
> database for what it was intended for, instead of just
> doing single
> row selects like a lot of amateurs I've come across.
>

In some places I agree it's totally valid, but in a lot of cases here it's just unnecessary. They have a set of really flexible pre written routines to sort datasets in the application, and I'm talking really stupid use here - like having a small list of items in an array where an array sort could be done, but instead writing it all back and reading it again. constantly.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Hunter 2008-09-19 13:40:27 Re: Query planner issue
Previous Message Bill Moran 2008-09-19 12:09:56 Re: Autovacuum, too often?