pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Reinoud van Leeuwen <reinoud.v@n.leeuwen.net>
To: pgsql-sql@postgresql.org
Subject: Re: Max column number.
Date: Wed, 13 Jul 2011 17:53:55 +0200
Message-ID: <20110713155355.GU1984@spoetnik.xs4all.nl> (raw)
In-Reply-To: <CAB+MjFN49bMQz53ihFc4z5Xj4qbOwWhxiG0AC_JgUUPw4MbeGQ@mail.gmail.com>
References: <CAB+MjFNbwOcBdeMZQBKeNnWa8gGXHBLU-1dvs+3S32C0qZ9Agg@mail.gmail.com>
	<20110712175238.GJ1984@spoetnik.xs4all.nl>
	<CAB+MjFM=brC1xYZa-n+LsyaOMA0=x7UJt3znwVr1N8x5G2=tKg@mail.gmail.com>
	<20110712211240.GK1984@spoetnik.xs4all.nl>
	<CAB+MjFMuK-wv8QkOKr0Q=DKCmO2V1O8xJXPGXuDdC9Jh+TeQXA@mail.gmail.com>
	<CADwm0ajSYEvtUFoHLEVA=wH0nxfmNks2PnNuPrdrfRL0b1bU8Q@mail.gmail.com>
	<CADwm0aheThVQaQASBkHsVmjXmtJS+LZaRttmE-4WmEEff0TCzw@mail.gmail.com>
	<CAB+MjFN49bMQz53ihFc4z5Xj4qbOwWhxiG0AC_JgUUPw4MbeGQ@mail.gmail.com>

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...

Reinoud

-- 
__________________________________________________
"Nothing is as subjective as reality"
Reinoud van Leeuwen    reinoud.v@n.leeuwen.net
http://reinoud.van.leeuwen.net kvk 27320762
__________________________________________________



view thread (19+ messages)  latest in thread

Message-ID: <20110713155355.GU1984@spoetnik.xs4all.nl>
Permalink:  ../20110713155355.GU1984@spoetnik.xs4all.nl/
Also on:    postgresql.org/message-id/20110713155355.GU1984@spoetnik.xs4all.nl

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: reinoud.v@n.leeuwen.net
  Subject: Re: Max column number.
  In-Reply-To: <20110713155355.GU1984@spoetnik.xs4all.nl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox