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: | 20011115142852.B8434@fw.cluster.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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
performance?"
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.
Taneli
From | Date | Subject | |
---|---|---|---|
Next Message | Ext-Taneli.Vahakangas | 2001-11-15 15:50:37 | Re: PostgreSQL performance deteriorates over time? |
Previous Message | Josh Berkus | 2001-11-14 21:34:59 | Re: Help with Outer Joins |