Skip site navigation (1) Skip section navigation (2)

Re: Max column number.

From: Reinoud van Leeuwen <reinoud(dot)v(at)n(dot)leeuwen(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Max column number.
Date: 2011-07-13 15:53:55
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
On Wed, Jul 13, 2011 at 12:45:45PM -0300, Miguel Angel Conte 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.

Still, you could normalize the data in a better way, and present it to
users or an application with views or stored procedures...


"Nothing is as subjective as reality"
Reinoud van Leeuwen    reinoud(dot)v(at)n(dot)leeuwen(dot)net kvk 27320762

In response to

pgsql-sql by date

Next:From: Scott MarloweDate: 2011-07-13 16:51:06
Subject: Re: Max column number.
Previous:From: Miguel Angel ConteDate: 2011-07-13 15:45:45
Subject: Re: Max column number.

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group