Richard H wrote:
>
> On 3/14/01, 7:08:48 PM, Orion Henry <[EMAIL PROTECTED]> wrote
> regarding [GENERAL] Fast Inserts and Hardware Questions:
>
> Please bear in mind that you are operating well above anything I do, so
> I'm not speaking from experience.
I appricate the advice in anycase.
> >
Orion Henry writes:
> > 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 tabl
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
