Re: Periodically slow inserts
От
Mladen Gogala
Тема
Re: Periodically slow inserts
Дата
Msg-id
4CC06707.8090809@vmsinfo.com
Ответ на
Periodically slow inserts (Gael Le Mignot)
Список
Дерево обсуждения
Periodically slow inserts Gael Le Mignot <gael@pilotsystems.net>
Re: Periodically slow inserts Kenneth Marshall <ktm@rice.edu>
Re: Periodically slow inserts Tom Lane <tgl@sss.pgh.pa.us>
Re: Periodically slow inserts Gael Le Mignot <gael@pilotsystems.net>
Re: Periodically slow inserts Tom Lane <tgl@sss.pgh.pa.us>
Re: Periodically slow inserts Leonardo Francalanci <m_lists@yahoo.it>
Re: Periodically slow inserts Mladen Gogala <mladen.gogala@vmsinfo.com>
Re: Periodically slow inserts Leonardo Francalanci <m_lists@yahoo.it>
Re: Periodically slow inserts Gael Le Mignot <gael@pilotsystems.net>
Re: Periodically slow inserts Leonardo Francalanci <m_lists@yahoo.it>
Re: Periodically slow inserts Cédric Villemain <cedric.villemain.debian@gmail.com>
Re: Periodically slow inserts Greg Smith <greg@2ndquadrant.com>
Re: Periodically slow inserts Leonardo Francalanci <m_lists@yahoo.it>
Re: Periodically slow inserts Gael Le Mignot <gael@pilotsystems.net>
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
В списке pgsql-performance по дате отправления
