Answer is pretty clear, thank you David.
On Mon, Aug 16, 2021 at 12:31 AM David Rowley wrote:
> On Sun, 15 Aug 2021 at 23:41, otar shavadze wrote:
> > SELECT
> > (SELECT relpages FROM pg_class where oid =
> 'public.my_table'::regclass::oid ) AS table_pages_quant
created pg_buffercache extension:
CREATE EXTENSION pg_buffercache;
restarted server and updated statistic for table :
VACUUM ANALYZE public.my_table;
then just tried to cache table in buffer:
SELECT * FROM public.my_table;
and then tried to get table total page quantity and how much pages are
ca
Great, thanks very much Andrew!
On Sun, May 10, 2020 at 7:08 PM Andrew Dunstan <
andrew.duns...@2ndquadrant.com> wrote:
>
> On 5/10/20 8:21 AM, otar shavadze wrote:
> > When I want t to convert json array into postgres array, I do:
> >
> > with t(j) as(
> &
When I want t to convert json array into postgres array, I do:
with t(j) as(
> select '{"my_arr":[3,1,2]}'::json
> )
> SELECT ARRAY(SELECT json_array_elements_text(j->'my_arr')) from t
It works like a charm and I never noticed any problem, but I'm asking here
just to make sure, order of ele
