Re: Getting an out of memory failure.... (long email) - Mailing list pgsql-general

Sean Shanny wrote:
> Tom,
>
> The Analyze did in fact fix the issue.  Thanks.
>
> --sean

Given the fact that you are using pg_autovacuum, you have to consider
a few points:

1) Is out there a buggy version that will not analyze big tables.
2) The autovacuum fail in scenarios with big tables not eavy updated,
    inserted.

For the 1) I suggest to check in your logs and see how the total rows
in your table are displayed, the right version show you the rows number
as a float:
     [2004-09-28 17:10:47 CEST]   table name: empdb."public"."user_logs"
     [2004-09-28 17:10:47 CEST]      relid: 17220;   relisshared: 0
     [2004-09-28 17:10:47 CEST]      reltuples: 5579780.000000;  relpages: 69465
     [2004-09-28 17:10:47 CEST]      curr_analyze_count: 171003; curr_vacuum_count: 0
     [2004-09-28 17:10:47 CEST]      last_analyze_count: 165949; last_vacuum_count: 0
     [2004-09-28 17:10:47 CEST]      analyze_threshold: 4464024; vacuum_threshold: 2790190

for the point 2) I suggest you to "cron" analyze during the day.



Regards
Gaetano Mendola