From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | "Williams, Travis L, NPONS" <tlw(at)att(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: perfomance question/issues |
Date: | 2002-10-22 00:06:48 |
Message-ID: | 20021021170521.I77022-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, 21 Oct 2002, Williams, Travis L, NPONS wrote:
> How can you tell what the performance of you DB is? I know a lot has
> to do with DB design.. I don't see postgres using a lot of memory or
> cpu on my system.. but everything seems a little slow for what I
> consider a small DB..
>
> What I have is 4 static columns that are indexed and roughly 460 that
> are updated. Now I have only 215 rows. If I update all of the
> columns then run vacuum analyze it takes 7-10 minutes. I also have
> had trouble doing updates... I have tried doing them through perl and
> psql by doing a \i then the file name.. I have also tried using begin;
> and end; around the file.. but it still takes 1 minute+ to update one
> row. any suggestions are welcome.
Are you using any foreign keys to/from this table that might be doing
checks on other tables?
From | Date | Subject | |
---|---|---|---|
Next Message | Williams, Travis L, NPONS | 2002-10-22 00:10:46 | Re: perfomance question/issues |
Previous Message | Josh Berkus | 2002-10-22 00:04:36 | Flyer, Press Release |