| From: | "Williams, Travis L, NPONS" <tlw(at)att(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | perfomance question/issues |
| Date: | 2002-10-21 23:09:36 |
| Message-ID: | AB815D267EC31A4693CC24D234F8291602B2A953@ACCLUST02EVS1.ugd.att.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
Travis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Bartley | 2002-10-21 23:15:36 | Re: ERROR: _mdfd_getrelnfd: cannot open relation pg_temp_15300_53: No such file or directory |
| Previous Message | scott.marlowe | 2002-10-21 23:07:35 | Re: perfomance question/issues |