pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Martin Strejc <martin.strejc@super-web.cz>
To: pgsql-admin@postgresql.org
Subject: pg_toast
Date: Tue, 23 Oct 2007 16:07:43 +0200
Message-ID: <471E002F.4030004@super-web.cz> (raw)

Hi!

    I've a special kind of problem with PostgreSQL 8.2.5 and I haven't 
found anything about that on your web or searchig by Google.

    The database slows down when more over many (cca 100 connections) 
are incoming. The problem begun the same time as the VACUUM foroze on 
pg_toast.pg_toast without any reason or message in log. Actually it got 
after that troubles with reindex and VACUUM ANALYZE.
    Of course the shmmax, shared mem, max connections and some other 
parameter in postgresql.conf are set to get the best preformance of the 
server.

    Should you give me an advice what to do and how to help the database 
engine to work correctly?

    Is it possible to delete any of pg_toast or pg_temp tables? How to 
do that if possible?

Thank you for your help.

Martin Strejc
server admin



view thread (2+ messages)  latest in thread

Message-ID: <471E002F.4030004@super-web.cz>
Permalink:  ../471E002F.4030004@super-web.cz/
Also on:    postgresql.org/message-id/471E002F.4030004@super-web.cz

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: martin.strejc@super-web.cz
  Subject: Re: pg_toast
  In-Reply-To: <471E002F.4030004@super-web.cz>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox