Skip site navigation (1) Skip section navigation (2)

Using Explain

From: "P(dot) Dwayne Miller" <dmiller(at)espgroup(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Using Explain
Date: 2001-07-05 15:22:05
Message-ID: 3B44861D.56FF53F5@espgroup.net (view raw or flat)
Thread:
Lists: pgsql-hackers
After porting a database from FoxPro to PostgreSQL, one of the basic
queries that is used throughout the application now takes ~ 4 secs to
run, where it took ~ 40 usecs to run in FoxPro.  I've been trying to use
EXPLAIN to give me optimization hints, but I'm not sure what I'm looking
at.  Any places to look that might explain the results of explain?

Tks


Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2001-07-05 16:05:49
Subject: Re: AW: Re: Backup and Recovery
Previous:From: VĂ­ctor RomeroDate: 2001-07-05 14:51:35
Subject: Pg on SMP half-powered

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group