#31393 [Asn]: pg_field_type inner query slows down scripts
ID: 31393
User updated by: mauroi at digbang dot com
Reported By: mauroi at digbang dot com
Status: Assigned
Bug Type: PostgreSQL related
PHP Version: Irrelevant
Assigned To: yohgaki
New Comment:
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....
Previous Comments:
------------------------------------------------------------------------
[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)
------------------------------------------------------------------------
[2005-01-03 22:07:18] mauroi at digbang dot com
I can send the patch with the new function (tested on PHP-5.0.3) in
case you need it. Just tell me where.
Thanks in advance.
------------------------------------------------------------------------
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)