--001517740ddafe70620474bbc78d
Content-Type: text/plain; charset=ISO-8859-1
I have this server, Dual Intel Xeon 2.83GHz w 4gb ram.
My shared buffers were set to 1756 MB.
We have a high traffic e-commerce site, yesterday like 80000 uniques.
We cache most of our dynamic pages to disk so its wierd we are experience
really slow response times with postgresql.
Usually the number of simultaneous connections i monitor is around 8 to 10,
but yesterday night, maybe there was a spike in the traffic, it was going up
to 100, so the pages were taking like 15 seconds to render.
The wierd thing is that server is fine, i mean the load on the server itself
is not that high, but postgresql for some reason was slowing bad.
We upgraded the ram to 8 GB ram today, replicated some of the read-only
tables to another database to split the load.
Is there anything i can check to see whats causing this really? Im checking
pg_stat_activity, all processes are idle, yet the timeout is set low on the
configuration, i dont know why they sit there.
With 8 GB ram, im thinking of incresing the shared_buffer to 3.
Whats a good value for work_mem and temp memory?
Any advise appreciated, server running on RHEL 2.6.18-128.7.1.el5 x86_64
--001517740ddafe70620474bbc78d
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
I have this server, Dual Intel Xeon 2.83GHz w 4gb ram.<br>My shared buffers=
were set to 1756 MB.<br><br>We have a high traffic e-commerce site, yester=
day like 80000 uniques.<br>We cache most of our dynamic pages to disk so it=
s wierd we are experience really slow response times with postgresql.<br>
<br>Usually the number of simultaneous connections i monitor is around 8 to=
10, but yesterday night, maybe there was a spike in the traffic, it was go=
ing up to 100, so the pages were taking like 15 seconds to render.<br><br>
The wierd thing is that server is fine, i mean the load on the server itsel=
f is not that high, but postgresql for some reason was slowing bad.<br><br>=
We upgraded the ram to 8 GB ram today, replicated some of the read-only tab=
les to another database to split the load.<br>
<br>Is there anything i can check to see whats causing this really? Im chec=
king pg_stat_activity, all processes are idle, yet the timeout is set low o=
n the configuration, i dont know why they sit there.<br><br>With 8 GB ram, =
im thinking of incresing the shared_buffer to 3.<br>
Whats a good value for work_mem and temp memory?<br><br>Any advise apprecia=
ted, server running on RHEL 2.6.18-128.7.1.el5 x86_64<br>
--001517740ddafe70620474bbc78d--
