On Mon, May 27, 2013 at 3:41 PM, Ben Zeev, Lior <lior.ben-zeev@hp.com> wrote:
> Hi Atri,
>
> Thanks for your answer!
> Do you have idea what may be the reason that PostgreSQL process consume more memory when there are more partial
indexeson the DB table?
Well, I am not too sure, but indexes always take up more space, so if
your backend has a lot of indexes, it will cause the process to
consume more memory.
Indexes should be used with care, as too many indexes can cause a
memory overhead,which can cause performance degradations.
Regards,
Atri
--
Regards,
Atri
l'apprenant
