Wow I'd say that something is terribly wrong with your machine, or it's install of pgsql, other than running fedora ;-). Out of curiosity what's the row size? how many fields and what's the schema look like?
On Aug 31, 2006, at 9:29 AM, babak badaei wrote:
Hello again; I just finished trying the method below with the same results. 16 records work, more than that it hangs!! Thanks for your help. Babak.----- Original Message ----From: Gavin M. Roy <gmr@ehpg.net>To: babak badaei <badaei@yahoo.com>Cc: pgsql-php@postgresql.orgSent: Thursday, August 31, 2006 8:55:01 AMSubject: Re: [PHP] Postgres 8.1.4 + PHP, hangs when querying more than 16 records!Have you tried with pdo?$pdo = new PDO('pgsql:host=localhost;dbname=database','web');$query = $pdo->query('SELECT * FROM foobar;');$query->execute();$data = $query->fetchAll(PDO::FETCH_OBJ);print_r($data);And have you tried not using other peoples packages but downloading the source and compiling it? I run PHP 5.1.4 and work with very large data sets, though I've not upgraded to 5.1.6 yet.Hope this helps,GavinOn Aug 31, 2006, at 12:42 AM, babak badaei wrote:> Hi Chris, Run through the native client everything works fine. I > know, its really strange. Any ideas?>> ----- Original Message ----> From: Chris <dmagick@gmail.com>> To: babak badaei <badaei@yahoo.com>> Cc: pgsql-php@postgresql.org> Sent: Wednesday, August 30, 2006 11:42:01 PM> Subject: Re: [PHP] Postgres 8.1.4 + PHP, hangs when querying more > than 16 records!>> babak badaei wrote:>> OS: Fedora Core 5>> PHP: PHP 5.1.4, PHP 5.1.6, and PHP 4.4.4 (compiled with --with- >> pgsql and install as binaries using YUM)>> Postgres 8.1.4>>>> This scripts works:>> --------------------------------------------------------------------- >> ------------>> <?php>> // Connecting, selecting database>> $dbconn = pg_connect("host=localhost dbname=database user=web")>> or die('Could not connect: ' . pg_last_error());>>>> // Performing SQL query>> $query = 'SELECT * FROM foobar limit 16';>> <snip>>>> // Performing SQL query>> $query = 'SELECT * FROM foobar limit 17';>> That seems really weird.>> If you run those through psql natively what happens?>> -- > Postgresql & php tutorials> http://www.designmagick.com/>>>>> ---------------------------(end of > broadcast)---------------------------> TIP 6: explain analyze is your friend---------------------------(end of broadcast)---------------------------TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match