From: | Justin Clift <justin(at)postgresql(dot)org> |
---|---|
To: | josh(at)agliodbs(dot)com |
Cc: | marie(dot)tuite(at)edisonaffiliates(dot)com, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: sloooow query |
Date: | 2002-10-07 19:30:03 |
Message-ID: | 3DA1E0BB.236FCC17@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-performance |
Josh Berkus wrote:
>
> Marie,
>
> > I am experiencing slow db performance. I have vacuumed, analyzed, reindexed
> > using the force option and performance remains the same - dog-slow :( If I
> > drop and recreate the database, performance is normal, so this suggests a
> > problem with the indexes? I also took a look at the postgresql.conf and all
> > appears fine. There are many instances of the same database running on
> > different servers and not all servers are experiencing the problem.
>
> Please post the following:
> 1) A copy of the relevant portions of your database schema.
> 2) The query that is running slowly.
> 3) The results of running EXPLAIN on that query.
> 4) Your PostgreSQL version and operating system
> 5) Any other relevant information about your databases, such as the quantity
> of inserts and deletes on the relevant tables.
6) And the sort_mem, shared_buffers, vacuum_mem, wal_buffers, and
wal_files settings from your postgresql.conf file, if possible.
:-)
Regards and best wishes,
Justin Clift
> --
> -Josh Berkus
> Aglio Database Solutions
> San Francisco
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas F.O'Connell | 2002-10-07 19:38:47 | news.postgresql.org |
Previous Message | Josh Berkus | 2002-10-07 19:29:17 | Re: sloooow query |
From | Date | Subject | |
---|---|---|---|
Next Message | Marie G. Tuite | 2002-10-07 19:49:16 | Re: sloooow query |
Previous Message | Josh Berkus | 2002-10-07 19:29:17 | Re: sloooow query |