| From: | Joanne Formoso <joanneformoso(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Optimizing POSTGRESQL config |
| Date: | 2003-05-01 13:02:38 |
| Message-ID: | 20030501130238.87238.qmail@web40609.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
I'm new to POSTGRESQL but me and my friend are trying
to benchmark the database by populating one table with
100,000 records, affecting around 5 columns in one
row. The problem is our processing time is very
slow...around 30 minutes to 1 hour. There are times
it just hangs and stop execution. I was just
wondering if this was normal.
We structured our PHP code in such a way that isn't
optimized in order to isolate possible problems with
the database. We also used indices to speed up the
process from the database side. Any suggestions on
how to optimize Postgre SQL through its config files?
Thanks in advance!
__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonathan Wright | 2003-05-01 13:07:34 | Re: Problem in FOR loop |
| Previous Message | Ramesh PAtel | 2003-05-01 11:27:43 | Problem in FOR loop |