Personally this is my graal: https://www.phoronix.com/scan.php?pa...JIT-PostgreSQL
Announcement
Collapse
No announcement yet.
Benchmarks: PostgreSQL 10 Performance Is Looking Good
Collapse
X
-
Originally posted by uid313 View PostHave anyone here used the JSON functionality in Postgres?
Is it useful? Is it awesome? Do you love it? Or is it cumbersome, and boring?
Originally posted by alpha_one_x86 View PostPersonally this is my graal: https://www.phoronix.com/scan.php?pa...JIT-PostgreSQL
Comment
-
Originally posted by uid313 View PostHave anyone here used the JSON functionality in Postgres?
Is it useful? Is it awesome? Do you love it? Or is it cumbersome, and boring?
Code:{ "name": "andrei", "devices": [ {"kind":"laptop", "kernel":"linux", "name":"lenovo XYZ"}, {"kind":"smartphone","kernel":"linux", "name":"lg XYZ"} ] }
Code:select b.value from table a, jsonb_array_elements(a.column ->'devices') where column ->> 'name' = 'andrei'
Code:select * from table where column @> '{"devices":[{"kind":"laptop"}]}'
Last edited by andrei_me; 21 May 2017, 10:33 AM.
Comment
-
Originally posted by Michael View Post
If only I had one of those....
- GilboaoVirt-HV1: Intel S2600C0, 2xE5-2658V2, 128GB, 8x2TB, 4x480GB SSD, GTX1080 (to-VM), Dell U3219Q, U2415, U2412M.
oVirt-HV2: Intel S2400GP2, 2xE5-2448L, 120GB, 8x2TB, 4x480GB SSD, GTX730 (to-VM).
oVirt-HV3: Gigabyte B85M-HD3, E3-1245V3, 32GB, 4x1TB, 2x480GB SSD, GTX980 (to-VM).
Devel-2: Asus H110M-K, i5-6500, 16GB, 3x1TB + 128GB-SSD, F33.
Comment
Comment