Re: SQL Server performing much better?!?!
От | Christian Cabanero |
---|---|
Тема | Re: SQL Server performing much better?!?! |
Дата | |
Msg-id | 000001c1cfdb$8c004560$0201a8c0@thematrix обсуждение исходный текст |
Ответ на | SQL Server performing much better?!?! ("Christian Cabanero" <chumpboy@yahoo.com>) |
Ответы |
Re: SQL Server performing much better?!?!
|
Список | 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@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
В списке pgsql-general по дате отправления: