On 07/13/2012 06:06 AM, codevally wrote:
Hi Laurenz Many thanks for your reply. Could you please bit more explain about the following sentence you wrote: There are no performance problems except the ones that always come with an index: INSERTs, UPDATEs and DELETEs will be slower and do more disk I/O and locking.
Every index you add slows down modifications to the table a little bit, because it has to be kept up to date. It also uses more disk space and takes time for VACCUM.
-- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
