Skip site navigation (1) Skip section navigation (2)

Re: Periodically slow inserts

From: Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
To: Gael Le Mignot <gael(at)pilotsystems(dot)net>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Periodically slow inserts
Date: 2010-10-21 16:15:03
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
Gael Le Mignot wrote:
> Hello,
> We are  using PostgreSQL for  storing data and full-text  search indexes
> for the webiste of a daily newspaper. We are very happy overall with the
> results, but we have one "weird" behaviour that we would like to solve.
> The problem is  when we index objects into the  full-text search part of
> the database (which a DELETE and  then an INSERT into a specific table),
> the INSERT  sometimes take a long time  (from 10s to 20s),  but the same
> insert (and many other similar ones) are fast (below 0.2s).
Have you tried with strace, just to see where the time is spent?

Mladen Gogala 
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251 
The Leader in Integrated Media Intelligence Solutions

In response to

pgsql-performance by date

Next:From: Steve CrawfordDate: 2010-10-21 16:42:52
Subject: Re: BBU Cache vs. spindles
Previous:From: Bruce MomjianDate: 2010-10-21 16:09:19
Subject: Re: New wiki page on write reliability

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group