Greg Sikorski writes:
> How come this Index isn't being used in the situation below?
There's no point in using an index if you're retrieving nearly the entire
table.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if pos
How come this Index isn't being used in the situation below? :) The field
is an epoch timestamp, and for various reasons it can't be a postgres
date/time type ;)
It does use the index with a direct = comparison.
Cheers, Greg
--
cmaster=# explain analyze SELECT user_id,channel_id FROM levels WH
> PGSTAT tries to bind to 127.0.0.1 to create a loopback UDP path for
> passing statistics data. Not clear why this would fail unless you
> have some network filtering software in there to prevent it. Without
> more info about your platform, network config, etc, there's little
> more I can say..
> PGSTAT tries to bind to 127.0.0.1 to create a loopback UDP path for
> passing statistics data. Not clear why this would fail unless you
> have some network filtering software in there to prevent it. Without
> more info about your platform, network config, etc, there's little
> more I can say..
Derek Neighbors <[EMAIL PROTECTED]> writes:
> PGSTAT: bind(2): Cannot assign requested address
> Failed to start the postmaster
PGSTAT tries to bind to 127.0.0.1 to create a loopback UDP path for
passing statistics data. Not clear why this would fail unless you
have some network filtering softwa
Been running Postgres on many platforms for sometime and never had much issue starting
it. I recently installed on a machine and get the following when trying to start it.
I searched the lists and google and didnt find much useful information.
PGSTAT: bind(2): Cannot assign requested address
The version of postgresql you are running does not have the postgresql.conf
file. If you were on postresql 7.1 or 7.2, you would have them regardless of
your OS. For your version, you'll have to use the command-line switches.
Look here for information on them:
http://www.postgresql.org/idocs/inde
Thanks a lot!
Although I wasn't clear enough in my questions I got pretty informative
answers.
Now I see, that I need faster hardware or to rethink the whole problem,
which is somewhat cheaper and much more interesting.
Thanks again for your answers.
Nicholay
---(end
On 29-Mar-2002 Bruce Momjian wrote:
>
> That file is not for user changes. It gets written on every postmaster
> restart. Either change these in postgresql.conf or on the command line.
>
The "postgresql.conf" file doesn't exist in RedHat. :(
But "/var/lib/pgsql/data/pg_options" file exists. I