Why would the following query take soo long to run? What does 28.12 msec represent, since the total running time is
16801.86 ms.
The table phoneinfo has a primary key called phoneinfo_id and the table has 400 000 records.
mydb=#explain analyze delete from phoneinfo where phoneinfo_id = 85723;
[EMAIL PROTECTED] wrote:
On Fri, 2003-06-20 at 15:53, Yusuf wrote:
Why would the following query take soo long to run? What does 28.12 msec represent, since the total running time is
16801.86 ms.
I'd hazard to guess that you have a whole slew of foreign keys cascading
to delete, updat
For the application that I'm working on, we want to
use data types that are database independent. (most
databases has decimal, but not big int).
Anyhow, we are planning on using decimal(19,0) for our
primary keys instead of a big int, would there be a
performance difference in using a bigint over
to make in order to prove it?
Thanks in advance.
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> "Yusuf W." <[EMAIL PROTECTED]> writes:
> > For the application that I'm working on, we want
> to
> > use data types that are database independent.
> (m
