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.
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? |