#31393 [Asn->Csd]: pg_field_type inner query slows down scripts

From: Date: Mon, 14 Feb 2005 23:38:04 +0000
Subject: #31393 [Asn->Csd]: pg_field_type inner query slows down scripts
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-74059@lists.php.net to get a copy of this message 
 ID:          31393
 Updated by:  edink@php.net
 Reported By: mauroi at digbang dot com
-Status:      Assigned
+Status:      Closed
 Bug Type:    PostgreSQL related
 PHP Version: Irrelevant
 Assigned To: yohgaki
 New Comment:

The function is added to the current development branch and it will be
a part of PHP 5.1.0 release.

Thank you for the addition of this very useful function.


Previous Comments:
------------------------------------------------------------------------

[2005-01-12 13:59:38] mauroi at digbang dot com

The database is very big (lots of schemas). I couldn't find a way to
make that query faster. Of course, I make a regular vaccum full, but I
don't get better results with this particular query. 
I don't think there's another use for this function (in fact, it can be
used in the same situations where you use pg_field_type).
Thanks in advance....

------------------------------------------------------------------------

[2005-01-12 07:17:03] yohgaki at ohgaki dot net

Although, it seems 500 ms execution time for the query is too long.
(Try vaccumedb -f , if you haven't done yet) The patch itself seems
good. Question is getting OID of data type is good for anything else.

------------------------------------------------------------------------

[2005-01-03 22:39:59] derick@php.net

Assigning to the maintainer.

------------------------------------------------------------------------

[2005-01-03 22:18:54] mauroi at digbang dot com

http://webmail.digbang.com/patch_type_oid.diff
Thanks in advance

------------------------------------------------------------------------

[2005-01-03 22:14:35] derick@php.net

Can you provide a patch of this in unified diff format? (External
please, and provide a link)

------------------------------------------------------------------------

The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
    http://bugs.php.net/31393

-- 
Edit this bug report at http://bugs.php.net/?id=31393&edit=1

Thread (8 messages)

« previous php.bugs (#74059) next »