Postgres Pro
Downloads
Home   >   mailing lists

Re: Inserts or Updates - Mailing list pgsql-performance

From Andy Colson
Subject Re: Inserts or Updates
Date
Msg-id 4F317ED1.6080907@squeakycode.net
Whole thread Raw
In response to Re: Inserts or Updates  (Andy Colson <andy@squeakycode.net>)
Responses Re: Inserts or Updates  (Ofer Israeli <oferi@checkpoint.com>)
List pgsql-performance
Tree view 
Oh, I knew I'd seen index usage stats someplace.

give this a run:

select * from pg_stat_user_indexes where relname = 'SuperBigTable';

http://www.postgresql.org/docs/current/static/monitoring-stats.html

-Andy

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Inserts or Updates
Next
From: Peter van Hardenberg
Date:
Subject: random_page_cost = 2.0 on Heroku Postgres