We upgraded from PG 9.1 to 9.2. Since the upgrade, the # of active queries has
raised significantly, especially during our peak time where lots of users are
logging in. According to New Relic, this query is now taking up the most
amount of time during peak activity and my pg_stat_activity and s
2013/2/4 Anne Rosset :
> I have read a lot of different information about the benefits of using
> numerical primary key vs alphanumerical primary key(small size). And what I
> am gathering is that for performance there is no more great advantage.
>
> It seems like now RDBMS in general, postgres in
Hi,
I have read a lot of different information about the benefits of using
numerical primary key vs alphanumerical primary key(small size). And what I am
gathering is that for performance there is no more great advantage.
It seems like now RDBMS in general, postgres in particular handles pretty w
> Yeah.. I came across pgtune but noticed that latest version dated 2009-10-29
> http://pgfoundry.org/frs/?group_id=1000416 which is kind of outdated. Tar
> file has settings for pg 8.3. Is still relevant?
>
> Yes, I'm sure it will not do anything bad to your config.
>
Apologies for leaping
