List,
I've got a problem where I need to make a table that is going to grow by an average of 230,000 records per day.
There are only 20 columns in the table, mostly char and integer. It's FK'd in two places to another table for
import/export transaction id's and I have a serial primary key an
On 22 Oct 2005, at 01:25, Edoceo Lists wrote:
List,
I've got a problem where I need to make a table that is going to
grow by an average of 230,000 records per day. There are only 20
columns in the table, mostly char and integer. It's FK'd in two
places to another table for import/expor
On Fri, Oct 21, 2005 at 05:25:22PM -0700, Edoceo Lists wrote:
[summary of situation]
> Some queries take more than five minutes to complete and I'm sad
> about that. How can I make this faster?
You might get more help on pgsql-performance, which is specifically
for discussions of performance is
List,
I've got a problem where I need to make a table that is going to grow by an average of 230,000 records per day. There
are only 20 columns in the table, mostly char and integer. It's FK'd in two places to another table for import/export
transaction id's and I have a serial primary key an
