Re: High activity short table and locks

From: Richard Huxton <dev(at)archonet(dot)com>
To: Guillaume Bog <guibog(at)gmail(dot)com>
Cc: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: High activity short table and locks
Date: 2008-07-25 08:14:11
Message-ID: 48898B53.60707@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Guillaume Bog wrote:
> Hello,
>
> My first impression is that vacuuming the offending table very often helps a
> lot. I'm doing it by hand for now but I will have a cronjob for this. By the
> way, it seems I don't need thoses indexes anymore. Thanks a lot for your
> helpful advices.

Excellent! Oh, when you set up your cron-job, it's probably better to
vacuum this sort of table too often rather than not enough.

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-general by date

  From Date Subject
Next Message A B 2008-07-25 08:52:11 I often have to do "update if exist, else insert", is my database design wrong?
Previous Message Guillaume Bog 2008-07-25 08:09:51 Re: High activity short table and locks