Re: [GENERAL] Hardware optimising

1999-08-26 Thread Bruce Momjian
> P.S. From previous posts, I'm starting to think that > there is a VAST misconception that a single-threaded > database engine (which is what Oracle was until some > version 7 releases, I believe, called Oracle MTS > appeared) can only handle ONE query at a time, and > does > not exec() a child

Re: [GENERAL] Hardware optimising

1999-08-26 Thread Andy Lewis
Thanks for the info! Much appreciated! Andy On Thu, 26 Aug 1999, Mike Mascari wrote: > --- Andy Lewis <[EMAIL PROTECTED]> wrote: > > What scheduler are we speaking of here? > > > > Andy > > > > On Thu, 26 Aug 1999, Bruce Momjian wrote: > > > > > > as for the processor, this will see an incr

Re: [GENERAL] Hardware optimising

1999-08-26 Thread Mike Mascari
--- Andy Lewis <[EMAIL PROTECTED]> wrote: > What scheduler are we speaking of here? > > Andy > > On Thu, 26 Aug 1999, Bruce Momjian wrote: > > > > as for the processor, this will see an increase, > of course. note, > > > however, that since PostgreSQL is _not_ > multithreaded, that it will run

Re: [GENERAL] Hardware optimising

1999-08-26 Thread Bruce Momjian
> What scheduler are we speaking of here? > > Andy > > On Thu, 26 Aug 1999, Bruce Momjian wrote: > > > > as for the processor, this will see an increase, of course. note, > > > however, that since PostgreSQL is _not_ multithreaded, that it will run > > > only on one of the processors. (i'm abou

[GENERAL] Pg.pm for Windows?

1999-08-26 Thread Anand Surelia
How can I use Pg.pm in my perl scripts running on Windows through ActivePerl? Some of my developers are refusing to work on Linux machines for just writing perl scripts :-). Thanks, Anand.

Re: [GENERAL] Hardware optimising

1999-08-26 Thread Andy Lewis
What scheduler are we speaking of here? Andy On Thu, 26 Aug 1999, Bruce Momjian wrote: > > as for the processor, this will see an increase, of course. note, > > however, that since PostgreSQL is _not_ multithreaded, that it will run > > only on one of the processors. (i'm about to assume you ar

Re: [GENERAL] Hardware optimising

1999-08-26 Thread Bruce Momjian
> as for the processor, this will see an increase, of course. note, > however, that since PostgreSQL is _not_ multithreaded, that it will run > only on one of the processors. (i'm about to assume you are using linux > here... 'scuse me if i'm wrong) however, the good news is that you can > encoura

Re: [GENERAL] Hardware optimising

1999-08-26 Thread Aaron J. Seigo
hi... > 128 MB 100 MHz SDRAM > AMD K6-2/300 CPU > 10 GB 7200RPM 9.0ms IBM IDE HDD > > It will, over the next few months, as money becomes available, be upgraded to: > > 256 MB 100 MHz SDRAM > Dual Athlon 500 CPUs > 10 GB UltraII Wide SCSI drive > > The database will contain several million rec

[GENERAL] pg_class missing

1999-08-26 Thread Phil Oelkers
I want to use postgresql. The error message is: /usr/bin/postmaster does not find the database system The problem seems to be: file /var/lib/pgsql/base/template1/pg_class is missing. in fact I can only find up to /var/lib/pgsgl/ How do I create the missing directories and file(s) ? I install

Re: [GENERAL] Hardware optimising

1999-08-26 Thread Bruce Momjian
> Hi > > I am about to upgrade a server that is about to be running a large and busy > postgresql database > currently it has > > 128 MB 100 MHz SDRAM > AMD K6-2/300 CPU > 10 GB 7200RPM 9.0ms IBM IDE HDD > > It will, over the next few months, as money becomes available, be upgraded to: > > 25

[GENERAL] error while vacuuming

1999-08-26 Thread Herbert Liechti
I try do vacuum a database: [PostgreSQL 6.5.0 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66] type \? for help on slash commands type \q to quit type \g or terminate with semicolon to execute query You are currently connected to the database: ecoscan ecoscan=> vacuum; ERROR: Inde

Re: [GENERAL] Hardware optimising

1999-08-26 Thread Roderick A. Anderson
On Thu, 26 Aug 1999, Michael wrote: > Hi > > I am about to upgrade a server that is about to be running a large and busy > postgresql database > currently it has > > 128 MB 100 MHz SDRAM > AMD K6-2/300 CPU > 10 GB 7200RPM 9.0ms IBM IDE HDD > >From experience I'd say the biggest performance i

Re: [GENERAL] Hardware optimising

1999-08-26 Thread amy cheng
if in doubt, memory first -- although it depends your app and hits. processor/disk: check your cpu use. amy >From: Michael <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: [EMAIL PROTECTED] >Subject: [GENERAL] Hardware optimising >Date: Thu, 26 Aug 1999 11:19:39 +0100 > >Hi > >I am about to

Re: [GENERAL] Web pages

1999-08-26 Thread The Hermit Hacker
On Thu, 26 Aug 1999, Oliver Elphick wrote: > The link from http://www.postgresql.org/index.html to > http://www.pgsql.com/contribute actually brings up the merchandise page. We merged the two...there is now a 'contribute' option on that page that will be extended over the next few days to give

[GENERAL] Hardware optimising

1999-08-26 Thread Michael
Hi I am about to upgrade a server that is about to be running a large and busy postgresql database currently it has 128 MB 100 MHz SDRAM AMD K6-2/300 CPU 10 GB 7200RPM 9.0ms IBM IDE HDD It will, over the next few months, as money becomes available, be upgraded to: 256 MB 100 MHz SDRAM Dual At

[GENERAL] Web pages

1999-08-26 Thread Oliver Elphick
The link from http://www.postgresql.org/index.html to http://www.pgsql.com/contribute actually brings up the merchandise page. -- Vote against SPAM: http://www.politik-digital.de/spam/ Oliver Elphick

RE: [GENERAL] changing between 6.4.1 and 6.5

1999-08-26 Thread Stuart Rison
At 8:38 am +0200 26/8/99, Jens Felber wrote: >At 18:02 25.08.99 +0200, dpeder wrote: >>have You set any triggers, rules, listens or defaults for tablex? >> > > >Nothing is set. I create a new table for tests. > > --> create table test1 (x1 int2, x2 int2, tx char); > >then I've inserted some values