Hi,
I am trying install the postgresql-7.4.3 simple
installation. I did ./configure command at the postgresql directory source.
While the configuring proccess I receiving the follow message:
checking for tar... /bin/tarchecking for
strip... stripchecking whether it is possible to strip li
Hello
I would like to know the performance of pg_fetch_array. Cosider the code:
$query = "select * from foo";
$result = pg_query( $db, $query );
while ($row = pg_fetch_array($result))
{
$a = $row["a"];
$b = $row["b"];
$c = $row["c"];
$d = $row["d"];
}
Does php need to read data
Hello all,
I have a rather large table (~20 GB) of network logs taken over the period
of a month and stored under postgres 7.3. I'm trying to create an indexing
scheme so that I can do a query with a "where time > foo and time < bar"
and get the results without too much waiting. With this in mind,
Title: Message
The words for the keyword can be made up of a
sentace, ie 10 or more keywords to one entry.
Also incase I didnt answer before, we are using
TSearch2 and all tables have been fully analyzed and indexed.
Any other suggestions?
How long do searches take when 10 000 rows are
return
Stan Bielski <[EMAIL PROTECTED]> writes:
> Table "public.allflow_tv_mydoom"
>Column | Type | Modifiers
> +-+---
> tv_s | bigint |
^^
> Indexes: allflow_tv_mydoom_x btree (tv_s)
> standb=# explain select * from allflow_tv_mydoom whe
> Does php need to read database everytime when pg_fetch_array is executed in
> the while loop or all the rows have been in the memory after pg_query?
You may need to ask the php people about this one. The PostgreSQL
protocol would allow data to continue streaming in at the same time as
you are pr