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: (view raw, whole thread or download thread mbox)
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?

"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


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
Previous:From: Josh BerkusDate: 2002-10-07 19:29:17
Subject: Re: sloooow query

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