Re: Linux Distribution Preferences?

Edson Richter wrote:

> Do you have any fact that support RHEL being slower than others?
> I would like to improve our servers if we can get some ideas - so far,
> we have tried Ubuntu LTS servers, and seems just as fast as RHEL for
> PostgreSQL (tests made by issuing heavy queries).

On Debian/Ubuntu, the default behavior is to have SSL enabled out
of the box, including for TCP connections to localhost.
That may be a good idea for remote access, but for local/LAN connections,
it can slow things down quite significantly . The problem is that people end
up using SSL without needing or knowing it.

Of course it can be turned off by using hostnossl for specific hosts in
pg_hba.conf, or globally with SSL=off in postgresql.conf, or using Unix
domain sockets for local connections, but people not well-versed in PG are
often not aware of this.

Other than that, the rest of the packaging is awesome, especially the layer
that make it possible to manage several simultaneous PG instances.

Best regards,
--
Daniel
PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org