On Mon, Aug 08, 2005 at 11:26:37AM +1000, Michael VInce wrote:
> Also note that I have a MySQL server with a similar table setup and it
> performs a lot better.
If you provide example queries that are performing worse than in MySQL
along with the output of EXPLAIN ANALYZE on them to the PostgreSQ
Hi,
I have done all my Postgres optimization configuration via sysctl or the
postgresql.conf no kernel recompilation was performed.
I did benchmarks at complete default FreeBSD / Postgres configuration
and benchmarks after.
I found raising the values to probably not much more then 1/4 of what
> >>Will more RAM become available to postgresql if I change the
> >>kernel-values mentioned above to half the size?
> >
> >Yes, it will raise the in-kernel limits so that PostgreSQL can
> >allocate more RAM for its user-land cache.
> >
> >You will probably have a better ROI in terms of performance
Sean Chittenden wrote:
Will more RAM become available to postgresql if I change the
kernel-values mentioned above to half the size?
Yes, it will raise the in-kernel limits so that PostgreSQL can
allocate more RAM for its user-land cache.
You will probably have a better ROI in terms of pe
> I recently lowered max_connections from 1024 to 384 in
> /usr/local/pgsql/data/postgresql.conf. The server is a quad opteron @
> 2 GHz and 4 GB of RAM.
>
> This decreased the SIZE and RES values in top and it seems that the
> current max_connections is more than adequate. To see how many
> concu
Hi.
I recently lowered max_connections from 1024 to 384 in
/usr/local/pgsql/data/postgresql.conf. The server is a quad opteron @
2 GHz and 4 GB of RAM.
This decreased the SIZE and RES values in top and it seems that the
current max_connections is more than adequate. To see how many
concurrent con
