Re: PostgreSQL Process memory architecture - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: PostgreSQL Process memory architecture
Date
Msg-id 20130527122931.GK8597@tamriel.snowman.net
Whole thread Raw
In response to Re: PostgreSQL Process memory architecture  (Atri Sharma <atri.jiit@gmail.com>)
Responses Re: PostgreSQL Process memory architecture
Re: PostgreSQL Process memory architecture
List pgsql-hackers
* Atri Sharma (atri.jiit@gmail.com) wrote:
> Yes, too many indexes wont hurt much.BTW,wont making too many indexes
> on columns that probably dont have as many values as to deserve
> them(so,essentially,indiscriminately making indexes) hurt the
> performance/memory usage?

I'd expect the performance issue would be from planner time more than
memory usage- but if there is a serious memory usage issue here, then
it'd be valuable to have a test case showing what's happening.  We may
not be releasing the sys cache in some cases or otherwise have a bug in
this area.
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: PostgreSQL Process memory architecture
Next
From: Atri Sharma
Date:
Subject: Re: PostgreSQL Process memory architecture