Help: Choosing PostgreSQL vs MySQL
| От | Simon Kwan |
|---|---|
| Тема | Help: Choosing PostgreSQL vs MySQL |
| Дата | |
| Msg-id | 028f01bf08aa$97206b50$110540ca@hk.super.net обсуждение исходный текст |
| Ответ на | Re: [GENERAL] FATAL 1: Memory exhausted in AllocSetAlloc() (Martin Weinberg <weinberg@osprey.astro.umass.edu>) |
| Список | pgsql-general |
Hi greeting, I am new to Linux. Appreciate advise and comment on choosing between PosytgreSQL vs. MySQL. Both to be run under Linux. How does these two database compare with MS SQL 7.0? There are two options to configure the data base, a) The data base will have a few million rows, each row is about 100 bytes. One of the column (field) will be a pathname (filename) to index to an external files for storing images. Each image belongs to a particular row and image is 3 to 20 kb (variable size jepg files). b) same as the about, but the image will be stored as one filed in the data base. In this case, the data base will be much larger and wonder if it is size is okay (speed, capacity, etc...) Many thansk in advance. Appreciate email reply also. Simon
В списке pgsql-general по дате отправления: