Re: Max column number.

Поиск
Список
Период
Сортировка
От Miguel Angel Conte
Тема Re: Max column number.
Дата
Msg-id CAB+MjFN49bMQz53ihFc4z5Xj4qbOwWhxiG0AC_JgUUPw4MbeGQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Max column number.  (Kevin Crain <kevin.crain1@gmail.com>)
Ответы Re: Max column number.
Re: Max column number.
Re: Max column number.
Список pgsql-sql
Hi,

Thanks for your interest. This app load scv files which change every day (sometimes the columns too). The sizes of these files are in avg 15MB. So, We load something like 100MB each day. We tried to find a better solution but we couldn't, becouse one of the our requirement is not to use a lot of space. Also, the app is used to consult these information, and for our particular type of select's queries, we get the best performance if the information is all into a same row.


On Wed, Jul 13, 2011 at 3:28 AM, Kevin Crain <kevin.crain1@gmail.com> wrote:
I still can't imagine why you'd ever need this...could you explain
what this does? I'm just curious now....

On Tue, Jul 12, 2011 at 10:55 PM, Kevin Crain <kevin.crain1@gmail.com> wrote:
> This is an unfortunate situation, you shouldn't be required to do
> this, the people generating your requirements need to be more
> informed.  I would make damn sure you notify the stakeholders in this
> project that the data model is screwed and needs a redesign.  I agree
> that you should split this table and do a join if you have no option
> of redesigning this.
>
> On Tue, Jul 12, 2011 at 4:29 PM, Miguel Angel Conte <diafano@gmail.com> wrote:
>> Yes, sure. I mean, I can't change the whole process which creates columns
>> dynamically.
>>
>> On Tue, Jul 12, 2011 at 6:12 PM, Reinoud van Leeuwen
>> <reinoud.v@n.leeuwen.net> wrote:
>>>
>>> On Tue, Jul 12, 2011 at 03:08:36PM -0300, Miguel Angel Conte wrote:
>>> > Unfortunately It's an inherited data model and I can't make any change
>>> > for
>>> > now...
>>>
>>> but by adding columns you *are* making changes to it...
>>>
>>> Reinoud
>>> --
>>> __________________________________________________
>>> "Nothing is as subjective as reality"
>>> Reinoud van Leeuwen    reinoud.v@n.leeuwen.net
>>> http://reinoud.van.leeuwen.net kvk 27320762
>>> __________________________________________________
>>>
>>> --
>>> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
>>> To make changes to your subscription:
>>> http://www.postgresql.org/mailpref/pgsql-sql
>>
>>
>

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

Предыдущее
От: Wes James
Дата:
Сообщение: Re: combining strings to make a query
Следующее
От: Reinoud van Leeuwen
Дата:
Сообщение: Re: Max column number.