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 an
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
server.
eir Ad-Hoc tool was pretty
impressive.
I had forgotten about Tableau, and it appears they have a server component
now. That's good to hear.
--
Anthony Presley
l-downs in.
... Was hoping this wasn't going to be 30 tools to accomplish our needs.
--
Anthony Presley
2011/10/12 Ondrej Ivanič
> Hi,
>
> On 12 October 2011 14:50, Anthony Presley 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
>
s the PG route here? 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 writes:
> > Every so often (usually in the early morning), we are seeing an "
> > in transaction" show up. This appears to lock / block other statements
> > from going through, though I'm
On Wed, 2010-07-14 at 20:32 +0100, Thom Brown wrote:
> On 14 July 2010 20:23, Anthony Presley wrote:
> > Hi all,
> >
> > We tend to do a lot of lookups on our database that look something like:
> >
> > select
> >e.id
> > from
> > employe
On Wed, 2010-07-14 at 15:56 -0400, Tom Lane wrote:
> Thom Brown writes:
> > On 14 July 2010 20:23, Anthony Presley wrote:
> >> select
> >>e.id
> >> from
> >> employee e ,app_user au
> >>where
> >> au.id=user_
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
bytea2text(DECRYPT(decode(e.ssn,
10(50304)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 -05
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
gotten
12 matches
Mail list logo
