From: | Daniel Åkerud <zilch(at)home(dot)se> |
---|---|
To: | "PostgreSQL-general" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Multiple Indexing, performance impact |
Date: | 2001-06-22 19:16:57 |
Message-ID: | 002901c0fb4f$ee114030$c901a8c0@automatic100 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
I did a ps ax | postmaster but found no -B, and concluded that it uses the
value specified in /etc/postgrelsql/postgresql.conf on shared_buffers (I
saw -B was shared buffer doing a man postmaster). I'll change this to 256
and rerun the test!
Will post the results here later. Please tell if this was a too puny
increase!
Daniel Åkerud
> =?iso-8859-1?Q?Daniel_=C5kerud?= <zilch(at)home(dot)se> writes:
> > Anyone know what causes the signifacant performance decrease after 7
indexe=
> > s?
>
> I'd bet that somewhere around there, you are starting to see thrashing
> of the buffer pool due to needing to touch too many different pages to
> insert each tuple. What is your -B setting? If you increase it,
> does the performance improve?
>
> regards, tom lane
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-06-22 19:22:24 | Re: where's the reference to a view, here? |
Previous Message | Daniel Åkerud | 2001-06-22 19:04:49 | TCP/IP Sockets, UNIX Sockets |
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2001-06-22 19:51:08 | Re: help with add constraint syntax needed |
Previous Message | Tom Lane | 2001-06-22 18:48:25 | Re: Multiple Indexing, performance impact |