how delete/insert/update affects select performace?

From: "Anibal David Acosta" <aa(at)devshock(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: how delete/insert/update affects select performace?
Date: 2011-09-08 12:51:13
Message-ID: 004301cc6e26$015a75e0$040f61a0$@devshock.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi!

I have a table not too big but with aprox. 5 millions of rows, this table
must have 300 to 400 select per second. But also must have 10~20
delete/insert/update per second.

So, I need to know if the insert/delete/update really affect the select
performance and how to deal with it.

The table structure is very simple:

account_id integer (PK)

service_id integer (PK)

enabled char(1)

The index created on this has the same 3 columns.

Most of time the table has more insert or delete than update, when update
occur the column changed is enabled;

Thanks!

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tomas Vondra 2011-09-08 14:10:19 Re: how delete/insert/update affects select performace?
Previous Message Vitalii Tymchyshyn 2011-09-07 06:54:25 Re: Rather large LA