how many index can have????

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-performance@xxxxxxxxxxxxxx
Subject: how many index can have????
From: "petchimuthu lingam" <spmlingam@xxxxxxxxx>
Date: Tue, 11 Mar 2008 17:58:30 +0530

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

Follow-Ups:
- Re: how many index can have????
  - From: Craig Ringer
- Re: how many index can have????
  - From: Dave Cramer

Prev by Date: Re: Very slow (2 tuples/second) sequential scan afterbulk insert; speed returns to ~500 tuples/second after commit
Next by Date: Re: count * performance issue
Previous by thread: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
Next by thread: Re: how many index can have????
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux