Postgres 9.1: Adding rows to table causing too much latency in other queries

From: Sushant Sinha <sushant354(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Postgres 9.1: Adding rows to table causing too much latency in other queries
Date: 2011-12-19 15:30:48
Message-ID: 1324308648.1844.8.camel@dragflick
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I recently upgraded my postgres server from 9.0 to 9.1.2 and I am
finding a peculiar problem.I have a program that periodically adds rows
to this table using INSERT. Typically the number of rows is just 1-2
thousand when the table already has 500K rows. Whenever the program is
adding rows, the performance of the search query on the same table is
very bad. The query uses the gin index and the tsearch ranking function
ts_rank_cd.

This never happened earlier with postgres 9.0 Is there a known issue
with Postgres 9.1? Or how to report this problem?

-Sushant.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Euler Taveira de Oliveira 2011-12-19 15:41:52 Re: Postgres 9.1: Adding rows to table causing too much latency in other queries
Previous Message Peter Eisentraut 2011-12-19 15:16:44 pg_upgrade with plpython is broken