Re: [SQL] Max column number.

2011-07-13 Thread Kevin Crain
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

Re: [SQL] Max column number.

2011-07-13 Thread Miguel Angel Conte
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

Re: [SQL] Max column number.

2011-07-13 Thread Reinoud van Leeuwen
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

Re: [SQL] Max column number.

2011-07-13 Thread Scott Marlowe
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

Re: [SQL] Max column number.

2011-07-13 Thread Kevin Crain
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

Re: [SQL] Max column number.

2011-07-13 Thread Miguel Angel Conte
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

Re: [SQL] Max column number.

2011-07-13 Thread Kevin Crain
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

Re: [SQL] Max column number.

2011-07-13 Thread Kevin Crain
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,

[SQL] Max column number.

2011-07-12 Thread Miguel Angel Conte
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

Re: [SQL] Max column number.

2011-07-12 Thread Reinoud van Leeuwen
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 --

Re: [SQL] Max column number.

2011-07-12 Thread Miguel Angel Conte
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

Re: [SQL] Max column number.

2011-07-12 Thread k...@rice.edu
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

Re: [SQL] Max column number.

2011-07-12 Thread Miguel Angel Conte
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:

Re: [SQL] Max column number.

2011-07-12 Thread Scott Marlowe
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

Re: [SQL] Max column number.

2011-07-12 Thread Reinoud van Leeuwen
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

Re: [SQL] Max column number.

2011-07-12 Thread Miguel Angel Conte
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

Re: [SQL] Max column number.

2011-07-12 Thread Kevin Crain
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