Hi Melvin,
On 18/08/15 17:19, Melvin Davidson wrote:
8 x 16GB 1600MHz PC3-12800 DDR3 - 128GB total
>>shared_buffers=60GB
I would say 60GB is too high when you have 128GB system memory.
Try lowering it to shared_buffers=32GB and let the O/S handle more of
the work.
I have teste
Hi Alvaro,
On 18/08/15 17:39, Alvaro Herrera wrote:
Joshua D. Drake wrote:
On 08/18/2015 09:19 AM, Melvin Davidson wrote:
8 x 16GB 1600MHz PC3-12800 DDR3 - 128GB total
shared_buffers=60GB
I would say 60GB is too high when you have 128GB system memory.
Try lowering it to sha
Hi Alvaro,
On 18/08/15 17:41, Alvaro Herrera wrote:
Alvaro Herrera wrote:
One thing to look at is the rate of WAL generation for a set number of
transactions. Maybe the later releases are generating more WAL due to
multixacts, for instance (prior to 9.3 these weren't wal-logged.)
Also try 9
Hi Joshua,
On 18/08/15 16:12, Joshua D. Drake wrote:
On 08/18/2015 08:01 AM, Michael H wrote:
Hi,
I've been tuning our new database server, here's some info...
CentOS Linux release 7.1.1503 (Core)
3.10.0-229.11.1.el7.x86_64
8 x 16GB 1600MHz PC3-12800 DDR3- 128GB total
2 x AMD O
A couple more links here about issues with kernel 3.10
http://www.databasesoup.com/2014/09/why-you-need-to-avoid-linux-kernel-32.html
http://www.postgresql.org/message-id/flat/20150203.174637.1316840640181577524.t-is...@sraoss.co.jp#20150203.174637.1316840640181577524.t-is...@sraoss.co.jp
#the
Hi:
I have a jsonb columne with json object like belo
{"a": 1, "b":2, "c":3}
I'd like to get subset of the object with key list ["a","c"]
so it retruns json object of
{"a": 1, "c":3}
something like
select '{"a": 1, "b":2, "c":3}'::jsob ->'["a","c"]'
what would be the most efficient (and simp
On 19/08/15 13:37, Tom Smith wrote:
> Hi:
>
> I have a jsonb columne with json object like belo
> {"a": 1, "b":2, "c":3}
>
> I'd like to get subset of the object with key list ["a","c"]
> so it retruns json object of
>
> {"a": 1, "c":3}
>
> something like
>
> select '{"a": 1, "b":2, "c":3}'::
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Sridhar N Bamandlapally
Sent: Tuesday, August 18, 2015 11:33 PM
To: PG-General Mailing List
Subject: [GENERAL] PostgreSQL customer list
Hi
I need some top 10 customers list in financial or health
Hello,
I have a master slave (read replica) setup running pg 9.4.4. I'm
trying to find the dead tuples out both the master and slave
Here's what it looks like on master:
# select relname ,n_live_tup ,n_dead_tup from pg_stat_user_tables;
relname | n_live_tup | n_dead_tup
---
thanks. I hope a new function can be added(with high perf C function) in
new release to allow something like
json_subset(jsonb_object, [key1,key2])
On Wed, Aug 19, 2015 at 9:46 AM, Chris Mair wrote:
> On 19/08/15 13:37, Tom Smith wrote:
> > Hi:
> >
> > I have a jsonb columne with json object
Hi, surely I will upgrade to 9.4.4! I already downloaded the rpms for the
update to postgres 9.4.4 but I thought not to update before getting through
this matter if update is not a prerequisite for the solution.
Answering to Tom's last post, I checked that Bugzilla 3.2 (an old installation
of B
On Wed, 19 Aug 2015 09:03:06 +0530
Sridhar N Bamandlapally wrote:
> We need to showcase to our customer for building analytical database
>
The activity on this list is a pretty good indicator of the popularity of
Postgresql.
You might want to show them this :
http://www.postgresql.org/messa
Hello,
Is preparing a statement using PQexec and executing it is much slower that
using other API such as PQprepare and PQexecPrepared?
Best regards,
Mark
--
View this message in context:
http://postgresql.nabble.com/Preparing-statement-using-PQexec-vs-PQprepare-tp5862628.html
Sent from the P
On Tue, Aug 18, 2015 at 9:33 PM, Sridhar N Bamandlapally
wrote:
> Hi
>
> I need some top 10 customers list in financial or healthcare domain (
> irrespective of open-source or proprietary tool )
>
> We need to showcase to our customer for building analytical database
>
> Please do share, it will b
On Thu, Aug 20, 2015 at 12:55 AM, Karthik Viswanathan
wrote:
> Hello,
>
> I have a master slave (read replica) setup running pg 9.4.4. I'm
> trying to find the dead tuples out both the master and slave
>
> Here's what it looks like on master:
>
> # select relname ,n_live_tup ,n_dead_tup from pg_st
On 08/19/2015 06:56 PM, Scott Marlowe wrote:
hard to say "here are our top 10 users" when we don't really know who
the biggest users are. For all we know the Fortune 50 could be all
heavily using it and we'd never know unless someone there spoke up and
told us.
They are, extensively.
Joshua D
16 matches
Mail list logo
