On Fri, Sep 9, 2016 at 3:14 AM, Ashish Chauhan
wrote:
> Thanks Venkata for your reply.
>
>
>
> Currently, we have two Postgres server with master-slave streaming
> replication. All application servers are directly pointing to master server
> only. I am planning to setup new server for PgPool, at
I've done the upgrade to 9.5. Memory bloat has reduced to a more
manageable level. Most workers have an overhead of <20MB, with one outlier
consuming 60MB.
— Theron
On Fri, Aug 26, 2016 at 5:41 AM, Tom Lane wrote:
> Theron Luhn writes:
> > Okay, I got a semi-reproducible test case:
> > http
>
>
> Isn't this heading in the wrong direction? We need to be more precise
> than 0 (since 0 is computed off of rounded/truncated time stamps), not less
> precise than 0.
>
> Cheers,
>
> Jeff
>
Hmm, You may be right, reading it 4 more times for comprehension it looks
like it should be set to -
On Wed, Sep 7, 2016 at 4:49 PM, Jim Nasby wrote:
> On 9/7/16 6:10 PM, David Gibbons wrote:
>
>> That is NOT safe. The problem is it allows rsync to use mtime alone
>> to decide that a file is in sync, and that will fail if Postgres
>> writes to a file in the same second that the first
On Wed, Sep 7, 2016 at 4:31 PM, John R Pierce wrote:
> On 9/7/2016 1:36 PM, Ken Tanzer wrote:
>
>> No transformation is needed, except for padding the fields out to their
>> maximum lengths.
>>
>
> without accessing metadata, how would you know what those maximum lengths
> are??
>
I agree you'd
On Wed, Sep 7, 2016 at 4:39 PM, Adrian Klaver
wrote:
> On 09/07/2016 04:25 PM, Jim Nasby wrote:
>
>> On 9/7/16 6:07 PM, Ken Tanzer wrote:
>>
>>> ERROR: PL/Python functions cannot accept type record
>>>
>>
>> Ugh, yeah... that won't work. plperl might be able to do it, but I
>> suspect you're goi
Hi,
we are trying to install pgaudit in order to check its funcionality, and we'd
like to know if there is any available rpm to do this.
Thanks in advance
Regards,
Guillermo Picci
On 09/08/2016 04:30 AM, Moreno Andreo wrote:
Hi folks! :-)
This morning I was woken up by a call of a coworker screaming "Help, our
Postgres server is throwing strange errors!"
Not the best way to start your day...
OK, to the serious part.
"Strange errors" were (in postgresql-9.1-main.log)
WAR
On Sat, 2016-09-03 at 21:36 +1200, Tim Uckun wrote:
> Does anybody use an IDE for doing heavy duty stored proc development? PGadmin
> is decent but I am looking for something better.
>
> I have tried jetbrains with the db browser plugin and on the surface it seems
> like a good choice but it's re
On Tue, Sep 6, 2016 at 5:25 PM, John R Pierce wrote:
> On 9/6/2016 4:20 PM, Melvin Davidson wrote:
>>
>> If you use slony to replicate, you CAN have 9.2 on the master and 9.4 on
>> the slave.
>
>
> does rackspace support slony? how about amazon dms ?
>
> slony requires configuring replication on
On Wed, Sep 7, 2016 at 5:00 PM, Jim Nasby wrote:
> On 9/2/16 11:44 AM, David Gibbons wrote:
>>
>> rsync -va /var/lib/pgsql/ /var/lib/pgsql2/
>> service postgres stop
>> rsync -va /var/lib/pgsql/ /var/lib/pgsql2/
>>
>> The second rsync will only copy the deltas from the first, it still has
>> to go
Hi,
For what it's worth, Database Workbench with PostgreSQL support was
released Yesterday.
http://www.upscene.com/database_workbench/whatsnew
With regards,
Martijn Tonies
Upscene Productions
[...]
Hmm... exe's don't work natively on Linux...
Of course they don't. Here's some guides for
Hi,
Sorry for appending to that thread, but I think this is related:
Does anyone have experience with parsel [1] and/or it's extension
parallelsql [2]?
:Stefan
[1]
http://geeohspatial.blogspot.ch/2013/12/a-simple-function-for-parallel-queries_18.html
[2] https://github.com/k1aus/parallelsql
Hi folks! :-)
This morning I was woken up by a call of a coworker screaming "Help, our
Postgres server is throwing strange errors!"
Not the best way to start your day...
OK, to the serious part.
"Strange errors" were (in postgresql-9.1-main.log)
WARNING: out of shared memory
ERROR: out of sha
Upscene Productions is proud to announce the availability of
the next version of the popular multi-DBMS development tool:
" Database Workbench 5.2 "
This release includes support for PostgreSQL and adds several other features.
Database Workbench 5 comes in multiple editions with different pricin
On 08/09/16 19:42, Martijn Tonies (Upscene Productions) wrote:
Hi,
For what it's worth, Database Workbench with PostgreSQL support was
released Yesterday.
http://www.upscene.com/database_workbench/whatsnew
With regards,
Martijn Tonies
Upscene Productions
[...]
Hmm... exe's don't work nat
On Thu, Sep 8, 2016 at 2:35 AM, dandl wrote:
> I understand that. What I'm trying to get a handle on is the magnitude of
> that cost and how it influences other parts of the product, specifically
> for Postgres. If the overhead for perfect durability were (say) 10%, few
> people would care about
Hi,
For what it's worth, Database Workbench with PostgreSQL support
was released Yesterday.
http://www.upscene.com/database_workbench/whatsnew
With regards,
Martijn Tonies
Upscene Productions
-Original Message-
From: Jim Nasby
Sent: Thursday, September 08, 2016 1:33 AM
To: Tim U
18 matches
Mail list logo
