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!