Обсуждение: [HACKERS] Postgres collecting CPU seconds
I am using postgresql for a web site. The development environment
is on a Linux system and works fine. The production machine
is a Sun BSDI system. After implementing the stuf on the
production machine the provider got many performance dificulties.
Apparently simple queries keep on collecting CPU time (up to a minute)
where the linux machine handles the same query in less than
a single CPU second. On Linux the amount of CPU time used in independent
of the load of the machine. On de BSDI system it seems to accumulate
when the load increases (which in turn increases the load ...).
Anybody got a clue on what this can be (and how to solve it).
Cheers
Arjen
------------------------------
Version of PostgreSQL on Linux box? on BSDi system? On Mon, 2 Jun 1997, PortSite wrote: > I am using postgresql for a web site. The development environment > is on a Linux system and works fine. The production machine > is a Sun BSDI system. After implementing the stuf on the > production machine the provider got many performance dificulties. > > Apparently simple queries keep on collecting CPU time (up to a minute) > where the linux machine handles the same query in less than > a single CPU second. On Linux the amount of CPU time used in independent > of the load of the machine. On de BSDI system it seems to accumulate > when the load increases (which in turn increases the load ...). > > Anybody got a clue on what this can be (and how to solve it). > > Cheers > > Arjen > > Marc G. Fournier scrappy@hub.org Systems Administrator @ hub.org scrappy@freebsd.org ------------------------------
> > > > Version of PostgreSQL on Linux box? on BSDi system? PostgreSQL 6.0 on Linux 2.0.29 and BSDI/OS 2.0 (i386) > > On Mon, 2 Jun 1997, PortSite wrote: > > > I am using postgresql for a web site. The development environment > > is on a Linux system and works fine. The production machine > > is a Sun BSDI system. After implementing the stuf on the > > production machine the provider got many performance dificulties. > > > > Apparently simple queries keep on collecting CPU time (up to a minute) > > where the linux machine handles the same query in less than > > a single CPU second. On Linux the amount of CPU time used in independent > > of the load of the machine. On de BSDI system it seems to accumulate > > when the load increases (which in turn increases the load ...). > > > > Anybody got a clue on what this can be (and how to solve it). > > > > Cheers > > > > Arjen > > > > > > Marc G. Fournier scrappy@hub.org > Systems Administrator @ hub.org scrappy@freebsd.org > > ------------------------------
On Mon, 2 Jun 1997, PortSite wrote:
> >
> >
> >
> > Version of PostgreSQL on Linux box? on BSDi system?
>
> PostgreSQL 6.0 on Linux 2.0.29 and BSDI/OS 2.0 (i386)
Might want to try out v6.1...there have been alot of memory
and performance improvements...
>
> >
> > On Mon, 2 Jun 1997, PortSite wrote:
> >
> > > I am using postgresql for a web site. The development environment
> > > is on a Linux system and works fine. The production machine
> > > is a Sun BSDI system. After implementing the stuf on the
> > > production machine the provider got many performance dificulties.
> > >
> > > Apparently simple queries keep on collecting CPU time (up to a minute)
> > > where the linux machine handles the same query in less than
> > > a single CPU second. On Linux the amount of CPU time used in independent
> > > of the load of the machine. On de BSDI system it seems to accumulate
> > > when the load increases (which in turn increases the load ...).
> > >
> > > Anybody got a clue on what this can be (and how to solve it).
> > >
> > > Cheers
> > >
> > > Arjen
> > >
> > >
> >
> > Marc G. Fournier scrappy@hub.org
> > Systems Administrator @ hub.org scrappy@freebsd.org
> >
> >
>
Marc G. Fournier
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
------------------------------
> > I am using postgresql for a web site. The development environment > is on a Linux system and works fine. The production machine > is a Sun BSDI system. After implementing the stuf on the > production machine the provider got many performance dificulties. > > Apparently simple queries keep on collecting CPU time (up to a minute) > where the linux machine handles the same query in less than > a single CPU second. On Linux the amount of CPU time used in independent > of the load of the machine. On de BSDI system it seems to accumulate > when the load increases (which in turn increases the load ...). > > Anybody got a clue on what this can be (and how to solve it). > > Cheers All I can say is that many people run it on BSDI for x86 machines without a problem. - -- Bruce Momjian maillist@candle.pha.pa.us ------------------------------