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
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 |