Re: Is Linux 2.6.5 kernel good enough for production? - Mailing list pgsql-general

From Dirk Försterling
Subject Re: Is Linux 2.6.5 kernel good enough for production?
Date
Msg-id 40A1BD5D.7060202@zorbla.de
Whole thread Raw
In response to Re: Is Linux 2.6.5 kernel good enough for production?  ("Luiz Rafael Culik Guimaraes" <culikr@brturbo.com>)
Responses Re: Is Linux 2.6.5 kernel good enough for production?  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
Am 05/05/2004 03:03 PM schrieb Luiz Rafael Culik Guimaraes:
>
>>Do people think linux 2.6.5 is stable enough yet for a production
>>PostgreSQL server?
>
> i´m using linux 2.6.5 with postgres 7.4.2 with out problem(conectiva linux
> version 10)

I'd like to add here, that I recently tried 2.6.5 / Postgres 7.4.2 and
found out that overall system performance during database operations
decreased dramatically.

A series of queries that were usually done within about 30 minutes on
Linux 2.4.25 / Postgres 7.4.2 took about 3 (three) hours on Linux 2.6.5
with Postgres 7.4.2 on the same machine with the same configuration.

While on Linux 2.4.25 the queries ran smoothly in background without
impacting other activity, the responsiveness of the whole machine got
so bad with 2.6.5 during the 3 hour query that simple http requests to
an Apache server on the same machine repeatedly timed out.

I still don't know WHY this happened, but I believe it may resolve as
a configuration issue. Maybe Postgres, maybe the Linux kernel.

   -dirk

--
                    D i r k   F "o r s t e r l i n g
                    r@zorbla.de  http://r.zorbla.de/
                             -------------
               An elephant is a mouse with operating system.

pgsql-general by date:

Previous
From:
Date:
Subject: Re: Slow network retrieves
Next
From: Dias Bantekas
Date:
Subject: Re: Data Encryption in PostgreSQL, and a Tutorial.