Skip site navigation (1) Skip section navigation (2)

PostgreSQL performance deteriorates over time?

From: tvahakan(at)fw(dot)cluster(dot)net
To: pgsql-novice(at)postgresql(dot)org
Subject: PostgreSQL performance deteriorates over time?
Date: 2001-11-15 12:28:52
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Hello all,

how fast PostgreSQL is supposed to be? Assume a table with
three columns (integer, char, char) and with 100 rows and
an index. Using libpq++ simple UPDATE has gone from under
one millisecond to over 20 milliseconds after a few days of
uptime (mostly idle)? VACUUM ANALYZE didn't help, but
restarting postmaster did. (All this with datasync turned
off with -o -F switches.) What am I doing wrong?

Some info: PostgreSQL 7.1.3, running on Linux 2.2.18 (or
somesuch) on 1GHz PentiumIII with 256MB RAM. PostgreSQL is
compiled from sources, gcc is redhat's 2.96-85. I'm a newbie
when it comes to databases, please tell me if I forgot some
vital information. Also if this is a FAQ or RTFM question,
please do tell where can I find it. I've already read
"3.7) How do I tune the database engine for better
And, no I don't think tweaks other than datasync make any
difference, since my program is serialized (only one query
active at a time).

Thanks for any help.



pgsql-novice by date

Next:From: Ext-Taneli.VahakangasDate: 2001-11-15 15:50:37
Subject: Re: PostgreSQL performance deteriorates over time?
Previous:From: Josh BerkusDate: 2001-11-14 21:34:59
Subject: Re: Help with Outer Joins

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group