Hi all!
We're working on our architecture for our next set of systems, and we
normally have a simple master/slave with wal shipping and hot_standby set
up, with pgpool sitting in front of both to do load balancing.
However, one piece I'm very confused about is the query plans on the slave
We're still considering this architecture - so I don't have any plans.
My question is, does the ANALYZE command, which is only executed on the
master, mean that the statistics / plans that are used on the master are
ALSO used on the slaves? OR does the slave create it's own plan?
I would
. That's good to hear.
--
Anthony Presley
2011/10/12 Ondrej Ivanič ondrej.iva...@gmail.com
Hi,
On 12 October 2011 14:50, Anthony Presley anth...@resolution.com wrote:
After a few weeks of searching around, we're running into dead-ends on
the
front-end, and the back-end. PG doesn't support OLAP / MDX and the
GUI
tools
in.
... Was hoping this wasn't going to be 30 tools to accomplish our needs.
--
Anthony Presley
? Are there some secrets / tips / tricks / contrib
modules for handling this?
--
Anthony Presley
On Tue, 2010-07-13 at 17:38 -0400, Tom Lane wrote:
Anthony Presley anth...@resolution.com writes:
Every so often (usually in the early morning), we are seeing an IDLE
in transaction show up. This appears to lock / block other statements
from going through, though I'm not sure why. If left
)LOG: duration: 476.522 ms
IE, the duration ends up on a different line, and basically none of the
statements ever match in your perl script.
Any guess here?
--
Anthony
On Wed, 2010-07-14 at 14:28 +0200, hubert depesz lubaczewski wrote:
On Tue, Jul 13, 2010 at 02:53:25PM -0500, Anthony Presley
Hi all,
We tend to do a lot of lookups on our database that look something like:
select
e.id
from
employee e ,app_user au
where
au.id=user_id and
au.corporation_id=$1 and
e.ssn is not null and
e.ssn!=' ' and
e.ssn!='' and
e.deleted='N'and
On Wed, 2010-07-14 at 15:56 -0400, Tom Lane wrote:
Thom Brown thombr...@gmail.com writes:
On 14 July 2010 20:23, Anthony Presley anth...@resolution.com wrote:
select
e.id
from
employee e ,app_user au
where
au.id=user_id and
au.corporation_id=$1 and
e.ssn
On Wed, 2010-07-14 at 20:32 +0100, Thom Brown wrote:
On 14 July 2010 20:23, Anthony Presley anth...@resolution.com wrote:
Hi all,
We tend to do a lot of lookups on our database that look something like:
select
e.id
from
employee e ,app_user au
where
au.id=user_id
Hi all,
I'm bordering on insanity, trying to track down an IDLE in transaction
problem.
This started a few weeks ago, and we are using a Java application,
running Spring 2.0, Hibernate 3.2 (with L2 cache), Postgres JDBC
8.3-604. We're also using pgBouncer (though, I've tried pgPool II and
12 matches
Mail list logo