Re: [GENERAL] Slow index performance

2015-07-03 Thread Christian Schröder
: Freitag, 3. Juli 2015 08:58 An: Christian Schröder; pgsql-general@postgresql.org Betreff: RE: [GENERAL] Slow index performance > -Original Message- > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > ow...@postgresql.org] On Behalf Of Christian Schröder > Sent

Re: [GENERAL] Slow index performance

2015-07-02 Thread Marc Mamin
> -Original Message- > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > ow...@postgresql.org] On Behalf Of Christian Schröder > Sent: Freitag, 3. Juli 2015 07:36 > To: pgsql-general@postgresql.org > Subject: [GENERAL] Slow index performance >

[GENERAL] Slow index performance

2015-07-02 Thread Christian Schröder
Hi all, we have a strange performance issue in one of our databases (using PostgreSQL 9.1.18). Maybe you can help me understand what’s going on. We have two identical tables (rec_isins_current, rec_isins_archive) with the following structure: Table "ts_frontend.rec_isins_current" Column |