No matter how I try to redesign the schema the indexes consume large amount of memory,
About 8KB per index.
Is there a way to invalidated this cache?
Is there a way to limit the amount of memory and use some kind of LRU/LFU algorithm to clean old cache?
-----Original Message-----
From: Atri Sharma [mailto:atri.jiit@gmail.com]
Sent: Monday, May 27, 2013 17:24
To: Stephen Frost
Cc: Ben Zeev, Lior; Pg Hackers
Subject: Re: [HACKERS] PostgreSQL Process memory architecture
>We may still be able to do better than what we're doing
> today, but I'm still suspicious that you're going to run into other
> issues with having 500 indexes on a table anyway.
+1. I am suspicious that the large number of indexes is the problem
here,even if the problem is not with book keeping associated with those indexes.
Regards,
Atri
--
Regards,
Atri
l'apprenant