RE: [GENERAL] slow queries - Mailing list pgsql-general

From Jackson, DeJuan
Subject RE: [GENERAL] slow queries
Date
Msg-id F10BB1FAF801D111829B0060971D839F42BF63@cpsmail
Whole thread Raw
Responses Is there a server log????
RE: [GENERAL] slow queries
List 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

pgsql-general by date:

Previous
From: "Michael Ansley"
Date:
Subject: Win32 libpq libraries
Next
From: Jeremy Hansen
Date:
Subject: Is there a server log????