Hello !
I use POSTGRES 6.4...
Everuthing was working ok for months, but since 3 days, I have sometimes
when my PHP scrits try to connect :
Warning: Unable to connect to PostgresSQL server: connectDB():
getprotobyname failed in /opt/htdocs/html/php/atos_lib.phtml on line 3
Have you any idea ??
At 00:14 21/12/00 -0800, R D wrote:
>Hi,
>I have some problems with postgresql 7.0.3 running on
>Slackware linux 7.1.
>
>I have a table with about 25 milion records:
>
>create table gsc_act(reg_id int2,id int2,ra int4, de
>int4,mag int2);
>
>i created 2 indexes:
>
>create index gsc_act_de on gsc_act(de);
>create index gsc_act_rd on gsc_act(de,ra);
>
>so every thing was ok with queries:
>1. select * from gsc_act where de>=-300000
> and de<300000 and ra<=600000 and ra>=0;
>2. select * from gsc_act where de>=-300000
> and de<300000 and ra<=600000 and ra>=0
> and mag<300;
>
>except the second one was too slow and I created third
>index:
>
>create index gsc_act_rdm on gsc_act(de,ra,mag);
>
>I executed query 2 and it hang for 5-6 min with
>permanent disk activity even Ctrl-C could not stop it.
>I killed postmaster and droped the third index. Now
>both queries hang the same way. Is there any way to
>fix it? This are the most used queries with the
>table(only the values are different).
>Is this some bug in postgres?
>Please help!
>
>Rumen
>
>__________________________________________________
>Do You Yahoo!?
>Yahoo! Shopping - Thousands of Stores. Millions of Products.
>http://shopping.yahoo.com/
----------------------------------------------------------------
Le simple fait de passer par la fenetre ne suffit pas a la transformer en porte.
