Re: [Sqlgrey-users] Using multiple Connect tables

[Michael S. <Mic...@lr...>]

Hi Dave,

On Thu, 29 Mar 2007, Dave Strickler wrote:

>  The problem we are having is a very old one. In about 24 hours, our
> Connect table will grow to 6 million records. We can purge it down, but
> that takes time, and what really hurts us is doing a VACUUM FULL which
> would write/read lock the database for long periods of time, therefore
> pulling SQLGrey "offline". We are not using pg_autovacuum, and perhaps
> this would be the solution for now.
>

In addition to get a smooth cleaning and restructuring, you could try to
reduce the amount of entries in the connect table. Do you use throttling?
We use it and in our case instead of having more than 2 million entries in
connect we only have 800.000 (statistic from today). If you are not using
throttling, you could analyze your connect table to find out how many
entries could be avoided.

Another thing would be to use more aggressive tests before a request is
made to Sqlgrey.

Michael Storz
--
======================================================
Leibniz-Rechenzentrum      |    <mailto:St...@lr...>
Boltzmannstr. 1            |    Fax: +49 89 35831-9700
85748 Garching / Germany   |    Tel: +49 89 35831-8840
======================================================