I am puzzled about the extent to which shared_bufferes is used for
different queries. Do _all_ queries "touch" shared buffers at some point
of their execution?
Many of our warehouse queries are seq_scan followed by HASH. I know
work_mem is assigned for HASH joins: but does this mean that thes
On Tue, 24 Dec 2013 14:39:42 +0800 Sameer Kumar wrote:
>
> * Cascading replication chains (a really big deal when you want
>
> multiple slaves in the secondary facility and don't want to hog
>
> your bandwidth)
>
> Really? which version of Postgres are we talking about? I think cascaded
> r
On Sun, Dec 29, 2013 at 9:05 PM, Shiv Sharma wrote:
> I am puzzled about the extent to which shared_bufferes is used for different
> queries. Do _all_ queries "touch" shared buffers at some point of their
> execution?
>
> Many of our warehouse queries are seq_scan followed by HASH. I know
> wo
>> > * Quick and easy movement of the master to any of the database in
>> >
>> > the cluster without destroying replication.
>> >
>> > Again, which version? Re-mastering is made simple in v9.3.
>> I'm not seeing that in the documentation. In fact, what I'm finding
>> seems to suggest the opposi
On Mon, 30 Dec 2013 00:15:37 +0800 Sameer Kumar wrote:
> >> > * Quick and easy movement of the master to any of the database in
> >> >
> >> > the cluster without destroying replication.
> >> >
> >> > Again, which version? Re-mastering is made simple in v9.3.
>
> >> I'm not seeing that in the d
>
> What I don't see streaming working for is DR drills. I need to, in a
> controlled manner, move the entire application to the secondary datacenter,
> while keeping all the nodes in sync, make sure everything operates properly
> from there (which means allowing database updates), then move it al
Thanks. We are on Greenplum GP 4.2 (Postgres 8.2). As per GP suggestions,
we have 6 primary/6 mirror instances on each server. The server has 64 G
RAM, and shared_buffers is at ...125 MB :-). I suppose the idea is for the
OS buffer cache to do the legwork.
But still...performance is at least "n
On Wed, Dec 18, 2013 at 3:39 PM, Sergey Konoplev wrote:
> On Wed, Dec 18, 2013 at 11:26 AM, Joe Van Dyk wrote:
> > I'm running Postgresql 9.3. I have a streaming replication server.
> Someone
> > was running a long COPY query (8 hours) on the standby which halted
> > replication. The replication
On Sun, Dec 29, 2013 at 9:56 PM, Joe Van Dyk wrote:
> On Wed, Dec 18, 2013 at 3:39 PM, Sergey Konoplev wrote:
>>
>> On Wed, Dec 18, 2013 at 11:26 AM, Joe Van Dyk wrote:
>> > I'm running Postgresql 9.3. I have a streaming replication server.
>> > Someone
>> > was running a long COPY query (8 hour
