Re: Why is my query 3 times faster on my workstation than on my server?

2025-12-04 Thread Vincent Veyron
On Thu, 04 Dec 2025 14:06:40 -0500 Tom Lane wrote: Hi Tom, > > Yeah. Check out the ratings at > > https://browser.geekbench.com > I guess these ratings will come handy to help pick my next server, thank you. >They seem to think the i5-5300U is a 2-core device, maybe you are counting >hype

Why is my query 3 times faster on my workstation than on my server?

2025-12-04 Thread Vincent Veyron
lient, fiscal_year, libelle_section) ON UPDATE CASCADE "tbljournal_client_year_numero_compte_fk" FOREIGN KEY (id_client, fiscal_year, numero_compte) REFERENCES tblcompte(id_client, fiscal_year, numero_compte) ON UPDATE CASCADE "tbljournal_id_client_fkey" FOREIGN KEY (id_client) REFERENCES compta_client(id_client) "tbljournal_id_export_fk" FOREIGN KEY (id_export) REFERENCES tblexport(id_export) ON UPDATE CASCADE Triggers: check_month_is_archived BEFORE INSERT OR DELETE ON tbljournal FOR EACH ROW EXECUTE FUNCTION tbljournal_check_month_is_archived() -- Bien à vous, Vincent Veyron https://compta.libremen.com Logiciel libre de comptabilité générale et analytique en partie double