Re: How can I Improve performance in Solaris?

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