pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Postgres 8.1.4 + PHP, hangs when querying more than 16 records!
9+ messages / 3 participants
[nested] [flat]

* Postgres 8.1.4 + PHP, hangs when querying more than 16 records!
@ 2006-08-31 06:25  babak badaei <badaei@yahoo.com>
  0 siblings, 1 reply; 9+ messages in thread

From: babak badaei @ 2006-08-31 06:25 UTC (permalink / raw)
  To: pgsql-php

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.







^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Postgres 8.1.4 + PHP, hangs when querying more than 16
@ 2006-08-31 06:42  Chris <dmagick@gmail.com>
  parent: babak badaei <badaei@yahoo.com>
  0 siblings, 1 reply; 9+ messages in thread

From: Chris @ 2006-08-31 06:42 UTC (permalink / raw)
  To: babak badaei <badaei@yahoo.com>; +Cc: pgsql-php

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/



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Postgres 8.1.4 + PHP, hangs when querying more than 16 records!
@ 2006-08-31 07:42  babak badaei <badaei@yahoo.com>
  parent: Chris <dmagick@gmail.com>
  0 siblings, 1 reply; 9+ messages in thread

From: babak badaei @ 2006-08-31 07:42 UTC (permalink / raw)
  To: Chris <dmagick@gmail.com>; +Cc: pgsql-php

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/






^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Fw: Postgres 8.1.4 + PHP, hangs when querying more than 16 records!
@ 2006-08-31 09:51  babak badaei <badaei@yahoo.com>
  0 siblings, 0 replies; 9+ messages in thread

From: babak badaei @ 2006-08-31 09:51 UTC (permalink / raw)
  To: pgsql-php

In addition to below; I compile postgres 7.4.12. Same thing!!! More than 16 records hangs!

----- Forwarded Message ----
From: babak badaei <badaei@yahoo.com>
To: pgsql-php@postgresql.org
Sent: Wednesday, August 30, 2006 11:25:58 PM
Subject: 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.












^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Postgres 8.1.4 + PHP, hangs when querying more than 16 records!
@ 2006-08-31 15:55  Gavin M. Roy <gmr@ehpg.net>
  parent: babak badaei <badaei@yahoo.com>
  0 siblings, 2 replies; 9+ messages in thread

From: Gavin M. Roy @ 2006-08-31 15:55 UTC (permalink / raw)
  To: babak badaei <badaei@yahoo.com>; +Cc: pgsql-php

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@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




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Postgres 8.1.4 + PHP, hangs when querying more than 16 records!
@ 2006-08-31 16:15  babak badaei <badaei@yahoo.com>
  parent: Gavin M. Roy <gmr@ehpg.net>
  1 sibling, 0 replies; 9+ messages in thread

From: babak badaei @ 2006-08-31 16:15 UTC (permalink / raw)
  To: Gavin M. Roy <gmr@ehpg.net>; +Cc: pgsql-php

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@ehpg.net>
To: babak badaei <badaei@yahoo.com>
Cc: pgsql-php@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@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








^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Postgres 8.1.4 + PHP, hangs when querying more than 16 records!
@ 2006-08-31 16:29  babak badaei <badaei@yahoo.com>
  parent: Gavin M. Roy <gmr@ehpg.net>
  1 sibling, 1 reply; 9+ messages in thread

From: babak badaei @ 2006-08-31 16:29 UTC (permalink / raw)
  To: Gavin M. Roy <gmr@ehpg.net>; +Cc: pgsql-php

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.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@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

^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Postgres 8.1.4 + PHP, hangs when querying more than 16 records!
@ 2006-08-31 19:33  Gavin M. Roy <gmr@ehpg.net>
  parent: babak badaei <badaei@yahoo.com>
  0 siblings, 1 reply; 9+ messages in thread

From: Gavin M. Roy @ 2006-08-31 19:33 UTC (permalink / raw)
  To: babak badaei <badaei@yahoo.com>; +Cc: pgsql-php

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.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@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
>
>

^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Postgres 8.1.4 + PHP, hangs when querying more than 16 records!
@ 2006-08-31 20:07  babak badaei <badaei@yahoo.com>
  parent: Gavin M. Roy <gmr@ehpg.net>
  0 siblings, 0 replies; 9+ messages in thread

From: babak badaei @ 2006-08-31 20:07 UTC (permalink / raw)
  To: Gavin M. Roy <gmr@ehpg.net>; +Cc: pgsql-php

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@ehpg.net>
To: babak badaei <badaei@yahoo.com>
Cc: pgsql-php@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@ehpg.net>
To: babak badaei <badaei@yahoo.com>
Cc: pgsql-php@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@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

^ permalink  raw  reply  [nested|flat] 9+ messages in thread


end of thread, other threads:[~2006-08-31 20:07 UTC | newest]

Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-08-31 06:25 Postgres 8.1.4 + PHP, hangs when querying more than 16 records! babak badaei <badaei@yahoo.com>
2006-08-31 06:42 ` Re: Postgres 8.1.4 + PHP, hangs when querying more than 16 Chris <dmagick@gmail.com>
2006-08-31 07:42   ` babak badaei <badaei@yahoo.com>
2006-08-31 15:55     ` Gavin M. Roy <gmr@ehpg.net>
2006-08-31 16:15       ` babak badaei <badaei@yahoo.com>
2006-08-31 16:29       ` babak badaei <badaei@yahoo.com>
2006-08-31 19:33         ` Gavin M. Roy <gmr@ehpg.net>
2006-08-31 20:07           ` babak badaei <badaei@yahoo.com>
2006-08-31 09:51 Fw: Postgres 8.1.4 + PHP, hangs when querying more than 16 records! babak badaei <badaei@yahoo.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox