Christian Schröder <c...@deriva.de> writes: > Where does this difference come from? Pure cpu performance? Do the additional > fields in the productive database have an impact on the performance? Or do I > miss something?
Sure, more data takes more time to process. Other factors which could affect it is how much dead space is in the table due to previous updates and deletes, as well as how fragmented the indexes have become over time. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
