From: | "Christian Cabanero" <chumpboy(at)yahoo(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: SQL Server performing much better?!?! |
Date: | 2002-03-20 06:50:38 |
Message-ID: | 000001c1cfdb$8c004560$0201a8c0@thematrix |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Good point, here's the info I should've also provided:
- 7.2, installed from the source.
- Solaris 2.6
- Only compilation option changed was --prefix to install to a different
directory
- all config settings were left at default, but i also experimented with
upping sort_mem but that's it.
- to start all i do is use this command:
postmaster -i -S -D /usr/local/pgsql/data >& /usr/var/log/pgsql.log
That's pretty much it, obviously nothing to fancy.
Again, any help would be incredibly appreciated. Right now I've got the
small company I work for that used to be completely a Micro$oft shop totally
sold on unix and more importantly open-source, but this performance problem
sure isn't helping my little "campaign." ;-)
Thanks,
Christian
-----Original Message-----
From: fred(at)panda(dot)baobab(dot)home [mailto:fred(at)panda(dot)baobab(dot)home]On Behalf Of
Frederic Saincy
Sent: Tuesday, March 19, 2002 8:37 PM
To: Christian Cabanero
Subject: Re: [GENERAL] SQL Server performing much better?!?!
Hi,
Maybe you should post on the list
- your postgresql version (there are some bugs in older optimizer for
some sql syntax )
- your solaris version
- your compilation options
- your config files
- your starting options
...
I can't help right now, maybe someone could
Bye.
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Neil Conway | 2002-03-20 07:05:30 | Re: SQL Server performing much better?!?! |
Previous Message | Neil Conway | 2002-03-20 05:48:52 | Re: Notify argument? |