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@panda.baobab.home [mailto:fred@panda.baobab.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
