Search Postgresql Archives

Re: Poor query performance on one of two "like" databases in production.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Keaton_Adams@xxxxxxxxxx
Subject: Re: Poor query performance on one of two "like" databases in production.
From: Stephen Frost <sfrost@xxxxxxxxxxx>
Date: Fri, 14 May 2010 14:54:15 -0400
Cc: vivek@xxxxxxxxx, pgsql-general@xxxxxxxxxxxxxx
In-reply-to: <C812F560.166D6%keaton_adams@xxxxxxxxxx>
User-agent: Mutt/1.5.18 (2008-05-17)

* Keaton_Adams@xxxxxxxxxx (Keaton_Adams@xxxxxxxxxx) wrote:
> Yes, I triple checked and the schemas, indexes, FKs, triggers all match.

Have you checked over for any enable_* settings that are off?  Identical
work_mem and maintenance_work_mem settings?

	Thanks,
		
		Stephen

Attachment: signature.asc
Description: Digital signature

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Poor query performance on one of two "like" databases in production.
  - From: Keaton_Adams

References:
- Re: Poor query performance on one of two "like" databases in production.
  - From: Stephen Frost
- Re: Poor query performance on one of two "like" databases in production.
  - From: Keaton_Adams

Prev by Date: Re: Poor query performance on one of two "like" databases in production.
Next by Date: Re: Poor query performance on one of two "like" databases in production.
Previous by thread: Re: Poor query performance on one of two "like" databases in production.
Next by thread: Re: Poor query performance on one of two "like" databases in production.
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux