Re: Max column number. - Mailing list pgsql-sql
| From | Kevin Crain |
|---|---|
| Subject | Re: Max column number. |
| Date | |
| Msg-id | CADwm0ahowU1gptPqK9AU3sN=hUHM+6Z+xeQR3kgmExBHY5W36A@mail.gmail.com Whole thread Raw |
| In response to | Re: Max column number. (Miguel Angel Conte <diafano@gmail.com>) |
| Responses |
Re: Max column number.
|
| List | pgsql-sql |
How are you determining the data types for these columns? On Wed, Jul 13, 2011 at 8:45 AM, Miguel Angel Conte <diafano@gmail.com> wrote: > 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 >> >> >> >> >> > > >