Skip site navigation (1) Skip section navigation (2)

Re: sloooow query

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

In response to

Responses

pgsql-performance by date

Next:From: Marie G. TuiteDate: 2002-10-07 19:49:16
Subject: Re: sloooow query
Previous:From: Josh BerkusDate: 2002-10-07 19:29:17
Subject: Re: sloooow query

pgsql-general by date

Next:From: Thomas F.O'ConnellDate: 2002-10-07 19:38:47
Subject: news.postgresql.org
Previous:From: Josh BerkusDate: 2002-10-07 19:29:17
Subject: Re: sloooow query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group