-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 02/02/07 07:22, Richard Huxton wrote: > Peter wrote: >> >> Query returned successfully with no result in 600 ms. >> >> Why SELECT takes 3+ second to execute? Is it something to do with my >> Postgres server optimization, or PgAdmin does not show correct data >> retrieval runtime (leaks over into query runtime or something)? > > Data transfer and display time usually. > > Try SELECT count(*) FROM ... instead and see if the times are closer. Or pipe the output to a file. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFFw0ajS9HxQb37XmcRAuTNAJ9taelU4v8ZDwhRmsUohVwyA7S3jgCffzcq gMLAtTaROOeElC27rCGr58s= =K4wO -----END PGP SIGNATURE-----
