Re: [ADMIN] PostgreSQL Performance Tuning / Postgresql.conf and on OS Level

2012-12-16 Thread Shams Khan
Hi Kevin, I got one more question, please help me out. Question 1. How do we correlate our memory with kernel parameters, I mean to say is there any connection between shared_buffer and kernel SHMMAX. For example if I define my shared buffer more than my current SHMMAX value, it would not allow m

Re: [ADMIN] ERROR: index row size exceeds maximum 2712 for index

2012-12-16 Thread Kevin Grittner
amjad usman wrote: > ERROR: index row size 3176 exceeds maximum 2712 for > index "description_department_of_aeronautics_and_astronautics_5_pkey" Can you show us the definitions of the table and the index? -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make change