I know I am sticking my nose in an area here that I have not been
involved in but
this issue is important to me.
Chethana I have a couple of questions based on what you said you are
using as a
platform. see below :
On Feb 22, 2006, at 8:22 AM, Richard Huxton wrote:
> Chethana, Rao (IE10) wrote:
>> Hello!
>> Thank you for responding quickly. I really need ur help.
>
> Please make sure you cc: the list - I don't read this inbox regularly.
>
>> Sir, here r the answers for ur questions, please do tell me what
>> to do
>> next(regarding increasing performance of postgresql), so that I can
>> proceed further.
>> How are you using PostgreSQL?
>> We r using 7.4.3 with max of (512*6) around 3000 records.
>
> Max of what are (512*6)? Rows? Tables? Sorry - I don't understand
> what you mean here.
>
> Oh, and upgrade to the latest release of 7.4.x - there are
> important bugfixes.
>
>> How many concurrent users?
>> It configures for 100, but we r using 4 or 5 only.
>> Mostly updates or small selects or large summary reports?
>> Update,delete,insert operations.
>> What hardware do you have?
>> X86 based, 233 MHz, 256 MB RAM.
What Operating System are you running this on??
How much "other" stuff or applications are you running on the box
Is this a IDE hard drive system?? SCSI?? Bus Speed?? is it a older
server or a pc??
You dont have a large database at all but quick access to the data
that is residing in
the database has a lot to do with how the hardware is configured and
what other programs
are using the limited system resources!
>
> Hmm - not blazing fast, but it'll certainly run on that.
>
>> What configuration changes have you made?
>> No changes, we've used default settings.
>
> That will need changing. As Gourish suggested in another reply,
> read the notes here:
> http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
>
> You'll want to be careful with the memory settings given that
> you've only got 256MB to play with. Don't allocate too much to
> PostgreSQL itself, let the o.s. cache some files for you.
>
>> Are you having problems with all queries or only some?
>> Only some queries, particularly foreign key.
>
> Are you happy that there are indexes on the referring side of the
> foreign key where necessary? The primary keys you reference will
> have indexes on them, the other side will not unless you add them
> yourself.
>
>> Have you checked the plans for these with EXPLAIN ANALYSE?
>> No.
>
> That would be something worth doing then. Find a bad query, run
> EXPLAIN ANALYSE SELECT ... and post a new question with the output
> and details of the tables involved.
>
>> Have you made sure your tables are vacuumed and analysed?
>> Yes.
>
> Good. With the limited amount of RAM you have, you'll want to use
> it as efficiently as possible.
>
> --
> Richard Huxton
> Archonet Ltd
Theodore LoScalzo
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
