2009/6/1 Andrew Smith :
> 2009/6/2 björn lundin
>>
>> > CREATE TABLE "DataImport"
>> > (
>> > "DataImportID" serial NOT NULL PRIMARY KEY,
>> > "Time" timestamp without time zone NOT NULL,
>> > "ID_ABC" integer NOT NULL,
>> > "ID_DEF" integer NOT NULL,
>> > "ID_HIJ" integer NOT NULL,
>> >
On Tue, Jun 2, 2009 at 2:27 PM, Merlin Moncure wrote:
> _IF_ arrays fit your requirements, they are an extremely compact and
> efficient way to store your data. The requirements are exact..you
> can't update or extract a single piece of data out of a block
> efficiently. While indexing techniqu
On Mon, Jun 1, 2009 at 8:41 AM, Sam Mason wrote:
> On Mon, Jun 01, 2009 at 06:53:30AM -0500, Chris Spotts wrote:
>> I just finished doing something very close to this - not quite once per
>> minute, but close. I started off with an array of integers and after about
>> a month of it, I'm having to
2009/6/2 björn lundin
>
> > CREATE TABLE "DataImport"
> > (
> > "DataImportID" serial NOT NULL PRIMARY KEY,
> > "Time" timestamp without time zone NOT NULL,
> > "ID_ABC" integer NOT NULL,
> > "ID_DEF" integer NOT NULL,
> > "ID_HIJ" integer NOT NULL,
> > etc
> > );
>
> Perhaps you want
2009/6/1 björn lundin :
>
>> CREATE TABLE "DataImport"
>> (
>> "DataImportID" serial NOT NULL PRIMARY KEY,
>> "Time" timestamp without time zone NOT NULL,
>> "ID_ABC" integer NOT NULL,
>> "ID_DEF" integer NOT NULL,
>> "ID_HIJ" integer NOT NULL,
>> etc
>> );
>
> Perhaps you want to not u
> CREATE TABLE "DataImport"
> (
> "DataImportID" serial NOT NULL PRIMARY KEY,
> "Time" timestamp without time zone NOT NULL,
> "ID_ABC" integer NOT NULL,
> "ID_DEF" integer NOT NULL,
> "ID_HIJ" integer NOT NULL,
> etc
> );
Perhaps you want to not use the "" around the table and column
one word, horizontal structure. you are trying to sort 1500 colums,
instead of creating 1500 rows per entry...
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, Jun 01, 2009 at 06:53:30AM -0500, Chris Spotts wrote:
> I just finished doing something very close to this - not quite once per
> minute, but close. I started off with an array of integers and after about
> a month of it, I'm having to redesign my way out of it.
I've had to go the other w
gsql-general-ow...@postgresql.org] On Behalf Of Sam Mason
Sent: Monday, June 01, 2009 5:00 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] newbie table design question
On Sun, May 31, 2009 at 11:54:09PM +0800, Andrew Smith wrote:
> I'm a beginner when it comes to Postgresql, and have
On Sun, May 31, 2009 at 11:54:09PM +0800, Andrew Smith wrote:
> I'm a beginner when it comes to Postgresql, and have a table design question
> about a project I'm currently working on. I have 1500 data items that need
> to be copied every minute from an external system into my database. The
> ite
On Mon, Jun 1, 2009 at 1:25 AM, Tom Lane wrote:
> Andrew Smith writes:
> > I'm a beginner when it comes to Postgresql, and have a table design
> question
> > about a project I'm currently working on. I have 1500 data items that
> need
> > to be copied every minute from an external system into m
Andrew Smith writes:
> I'm a beginner when it comes to Postgresql, and have a table design question
> about a project I'm currently working on. I have 1500 data items that need
> to be copied every minute from an external system into my database. The
> items have a timestamp, an identifier and a
Hi all,
I'm a beginner when it comes to Postgresql, and have a table design question
about a project I'm currently working on. I have 1500 data items that need
to be copied every minute from an external system into my database. The
items have a timestamp, an identifier and a value. For example:
13 matches
Mail list logo
