Re: How can I Improve performance in Solaris? - Mailing list pgsql-performance

From scott.marlowe
Subject Re: How can I Improve performance in Solaris?
Date
Msg-id Pine.LNX.4.33.0308131047150.7252-100000@css120.ihs.com
Whole thread Raw
In response to Re: How can I Improve performance in Solaris?  (ingrid martinez <ingridm@qoslabs.com>)
List pgsql-performance
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?


pgsql-performance by date:

Previous
From: ingrid martinez
Date:
Subject: Re: How can I Improve performance in Solaris?
Next
From: ingrid martinez
Date:
Subject: Re: How can I Improve performance in Solaris?