sathiya psql schrieb:
> can some body give me ideas on what to do for confirming what is the issue for
> consuming much time for the query execution ?
Run
EXPLAIN ANALYSE on both machines and compare the output or
show the output here.
Andreas
--
Really, I'm not out to destroy Microsoft. Th
Hi,
I have a 8 GB database, and 2 GB table. In a query i use the 2 GB table and
several other tables where it takes around 90 minutes for execution.
In different places, it takes drastically different time. Say everywhere i
have the same,
OS - Debian.
Primary memory - 3 GB
PostgreSQL configuratio