Re: Fast Inserts and Hardware Questions

Peter Eisentraut wrote:
>
> Orion Henry writes:
>
> > The indexes will be
> > int8 (primary key)
> > int4 (group number)
> > timestamp (creation date)
> > int4 (customer id)
>
> Since one query can only use one index per table, you should only need the
> customer_id index, given the queries you listed.

Isn't that was multi-column indexes are for?

I have 100's of customers but millions of database entries.  If I have
to I'll make a table for each customer, big_table_5 and big_table_6
etc... but this seems to be a terrible hack and the database should be
able to do things like this for me.

Orion Henry
CTO TrustCommerce
orion@trustcommerce.com