how many index can have????

From: "petchimuthu lingam" <spmlingam(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: how many index can have????
Date: 2008-03-11 12:28:30
Message-ID: cd233fc30803110528t1839f18dsd1268303b7c088bc@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I have one table with 30 fields, i have more then 60 million records, if i
use more no of indexes will it affect the insertion
performance? and select performance?

Shall i have more then one partial index for same field, ????

--
With Best Regards,
Petchimuthulingam S

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Heikki Linnakangas 2008-03-11 12:34:07 Re: [PERFORM] Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
Previous Message Heikki Linnakangas 2008-03-11 09:58:20 Re: Very slow (2 tuples/second) sequential scan afterbulk insert; speed returns to ~500 tuples/second after commit