Re: postgresql and openmosix migration

От: Andrew Hammond
Тема: Re: postgresql and openmosix migration
Дата: ,
Msg-id: 40D997F9.7000700@ca.afilias.info
(см: обсуждение, исходный текст)
Ответ на: Re: postgresql and openmosix migration  ("Bill")
Список: pgsql-performance

Скрыть дерево обсуждения

postgresql and openmosix migration  ("Bill", )
 Re: postgresql and openmosix migration  (Josh Berkus, )
 Re: postgresql and openmosix migration  ("Bill", )
  Re: postgresql and openmosix migration  (Bruno Wolff III, )
  Re: postgresql and openmosix migration  (Richard Welty, )
  Re: postgresql and openmosix migration  ("Matthew Nuzum", )
  Re: postgresql and openmosix migration  (Joe Conway, )
  Re: postgresql and openmosix migration  (Andrew Hammond, )
  Re: postgresql and openmosix migration  (Josh Berkus, )
   Re: postgresql and openmosix migration  (Rod Taylor, )
    Re: postgresql and openmosix migration  (Richard Welty, )
 Re: postgresql and openmosix migration  (<>, )
 Re: postgresql and openmosix migration  ("Merlin Moncure", )

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Bill wrote:
| Ok, so maybe someone on this group will have a better idea.  We have a
| database of financial information, and this has literally millions of
| entries.  I have installed indicies, but for the rather computationally
| demanding processes we like to use, like a select query to find the
| commodity with the highest monthly or annual returns, the computer
generally
| runs unacceptably slow.  So, other than clustring, how could I achieve a
| speed increase in these complex queries?  Is this better in mysql or
| postgresql?

Postgres generally beats MySQL on complex queries. The easiest solution
to speed issues is to throw hardware at it. Generally, you're first
bound by disk, RAM then CPU.

1) Move your data over to an array of smallish 15kRPM disks. The more
spindles the better.
2) Use a 64 bit platform and take advantage of >4 GB memory.

There are dozens of options for the disk array. For the processing
platform, I'd recommend looking at Opteron. I've heard only good things
and their price is much more reasonable than the other options.

- --
Andrew Hammond    416-673-4138    
Database Administrator, Afilias Canada Corp.
CB83 2838 4B67 D40F D086 3568 81FC E7E5 27AF 4A9A
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFA2Zf3gfzn5SevSpoRAr0HAJ0S/uVjuqYEuhMgdSAI3rfHK0ga1wCgwpHl
g+yuBYpAt58vnJWtX+wii1s=
=2fGN
-----END PGP SIGNATURE-----

Вложения

В списке pgsql-performance по дате сообщения:

От: Laurent Martelli
Дата:
Сообщение: Re: Traduc Party
От: "Shea,Dan [CIS]"
Дата:
Сообщение: Re: after using pg_resetxlog, db lost