From: Phadnis <shphadnis@rediffmail.com>
To: pgsql-performance@postgresql.org
Subject: help needed asap....
Date: 12 Mar 2006 11:46:25 -0000
Message-ID: <20060312114625.7463.qmail@webmail8.rediffmail.com> (raw)
Hi.
I am new to postgres and i need help from u.i hope i get positive response.. though my questions mite seem silly to u...
iam working on postgres.. i have around 1 lakh records in almost 12 tables..
1 ) when i try to query for count or for any thg it takes a long time to return the result. How to avoid this
2) also i want to know how to increase the performance..( i do vacuum once in a day)
3) apart from that iam connecting to it through asp.net.. so when i try to fetch rcords the connection breaks..
how to avoid this..(very immp)
4) also in the tables i put a column -- serial id . so when i try to insert new records after deleting the records(lets say at that time the last sequence number was 100).. when i insert new record it will start with 101..
suppose the sequence number reaches its maximum limit can i use the previous 1-100 values, by using the cycled option.
Thks..
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: shphadnis@rediffmail.com
Subject: Re: help needed asap....
In-Reply-To: <20060312114625.7463.qmail@webmail8.rediffmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox