X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 659A6D1B58A for ; Wed, 13 Aug 2003 16:56:19 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 37951-09 for ; Wed, 13 Aug 2003 13:54:41 -0300 (ADT) Received: from correo (correo.qoslabs.com [157.238.87.78]) by svr1.postgresql.org (Postfix) with ESMTP id 413F1D1C936 for ; Wed, 13 Aug 2003 13:56:07 -0300 (ADT) Received: from ldap-02.qoslabs.com (ldap-02 [172.20.1.31]) by correo-01.qoslabs.com (iPlanet Messaging Server 5.2 Patch 1 (built Aug 19 2002)) with SMTP id <0HJK00EK6HP4RF@correo-01.qoslabs.com> for pgsql-performance@postgresql.org; Wed, 13 Aug 2003 12:55:52 -0400 (EDT) Received: (from ingridmartinez [148.233.235.189]) by ldap-02.qoslabs.com (NAVGW 2.5.2.12) with SMTP id M2003081312555023228 ; Wed, 13 Aug 2003 12:55:51 -0400 Date: Wed, 13 Aug 2003 11:55:00 -0500 From: ingrid martinez Subject: Re: How can I Improve performance in Solaris? To: "scott.marlowe" Cc: Andrew Sullivan , pgsql-performance@postgresql.org Message-id: <00c601c361bb$a34c4890$8e64a8c0@ingridmartinez> MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Mailer: Microsoft Outlook Express 6.00.2800.1158 Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: 7BIT X-Priority: 3 X-MSMail-priority: Normal References: X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/244 X-Sequence-Number: 3061 the primary key is flidload ----- Original Message ----- From: "scott.marlowe" To: "ingrid martinez" Cc: "Andrew Sullivan" ; 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