postgres problem: vacuum analyse/memory exceded at
Results 1 to 3 of 3
  1. #1
    Member
    Join Date
    Dec 2008
    Posts
    43

    Default postgres problem: vacuum analyse/memory exceded at

    Hi there,

    i use postgres 8.4 on a windows 7 system w lots of free HD space and memory space available.

    database is 2 month old, first vacuum analyse worked fine.

    now i tried to do it again /via postgresadmin/ and it didnt work.


    FEHLER: Speicher aufgebraucht
    DETAIL: Fehler bei Anfrage mit Größe 268435452.

    FEHLER: Speicher aufgebraucht
    DETAIL: Fehler bei Anfrage mit Größe 268435452.

    memory exceeded

    hopefully someone can help me here
    greets horse



    PS: i set higher values in order to increase db performance in postgresql.conf for:

    "shared_buffers = xMB"

    "work_mem = xMB"

    "maintenance_work_mem = xMB"

  2. #2
    Member
    Join Date
    Dec 2008
    Posts
    43

    Default

    sorry, this may be the wrong forum

  3. #3
    HM Support Patvs's Avatar
    Join Date
    Feb 2009
    Location
    Amsterdam, the Netherlands
    Posts
    33,523

    Default

    You still have this problem when you reset

    "shared_buffers = xMB"

    "work_mem = xMB"

    and
    "maintenance_work_mem = xMB"


    to its original values??
    Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.

    If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here

Similar Threads

  1. Getting postgres to use more memory
    By schaffem111 in forum Manager General
    Replies: 13
    Last Post: 11-24-2009, 07:14 AM
  2. problem with vacuum
    By lir5353 in forum Manager General
    Replies: 9
    Last Post: 08-15-2009, 10:57 AM
  3. Help needed: Can't Vacuum HEM/Postgres
    By Stosh in forum Manager General
    Replies: 1
    Last Post: 05-20-2009, 12:56 PM
  4. Purge + Vacuum/Analyse, Still same size
    By AntiMatter in forum Manager General
    Replies: 2
    Last Post: 02-03-2009, 05:08 AM
  5. can't vacuum analyse DB...
    By originaL in forum Manager General
    Replies: 1
    Last Post: 09-02-2008, 11:28 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •