Re: How can I Improve performance in Solaris?

the primary key is flidload

----- Original Message -----
From: "scott.marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: "ingrid martinez" <ingridm(at)qoslabs(dot)com>
Cc: "Andrew Sullivan" <andrew(at)libertyrms(dot)info>;
<pgsql-performance(at)postgresql(dot)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(at)postgresql(dot)org