Postgres 8.1.4 + PHP, hangs when querying more than 16 records!

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';

$result = pg_query($query) or die('Query failed: ' . pg_last_error());

// Printing results in HTML
echo "<table>\n";
while ($line = pg_fetch_array($result, null, PGSQL_ASSOC)) {
echo "\t<tr>\n";
foreach ($line as $col_value) {
echo "\t\t<td>$col_value</td>\n";
}
echo "\t</tr>\n";
}
echo "</table>\n";

// Free resultset
pg_free_result($result);

// Closing connection
pg_close($dbconn);
?>
------------------------------------------------------------ ---------------------
This script hangs:

------------------------------------------------------------ -----------------------
<?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 17';

$result = pg_query($query) or die('Query failed: ' . pg_last_error());

// Printing results in HTML
echo "<table>\n";
while ($line = pg_fetch_array($result, null, PGSQL_ASSOC)) {
echo "\t<tr>\n";
foreach ($line as $col_value) {
echo "\t\t<td>$col_value</td>\n";
}
echo "\t</tr>\n";
}
echo "</table>\n";

// Free resultset
pg_free_result($result);

// Closing connection
pg_close($dbconn);
?>
------------------------------------------------------------ -------------------------

The only difference is that in the first we limit to 16 records, in the latter, to 17 (and greater hangs as well). I tried with three different versions of PHP, as mentioned above (PHP 5.1.4, 5.1.6, & 4.4.4) from both Apache and from the command line. Attempted few times each when compiled versions and binary distributions via yum. All behave the same way. All hang above 17 records.

Take care! Babak.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

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 2: Don't 'kill -9' the postmaster

Hi Chris, Run through the native client everything works fine. I know, its really strange. Any ideas?

----- Original Message ----
From: Chris <dmagick [at] gmail.com>
To: babak badaei <badaei [at] yahoo.com>
Cc: pgsql-php [at] 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

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,

Gavin

On 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 [at] gmail.com>
> To: babak badaei <badaei [at] yahoo.com>
> Cc: pgsql-php [at] 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

Hi Gavid, Thanks, no I have not tried PDO but I have compiled 3 different versions of PHP from source with similar results as the 3 different versions from binary distribution. Same for Postgres (compiled from source and dropped-in binary stuff) for two different versions.

Thanks again! Babak.

----- Original Message ----
From: Gavin M. Roy <gmr [at] ehpg.net>
To: babak badaei <badaei [at] yahoo.com>
Cc: pgsql-php [at] postgresql.org
Sent: Thursday, August 31, 2006 8:55:01 AM
Subject: 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,

Gavin

On 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 [at] gmail.com>
> To: babak badaei <badaei [at] yahoo.com>
> Cc: pgsql-php [at] 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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo [at] postgresql.org so that your
message can get through to the mailing list cleanly

--0-198202980-1157041749=:97134
Content-Type: text/plain; charset=us-ascii

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 [at] ehpg.net>
To: babak badaei <badaei [at] yahoo.com>
Cc: pgsql-php [at] postgresql.org
Sent: Thursday, August 31, 2006 8:55:01 AM
Subject: 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,

Gavin

On 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 [at] gmail.com>
> To: babak badaei <badaei [at] yahoo.com>
> Cc: pgsql-php [at] 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

--0-198202980-1157041749=:97134
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:12pt"><div style="font-family: arial,helvetica,sans-serif; font-size: 12pt;">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. <div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">----- Original Message ---- From: Gavin M. Roy <gmr [at] ehpg.net> To: babak badaei <badaei [at] yahoo.com> Cc: pgsql-php [at] postgresql.org Sent: Thursday, August 31, 2006 8:55:01 AM Subject: Re: [PHP] Postgres 8.1.4 + PHP, hangs when querying more than 16 records! <div>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, Gavin On 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 [at] gmail.com> > To: babak badaei <badaei [at] yahoo.com> > Cc: pgsql-php [at] 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? > > -- > Po
stgresql & php tutorials > <a target="_blank"
href="http://www.designmagick.com/">http://www.designmagick. com/</a> > > > > > ---------------------------(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 </div></div> </div></div></body></html>
--0-198202980-1157041749=:97134--

--Apple-Mail-3-504461470
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
charset=US-ASCII;
delsp=yes;
format=flowed

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 [at] ehpg.net>
> To: babak badaei <badaei [at] yahoo.com>
> Cc: pgsql-php [at] postgresql.org
> Sent: Thursday, August 31, 2006 8:55:01 AM
> Subject: 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,
>
> Gavin
>
>
> On 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 [at] gmail.com>
> > To: babak badaei <badaei [at] yahoo.com>
> > Cc: pgsql-php [at] 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
>
>

--Apple-Mail-3-504461470
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
charset=ISO-8859-1

<HTML><BODY style=3D"word-wrap: break-word; -khtml-nbsp-mode: space; =
-khtml-line-break: after-white-space; ">Wow I'd say that something is =
terribly wrong with your machine, or it's install of pgsql, other than =
running fedora ;-).=A0 Out of curiosity what's the row size?=A0 how many =
fields and what's the schema look like?<DIV> </DIV><DIV> </DIV><DIV> </DIV><DIV> <DIV><DIV>On Aug 31, =
2006, at 9:29 AM, babak badaei wrote:</DIV> <BLOCKQUOTE type=3D"cite"><SPAN =
class=3D"Apple-style-span" style=3D"border-collapse: separate; =
border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; =
font-size: 12px; font-style: normal; font-variant: normal; font-weight: =
normal; letter-spacing: normal; line-height: normal; text-align: auto; =
-khtml-text-decorations-in-effect: none; text-indent: 0px; =
-apple-text-size-adjust: auto; text-transform: none; orphans: 2; =
white-space: normal; widows: 2; word-spacing: 0px; "><DIV =
style=3D"font-family:arial, helvetica, sans-serif;font-size:12pt; =
font-family: arial; font-size: 16px; "><DIV style=3D"font-family: =
arial,helvetica,sans-serif; font-size: 12pt;; font-family: arial; =
font-size: 16px; ">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. <DIV style=3D"font-family: times new roman,new york,times,serif; =
font-size: 12pt;; font-family: times new roman; font-size: 16px; ">----- Original Message ---- From: Gavin M. Roy <<A =
href=3D"mailto:gmr [at] ehpg.net">gmr [at] ehpg.net</A>> To: babak badaei <<A =
href=3D"mailto:badaei [at] yahoo.com">badaei [at] yahoo.com</A>> Cc: <A =
href=3D"mailto:pgsql-php [at] postgresql.org">pgsql-php [at] postgresq l.org</A></SPA=
N> Sent: Thursday, August 31, 2006 8:55:01 AM Subject: Re: [PHP] Postgres 8.1.4 + PHP, hangs when =
querying more than 16 records! <DIV style=3D"font-family: times new roman; =
font-size: 16px; ">Have you tried with pdo? $pdo =3D new =
PDO('pgsql:host=3Dlocalhost;dbname=3Ddatabase','web'); $query =3D $pdo->query('SELECT * FROM =
foobar;'); $query->execute(); $data =3D =
$query->fetchAll(PDO::FETCH_OBJ); print_r($data); And have you tried not using other peoples =
packages but downloading=A0=A0 the source and =
compiling it?=A0=A0I run PHP 5.1.4 and work with very=A0=A0 large data sets, though I've not upgraded to 5.1.6 =
yet. Hope this helps, Gavin On Aug 31, 2006, at 12:42 AM, babak badaei =
wrote: > Hi Chris, Run through the native client =
everything works fine. I=A0=A0 > know, its =
really strange. Any ideas? > > ----- Original Message ---- > From: Chris <<A =
href=3D"mailto:dmagick [at] gmail.com">dmagick [at] gmail.com</A>> > To: babak badaei <<A =
href=3D"mailto:badaei [at] yahoo.com">badaei [at] yahoo.com</A>> > Cc: <A =
href=3D"mailto:pgsql-php [at] postgresql.org">pgsql-php [at] postgresq l.org</A></SPA=
N> > Sent: Wednesday, August 30, 2006 11:42:01 =
PM > Subject: Re: [PHP] Postgres 8.1.4 + PHP, =
hangs when querying more=A0=A0 > than 16 =
records! > > babak =
badaei wrote: >> OS: Fedora Core 5 >> PHP: PHP 5.1.4, PHP 5.1.6, and=A0=A0PHP =
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 =3D pg_connect("host=3Dlocalhost dbname=3Ddatabase =
user=3Dweb") >>=A0=A0=A0=A0or die('Could not connect: =
' . pg_last_error()); >> >> // Performing SQL query >> $query =3D 'SELECT * FROM foobar limit =
16'; > > =
<snip> > >>=A0=A0//=
Performing SQL query >>=A0=A0$query =3D 'SELECT * =
FROM foobar limit 17'; > > That =
seems really weird. > > If you =
run those through psql natively what happens? > > -- > Postgresql & php tutorials > <A target=3D"_blank" =
href=3D"http://www.designmagick.com/">http://www.designmagick.com/</A> > > > > > ---------------------------(end of=A0=A0<BR=
style=3D"font-family: times new roman; font-size: 16px; ">> 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 =A0=A0=A0=A0=A0=A0 choose an index scan if your =
joining column's datatypes do not =A0=A0=A0=A0=A0=A0=
match </DIV></DIV> </DIV></DIV> </BLOCKQUOTE></DIV> </DIV></=
BODY></HTML>=

--Apple-Mail-3-504461470--

--0-1526541721-1157054879=:30221
Content-Type: text/plain; charset=us-ascii

Yeah, I just dumped the box completely. It was too frustrating. I'm starting over with FreeBSD this time on new hardware.

Thanks for your help and suggestions!

----- Original Message ----
From: Gavin M. Roy <gmr [at] ehpg.net>
To: babak badaei <badaei [at] yahoo.com>
Cc: pgsql-php [at] postgresql.org
Sent: Thursday, August 31, 2006 12:33:24 PM
Subject: Re: [PHP] Postgres 8.1.4 + PHP, hangs when querying more than 16 records!

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 [at] ehpg.net>
To: babak badaei <badaei [at] yahoo.com>
Cc: pgsql-php [at] postgresql.org
Sent: Thursday, August 31, 2006 8:55:01 AM
Subject: 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,

Gavin

On 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 [at] gmail.com>
> To: babak badaei <badaei [at] yahoo.com>
> Cc: pgsql-php [at] 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

--0-1526541721-1157054879=:30221
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:12pt"><div style="font-family: arial,helvetica,sans-serif; font-size: 12pt;">Yeah, I just dumped the box completely. It was too frustrating. I'm starting over with FreeBSD this time on new hardware. Thanks for your help and suggestions! <div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">----- Original Message ---- From: Gavin M. Roy <gmr [at] ehpg.net> To: babak badaei <badaei [at] yahoo.com> Cc: pgsql-php [at] postgresql.org Sent: Thursday, August 31, 2006 12:33:24 PM Subject: Re: [PHP] Postgres 8.1.4 + PHP, hangs when querying more than 16 records! Wow I'd say that something is terribly wrong with your machine, or it's install of pgsql, other than running fedora ;-). Out of c
uriosity what's the row size? how many fields and what's the schema look
like?<div> </div><div> </div><div> </div><div> <div><div>On Aug 31, 2006, at 9:29 AM, babak badaei wrote:</div> <blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px;"><div style="font-family: arial; font-size: 16px;"><div style="font-family: arial; font-size: 16px;">Hello again; I just finished trying the method below with the same results. 16 rec
ords work, more than that it hangs!! Thanks for your help. Babak. <div style="font-family: times new roman; font-size: 16px;">----- Original Message ---- From: Gavin M. Roy <<a id="bodyLinks" rel="nofollow" target="_blank" href="mailto:gmr [at] ehpg.net">gmr [at] ehpg.net</a>> To: babak badaei <<a id="bodyLinks" rel="nofollow" target="_blank" href="mailto:badaei [at] yahoo.com">badaei [at] yahoo.com</a>> Cc: <a
id="bodyLinks" rel="nofollow" target="_blank" href="mailto:pgsql-php [at] postgresql.org">pgsql-php [at] postgresql. org</a> Sent: Thursday, August 31, 2006 8:55:01 AM Subject: Re: [PHP] Postgres 8.1.4 + PHP, hangs when querying more than 16 records! <div style="font-family: times new roman; font-size: 16px;">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, Gavin On 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 <<a id="bodyLinks" rel="nofollow" target="_blank" href="mailto:dmagick [at] gmail.com">dmagick [at] gmail.com</a>> > To: babak badaei <<a id="bodyLinks" rel="nofollow" target="_blank" href="mailto:badaei [at] yahoo.com">badaei [at] yahoo.com</a>> > Cc: <a id="bodyLinks"
rel="nofollow" target="_blank" href="mailto:pgsql-php [at] postgresql.org">pgsql-php [at] postgresql. org</a> > 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 > <a id="bodyLinks" rel="nofollow" target="_blank" href="http://www.designmagick.com/">http://www.designmagick.com/</a> > > > > > ---------------------------(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 </div></div> </div></div> </blockquote></div> </div></div> </div></div></body></html>
--0-1526541721-1157054879=:30221--

Postgres 8.1.4 + PHP, hangs when querying more than 16 records!

Re: Postgres 8.1.4 + PHP, hangs when querying more than 16

Re: Postgres 8.1.4 + PHP, hangs when querying more than 16 records!

Re: Postgres 8.1.4 + PHP, hangs when querying more than 16 records!

Re: Postgres 8.1.4 + PHP, hangs when querying more than 16 records!

Re: Postgres 8.1.4 + PHP, hangs when querying more than 16 records!

Re: Postgres 8.1.4 + PHP, hangs when querying more than 16 records!

Re: Postgres 8.1.4 + PHP, hangs when querying more than 16 records!