c k wrote: > I am using PG on windows for development. While testing some queries I > found that updates are much slower as compared to other database > systems. (On avarage MySQL updates 4-5 times faster than PG in a single > unique index on primary key) Why?
Is your MySQL instance using MyISAM tables, or InnoDB? > Another thing that I noticed is when any single column in a table is > updated and having no index many (in my case 7) indexes on different > columns, It takes about 180-200 secs. But when any single column in a > table is updated and having many (in my case 7) indexes on different > columns, but does not have index on the column that is being updated, It > takes about 800-900 secs. Why? Perhaps you can show us some table definitions and queries with EXPLAIN ANALYZE output? Your explanation is quite difficult to understand. > What can be done for such updates to make them faster? Faster disks :-P -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
