From: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
---|---|
To: | rob(dot)cleveland(at)wardsauto(dot)com |
Cc: | ctassell(at)isn(dot)net, pgsql-general(at)postgresql(dot)org |
Subject: | Re: A Haunted Database |
Date: | 2000-04-10 02:07:36 |
Message-ID: | 20000410110736U.t-ishii@sra.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> Thanks! Turning off the nightly vacuum script did the trick. Now . . . any
> idea why vacuum would be so damaging? It certainly appears, at least for me,
> that the routine is more trouble than it is worth. Is it a malfunction that
> can be overwritten or a bug or something else?
>
> Again many thanks. I can sleep without fear now
>
> Rob
>
>
>
> >Do you have any automated program accessing the database overnight? IE a
> >malfunctioning backup or vacuum script? You might also want to do a diff
> >-C1 first_dump second_dump to see what is actually being changed.
> >
> >At 11:40 AM 4/8/00, Robert Cleveland wrote:
> >>Here's a mystery I hope someone can solve for me.
> >>
> >>We are entering blocks of HTML into a table called bodyparts. We use PHP3
> to
> >>break up these blocks into several chunks to keep the length below the
> >>maximum. When the end user calls up the section, the "bodyparts" are
> >>extracted and re-assembled.
How small is the "chunk"? If you have an index on it, it must be much
smaller than 8k. I recommend lower than 2k.
P.S. Can you give me the dump file so that I could dig into the
problem. I think pg_dump -t the_table_you_have_problems is probably
enough.
--
Tatsuo Ishii
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2000-04-10 02:34:49 | Re: OID rollover? |
Previous Message | Tatsuo Ishii | 2000-04-10 02:07:25 | Re: PHP-Postgres link |