Re: :Posgres - performance problem

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: :Posgres - performance problem
Дата
Msg-id 5512C990.8000209@aklaver.com
обсуждение исходный текст
Ответ на Re: :Posgres - performance problem  (ginkgo36 <ginkgo56@gmail.com>)
Ответы Re: :Posgres - performance problem  ("lucas.gary@gmail.com" <lucas.gary@gmail.com>)
Список pgsql-general
On 03/25/2015 07:30 AM, ginkgo36 wrote:
> @Gary
> I'm working on big data, because of the demands of the job so I
> export/import/update data on this table every day.
>
>   I guess it's possible that each query would need all 417 columns but it
> seems unlikely... --> Yes, not at all but 2/3 of 417 columns :)

There is also the matter of the 34 indexes, which can thought of as 34
axillary tables that need to be kept in sync with the main table.

>
> I need gather data into one table for consistency and easy for export and
> import, it's ok if I split data to smaller tables, but when
> export/import/update, i must excute query on alot of table. And this way
> lead data to inconsistency if I forget update/export/import on 1 or more
> table. It is terrible.
>
>
> @John
>
> I will learing about it. Thanks alot.
>
> @All: If you have any suggestion, please let me known. Thanks for you help
>
>
>



--
Adrian Klaver
adrian.klaver@aklaver.com


В списке pgsql-general по дате отправления:

Предыдущее
От: YBarot@symcor.com
Дата:
Сообщение: Postgresql 9.5
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Postgresql 9.5