On Fri, Nov 22, 2013 at 11:46 PM, Albe Laurenz wrote:
> Michael Paquier wrote:
>> On Fri, Nov 22, 2013 at 10:03 PM, Kaushal Shriyan
>> wrote:
>>> I am not sure i understand the difference between async and sync replication
>>> and on what scenarios i should use async or sync replication. Does it
On Sat, Nov 23, 2013 at 4:30 PM, Tianyin Xu wrote:
> Hi,
>
> I want to tune the memory usage of PG (9.3.1) on my environment. I'm really
> confused by the following two configuration parameters,
>
> shared_buffers,
> temp_buffers,
>
> Take "shared_buffers" as the example, the manual says,
>
> "Set
Hi,
On 22 Listopad 2013, 20:09, Edson Richter wrote:
>
> Excuse me (or just ignore me) if it is a stupid question, but have you
> configured sysctl.conf accordingly?
> For instance, to use larget memory settings, I had to configure my EL as
> follows:
>
> # Controls the maximum shared segment size
On 11/23/2013 07:41 AM, Ken Tanzer wrote:
> OTOH, if there were a very clear and credible page with good
> instructions on installing build environment + postgres (for say RHEL,
> Ubuntu & Fedora) that would install side by side with an existing
> installation (and how to remove it all cleanly) it
On Sat, Nov 23, 2013 at 2:20 AM, Vik Fearing wrote:
> On 11/23/2013 07:41 AM, Ken Tanzer wrote:
>
> OTOH, if there were a very clear and credible page with good instructions
> on installing build environment + postgres (for say RHEL, Ubuntu & Fedora)
> that would install side by side with an exi
On 22 Nov 2013, at 21:56, Juan Daniel Santana Rodés
wrote:
> Hi everyone...
> I have a problem. I am programming a recursive function in plpgsql language.
> This function use a cursor and when the function try to call the same
> function throw a exception that it say me that the cursor is usin
Hi,
When conducting performance tests of our application, I saw quite a few
exclusive locks in SELECTs with WITH clause. So I created a big table and
executed a query which takes time.
with x as (select * from emp where first_name like 'Sco%')
select * from x;
I got 2 locks - one accesshare lock a
On 11/23/2013 02:45 AM, Ken Tanzer wrote:
On Sat, Nov 23, 2013 at 2:20 AM, Vik Fearing mailto:vik.fear...@dalibo.com>> wrote:
On 11/23/2013 07:41 AM, Ken Tanzer wrote:
OTOH, if there were a very clear and credible page with good
instructions on installing build environment + post
Ken Tanzer writes:
> On Sat, Nov 23, 2013 at 2:20 AM, Vik Fearing wrote:
>> Chapter 15 of our documentation handles installing from source.
>> http://www.postgresql.org/docs/current/static/installation.html
> Thanks for the link. I really do appreciate all the documentation that
> Postgres has
