the primary key is flidload
----- Original Message -----
From: "scott.marlowe" <[EMAIL PROTECTED]>
To: "ingrid martinez" <[EMAIL PROTECTED]>
Cc: "Andrew Sullivan" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
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 [EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
