On Wed, 12 May 2004, Dirk Försterling wrote:
> 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.
Which of the two 2.6 schedulers are you running? It would seem the
pre-emptive schedule, while making for a better user experience on
workstations, is not as good as the deadline scheduler for things like
servers.