RE: [GENERAL] slow queries

From: "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com>
To: Howie <caffeine(at)toodarkpark(dot)org>, Thomas Good <tomg(at)admin(dot)nrnet(dot)org>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: RE: [GENERAL] slow queries
Date: 1998-09-25 15:27:54
Message-ID: F10BB1FAF801D111829B0060971D839F42BF63@cpsmail
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> seems that by creating a view ( with the query i mentioned before ),
> my
> queries were sped up by roughly 10 seconds... odd odd odd.
>
Not really so odd when you think of everything the backend has to do to
process a query. Parsing, planning, and optimizing (not necessarily in
that order) can be very costly. A view basically skips most of those
three steps.
-DEJ

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeremy Hansen 1998-09-26 18:47:22 Is there a server log????
Previous Message Michael Ansley 1998-09-25 11:28:11 Win32 libpq libraries