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: 4CC06707.8090809@vmsinfo.com (view raw or flat)
Thread:
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
http://www.vmsinfo.com 
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-2014 The PostgreSQL Global Development Group