In a PostgreSQL 14 database I have a transactions table currently containing around 400 million elements and the following query on it: SELECT "transactions"."id" FROM "transactions" WHERE ("wallet_id" = $1) ORDER BY "transactions"."id" DESC LIMIT 10 This works fine and…
How Varlena objects provide flexibility in handling data with variable lengths in postgres while minimizing storage overhead? I read about the varlena objects in postgres but not able to understand the concept behind the varlena objects.
I am currently working with Apache AGE for graph data management and I'm executing a set of queries using AGE-Viewer-GO. What I want to do now is measure the execution time of this (and other) queries. Is there a built-in…
My function to query account by email: CREATE FUNCTION get_account_by_email(account_email varchar(64)) RETURNS account AS $$ SELECT id, name, email FROM account WHERE account.email = account_email; $$ LANGUAGE SQL; My python code to call the function ("psycopg[binary]"==3.1.9): async def get_account_by_email(self, email:…
I am trying to run Postgres SQL on a AWS t2 micro server. I have seen the documentation about changing the config files and opening up 0.0.0.0/32 and ::/0. I have done all of that and still can not connect…
I am trying to run databes on Docker container and connect it with my code. This is my connection string: engine = create_engine('postgres+psycopg2://name:password@hostname:port/database_name') As host_name I use IP address of my Linux where I installed docker container. I also checked…
I have a couple of tables in PostgreSQL 14.6, with indexes as stated here: # d uprn Table "public.uprn" Column | Type | Collation | Nullable | Default -----------+----------------------+-----------+----------+--------- uprn | text | | | postcode | text | |…
please help me to make a query.I need the total of 3 counted columns in one query as a result, here is my option: select region, count(s_code), count(b_code), count(d_code), sum(count(s_code, b_code, d_code)) as total from shilpy group by region order…
I am trying to create a graph using Apache AGE Viewer, but when I enter a name for the graph and click "Done", I receive the following error message: subunit An error occurred Error Code: undefined Error Details: TypeError: Cannot…
I have written a function for Apache AGE to create a specific kind of graph where the creation of edges is based on a probability, which is one argument of the function. The problem is that, when calling PG_GETARG_FLOAT4 it…