Hello Greg,
Greg Smith a écrit :
> On Wed, 28 Oct 2009, Denis BUCHER wrote:
>
>> For now, we only planned a VACUUM ANALYSE eacha night.
>
> You really want to be on a later release than 8.1 for an app that is
> heavily deleting things every day. The answer to most VACUUM
Kevin Grittner a écrit :
>> And each morning ... all data is INSERTed new
>
> I recommend VACUUM ANALYZE of the table(s) after this step. Without
> that, the first query to read each tuple sets its hint bits and
> rewrites it, causing a surprising delay at unpredictable times
> (although heavier
Grzegorz Jaśkiewicz a écrit :
>
>
> On Wed, Oct 28, 2009 at 12:11 PM, Denis BUCHER <mailto:dbuche...@hsolutions.ch>> wrote:
>
> Dear all,
>
> I need to optimize a database used by approx 10 people, I don't need to
> have the perfect config, s
Dear all,
I need to optimize a database used by approx 10 people, I don't need to
have the perfect config, simply to avoid stupid bottle necks and follow
the best practices...
The database is used from a web interface the whole work day with
"normal" requests (nothing very special).
And each mor
