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.cra...@gmail.com wrote:
This is an unfortunate situation, you shouldn't be required to do
this, the people generating your requirements
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
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
On Wed, Jul 13, 2011 at 9:45 AM, Miguel Angel Conte diaf...@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
How are you determining the data types for these columns?
On Wed, Jul 13, 2011 at 8:45 AM, Miguel Angel Conte diaf...@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
I have the metadata in the same csv.
On Wed, Jul 13, 2011 at 3:00 PM, Kevin Crain kevin.cra...@gmail.com wrote:
How are you determining the data types for these columns?
On Wed, Jul 13, 2011 at 8:45 AM, Miguel Angel Conte diaf...@gmail.com
wrote:
Hi,
Thanks for your interest. This app
Is there any room for improvement in the data types?
On Wed, Jul 13, 2011 at 11:03 AM, Miguel Angel Conte diaf...@gmail.com wrote:
I have the metadata in the same csv.
On Wed, Jul 13, 2011 at 3:00 PM, Kevin Crain kevin.cra...@gmail.com wrote:
How are you determining the data types for these
Have you tried changing the block size?
http://wiki.postgresql.org/wiki/FAQ#What_is_the_maximum_size_for_a_row.2C_a_table.2C_and_a_database.3F
On Wed, Jul 13, 2011 at 11:03 AM, Miguel Angel Conte diaf...@gmail.com wrote:
I have the metadata in the same csv.
On Wed, Jul 13, 2011 at 3:00 PM,
Hi,
I'm using postgresql 9 and I'd like to know if there is a way to ask if
when I'm going to add a column, I'm exceeding the max number of columns.
I've found that the max number of columns is 1600 and It's depends of the
data types.
I've made a test adding 1600 columns using different data
On Tue, Jul 12, 2011 at 02:48:26PM -0300, Miguel Angel Conte wrote:
Something like:
If I'm not going to exceed the size limit, then I can add a new column
You want to add columns in your application? Are you sure you have the
right datamodel?
Reinoud
--
Unfortunately It's an inherited data model and I can't make any change for
now...
Thanks for your answer!
On Tue, Jul 12, 2011 at 2:52 PM, Reinoud van Leeuwen
reinou...@n.leeuwen.net wrote:
On Tue, Jul 12, 2011 at 02:48:26PM -0300, Miguel Angel Conte wrote:
Something like:
If I'm not
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...
Thanks for your answer!
On Tue, Jul 12, 2011 at 2:52 PM, Reinoud van Leeuwen
reinou...@n.leeuwen.net wrote:
On Tue, Jul 12, 2011 at
Hi Ken,
Do you know a good way to get the max row size in a table?
Or maybe I'll have to get this information from the metadata
thanks!
On Tue, Jul 12, 2011 at 3:11 PM, k...@rice.edu k...@rice.edu wrote:
On Tue, Jul 12, 2011 at 03:08:36PM -0300, Miguel Angel Conte wrote:
On Tue, Jul 12, 2011 at 12:08 PM, Miguel Angel Conte diaf...@gmail.com wrote:
Unfortunately It's an inherited data model and I can't make any change for
now...
Thanks for your answer!
when you can change it, look at hstore
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make
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
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
reinou...@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
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
17 matches
Mail list logo