Home > mailing lists

how many index can have???? - Mailing list pgsql-performance

From	petchimuthu lingam
Subject	how many index can have????
Date	March 11, 2008 12:28:49
Msg-id	cd233fc30803110528t1839f18dsd1268303b7c088bc@mail.gmail.com Whole thread Raw
Responses	Re: how many index can have???? Re: how many index can have????
List	pgsql-performance

Tree view

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

pgsql-performance by date:

From: "Heikki Linnakangas"
Date: 11 March 2008, 09:58:39
Subject: Re: Very slow (2 tuples/second) sequential scan afterbulk insert; speed returns to ~500 tuples/second after commit

From: Bill Moran
Date: 11 March 2008, 13:36:09
Subject: Re: count * performance issue

how many index can have???? - Mailing list pgsql-performance

Previous

Next