the primary key is flidload
----- Original Message -----
From: "scott.marlowe" <scott.marlowe@ihs.com>
To: "ingrid martinez" <ingridm@qoslabs.com>
Cc: "Andrew Sullivan" <andrew@libertyrms.info>;
<pgsql-performance@postgresql.org>
Sent: Wednesday, August 13, 2003 11:47 AM
Subject: Re: [PERFORM] How can I Improve performance in Solaris?
> On Wed, 13 Aug 2003, ingrid martinez wrote:
>
> > Floes table looks like this
> >
> > Table "flows"
> > Column | Type | Modifiers
> > ----------------------+--------------------------+-----------
> > flidload | bigint | not null
> > firsttime | bigint |
> > fldestpeeraddress | character varying(30) |
> > fldesttransaddress | bigint |
> > fldesttranstype | smallint |
> > fldfromoctets | bigint |
> > fldscodepoint | smallint |
> > fldtooctets | bigint |
> > flfrompdus | bigint |
> > flid | text |
> > flidrule | bigint |
> > flsourcepeeraddress | character varying(30) |
> > flsourcetransaddress | bigint |
> > flsourcetranstype | smallint |
> > fltime | timestamp with time zone |
> > fltopdus | bigint |
> > lasttime | bigint |
> > sourceinterface | smallint |
> > destinterface | smallint |
> > sourceasn | smallint |
> > destasn | smallint |
> > Primary key: flows_pkey
>
> Which columns are in the pkey?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org