On 07/13/2012 06:06 AM, codevally wrote:
> Hi Laurenz
>
> Many thanks for your reply.
>
> Could you please bit more explain about the following sentence you wrote:
>
> There are no performance problems except the ones that always come with an
> index: INSERTs, UPDATEs and DELETEs will be slower and do more disk I/O and
> locking.
Every index you add slows down modifications to the table a little bit,
because it has to be kept up to date. It also uses more disk space and
takes time for VACCUM.
--
Craig Ringer