Re: sloooow query

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