Hello mailing list!
We have a JSONB column in a table that has a key (string) => value (int)
structure. We want to be able to create a btree index that accepts an
arbitrary key to allowing sorting by key.
Table Example:
> ++--+
> | ID |
Hi all,If anyone still interested in the issue I think I have a very plausible explanation of Eric’s postgresql bad index choice that is: bloated updates_driver_id_time_idx index.Though it’s possible to fool postgresql planner, as I’ve shown in previous tests, this happens with a very concrete data
On 12/13/2016 12:16 PM, ProPAAS DBA wrote:
Hi All;
I'm not a VMware expert, however I thought VMware would allow the
creation of multiple disk volumes and attach them via separate mount
points. Is this not true? If it is an option can someone point me to a
how to...
Yes it is possible to do
Hi All;
We have a client running on VMware, they have heavy write traffic and we
want to isolate the IO for the tx logs (pg_xlog). However it seems the
best plan based on feedback from the client is either
(a) simply leave the pg_xlog dir in the VMDK
or
(b) relocate pg_xlog to NAS/NFS
I'
