About PostgreSQL query optimisation.
I have database with few hundred millions of rows. I'm running the following query: select * from "Payments" as p inner …
performance postgresql postgresql-performanceAny ideas how to speed up this query? Input EXPLAIN SELECT entityid FROM entity e LEFT JOIN level1entity l1 …
performance postgresql postgresql-performanceI have the following table and indices defined: CREATE TABLE ticket ( wid bigint NOT NULL DEFAULT nextval('tickets_id_seq'::…
postgresql indexing query-optimization database-partitioning postgresql-performanceI have a table that has a datetime field "updated_at". A lot of my queries will be querying on …
sql performance postgresql postgresql-performanceI am using PostgreSQL and I have a weird problem with my SQL query. Depending on wich date paramter I'm …
sql postgresql postgresql-performanceUsing postgresql-9.2,at this moment am finding the tables that have dead_tuples using the following query select relname from …
sql postgresql postgresql-performance vacuumWe have a table which has just over 62k rows. We are running a very simple delete query on it …
postgresql foreign-keys sql-delete postgresql-performanceI have to optimize queries by tuning basic PostgreSQL server configuration parameters. In documentation I've came across the work_mem …
postgresql postgresql-performance server-configurationCREATE TABLE product ( product_id SERIAL, factory_key VARCHAR(60), relevant BOOLEAN ) Indexes: "product_factory_key_key" btree (factory_key); "product_…
postgresql indexing postgresql-performanceAccording to the PostgreSQL Documentation, they support 3 data-types for character data: character varying(n), varchar(n) variable-length with limit character(…
sql postgresql types postgresql-performance