Re: postgres slower on nested queries

On Wed, Mar 07, 2007 at 12:12:52PM +0100, Alexander Elgert wrote:
> >Nope - \d is psql only. That's because what it does changes with the
> >system catalogues. If you want a stable representation, use the
> >information_schema. If you want all the PostgreSQL-specific details
> >you'll have to cope with changes to the system catalogues. However, I
> >seem to remember some utility views that pgadmin uses that might be of
> >use.
> It would be nice to have the \d-query stored somewhere in the database.

Not really useful anyway. For the kind of trivial stuff you're doing
the queries will work for many many versions. Your real problem is that
you're using the information_schema which has to do all sorts of extra
work for standards compliance. If you don't need that you're going to
be much better off just using the system catalogs.

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.