Re: SQL Server performing much better?!?!

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