X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 641EB9DCC88
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Sun, 12 Mar 2006 07:53:42 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 91445-07
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Sun, 12 Mar 2006 07:53:44 -0400 (AST)
X-Greylist: delayed 00:06:38.425634 by SQLgrey-
Received: from rediffmail.com (unknown [202.54.124.153])
	by postgresql.org (Postfix) with SMTP id 259959DCC4C
	for <pgsql-performance@postgresql.org>;
	Sun, 12 Mar 2006 07:53:38 -0400 (AST)
Received: (qmail 7464 invoked by uid 510); 12 Mar 2006 11:46:25 -0000
Date: 12 Mar 2006 11:46:25 -0000
Message-ID: <20060312114625.7463.qmail@webmail8.rediffmail.com>
Received: from unknown (220.227.249.101) by rediffmail.com via HTTP;
	12 mar 2006 11:46:20 -0000
MIME-Version: 1.0
From: "Phadnis" <shphadnis@rediffmail.com>
Reply-To: "Phadnis" <shphadnis@rediffmail.com>
To: pgsql-performance@postgresql.org
Subject: help needed asap....
Content-type: multipart/alternative;
	boundary="Next_1142163980---0-202.54.124.153-7350"
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=4.058 required=5 tests=[AWL=1.121,
	DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_WHOIS=0.879,
	HTML_IMAGE_ONLY_16=0.627,
	HTML_MESSAGE=0.001, HTML_SHORT_LINK_IMG_2=0.951,
	MSGID_FROM_MTA_HEADER=0]
X-Spam-Score: 4.058
X-Spam-Level: ****
X-Archive-Number: 200603/156
X-Sequence-Number: 17593

 This is a multipart mime message


--Next_1142163980---0-202.54.124.153-7350
Content-type: text/plain;
	charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

 =A0=0AHi.=0A=0AI am new to postgres and i need help from u.i hope i get po=
sitive response.. though my questions mite seem silly to u...=0A=0Aiam work=
ing on postgres.. i have around 1 lakh records in almost 12 tables..=0A1 ) =
when i try to query for count or for any thg it takes a long time to return=
 the result. How to avoid this=0A=0A2) also i want to know how to increase =
the  performance..( i do vacuum once in a day)=0A=0A3) apart from that iam =
connecting to it through asp.net.. so when i try to fetch rcords the connec=
tion breaks.. =0Ahow to avoid this..(very immp)=0A=0A4) also in the tables =
 i put a column -- serial id . so when i try to insert new records after de=
leting the records(lets say at that time the last sequence number was 100).=
. when i insert new record it will start with 101..=0Asuppose the sequence =
number reaches its maximum limit can i use the previous 1-100 values, by us=
ing the cycled option.=0A=0AThks..=0A=0A=0A=0A=0A
--Next_1142163980---0-202.54.124.153-7350
Content-type: text/html;
	charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<P>=0A&nbsp; <BR>=0AHi.<BR>=0A<BR>=0AI am new to postgres and i need help f=
rom u.i hope i get positive response.. though my questions mite seem silly =
to u...<BR>=0A<BR>=0Aiam working on postgres.. i have around 1 lakh records=
 in almost 12 tables..<BR>=0A1 ) when i try to query for count or for any t=
hg it takes a long time to return the result. How to avoid this<BR>=0A<BR>=
=0A2) also i want to know how to increase the&nbsp; performance..( i do vac=
uum once in a day)<BR>=0A<BR>=0A3) apart from that iam connecting to it thr=
ough asp.net.. so when i try to fetch rcords the connection breaks.. <BR>=
=0Ahow to avoid this..(very immp)<BR>=0A<BR>=0A4) also in the tables&nbsp; =
i put a column -- serial id . so when i try to insert new records after del=
eting the records(lets say at that time the last sequence number was 100)..=
 when i insert new record it will start with 101..<BR>=0Asuppose the sequen=
ce number reaches its maximum limit can i use the previous 1-100 values, by=
 using the cycled option.<BR>=0A<BR>=0AThks..<BR>=0A<BR>=0A<BR>=0A<BR>=0A<B=
R>=0A=0A</P>=0A<br><br>=0A<a href=3D"http://adworks.rediff.com/cgi-bin/AdWo=
rks/sigclick.cgi/www.rediff.com/signature-home.htm/1507191490@Middle5?PARTN=
ER=3D3"><IMG SRC=3D"http://adworks.rediff.com/cgi-bin/AdWorks/sigimpress.cg=
i/www.rediff.com/signature-home.htm/1963059423@Middle5?OAS_query=3Dnull&PAR=
TNER=3D3" BORDER=3D0 VSPACE=3D0 HSPACE=3D0></a>=0A
--Next_1142163980---0-202.54.124.153-7350--