design help for performance

From: Culley Harrelson <harrelson(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: design help for performance
Date: 2011-12-20 23:56:49
Message-ID: CAAPtAvRwr1w2Zvyyv3aOTK7RJ9Bm1Tuq-kmQtt77upPcm7QYYg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am bumping into some performance issues and am seeking help.

I have two tables A and B in a one (A) to many (B) relationship. There are
1.4 million records in table A and 44 million records in table B. In my
web application any request for a record from table A is also going to need
a count of associated records in table B. Several years ago I added
table_b_rowcount to table A in order to minimize queries on table B. And
now, as the application has grown, I am starting to having locking problems
on table A. Any change to table B requires the that table_b_rowcount be
updated on table A... The application has outgrown this solution.

So... is there a common solution to this problem?

culley

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2011-12-21 00:03:28 Re: PostgreSQL server architecture
Previous Message Josh Kupershmidt 2011-12-20 23:56:14 Re: Escaping input from COPY