On Mon, 2002-04-15 at 19:28, Tom Lane wrote:
> "Bojan Belovic" <[EMAIL PROTECTED]> writes:
> > Every once in a while I'll spot a query that is taking unusually long time
> > to run (a chiled process that keeps the processor at 100% for like 3
> > minutes). Is there a way to see the queries current
>[getting readline support ]
> - installed readline library
Did you install the header files ?
If you are installing a binary that is compiled to use the library,
the library is enough. If you are compiling from scratch, you need the
.h files as well.
On Debian potato the command is:
a
Charlie Toohey writes:
> I am trying to get command line history and editing to work with psql, as
> life is a pain without it.
Check that you have the readline header files installed (and if configure
finds them; readline.h, history.h or similar). Look for RPMs
readline-devel or some such.
--
Implicitely use the index.
explain SELECT d.bank_id, d.time_id, d.item_name, d.item_value FROM
mbz_rpt_item_val d WHERE d.bank_id IN (277,535,739,1234,1330) and d.time_id
IN ('P_6') and d.org_allow = 1 ORDER BY time_id,org_allow,bank_id ;
Actually, just the time_id might be enough, depending on
"Bojan Belovic" <[EMAIL PROTECTED]> writes:
> Every once in a while I'll spot a query that is taking unusually long time
> to run (a chiled process that keeps the processor at 100% for like 3
> minutes). Is there a way to see the queries currently executing
ps, top? Also see the stats views, if
Every once in a while I'll spot a query that is taking unusually long time
to run (a chiled process that keeps the processor at 100% for like 3
minutes). Is there a way to see the queries currently executing and/or kill
a single process without affecting the operation of the server (I'm not
sure,
On 15 Apr 2002 at 14:20, Nick Fankhauser wrote:
> As a general rule, a primary key (or any relationship key) should not
> contain a value that means something beyond its use in relating entities.
> The problem is that if a field describes an object, the day may come when
> you want to change the
Jodi:
This opinion has less to do with Postgres and more to do will a general
philosophy but we always use a 4 byte integer column as the primary key for
almost every table. None of the following reasons means it has to be that
way, but all support Ints over strings:
1) Strings would normally b
As a general rule, a primary key (or any relationship key) should not
contain a value that means something beyond its use in relating entities.
The problem is that if a field describes an object, the day may come when
you want to change the description, but you *never* want to change the field
th
Can anyone offer some insight as to what
should be considered when choosing between a primary key that is an integer vs.
a primary key that is a string value? Does one or the other affect indexing
speed? update speed?
Is a serial integer value better than using a
PK that has some "value" in
Friends,
A little more information:
I'm actually only having this problem with some tables that have triggers
on insert, update and delete. A table and the assocaited triggers/functions
shown below. I suspect that something changed in the triggers or functions
in 7.2, but I can'
Tony Griffiths <[EMAIL PROTECTED]> writes:
> I had assumed that there would be a single header file that sets the max
> name length, but it loos like the esql precompiler didn't pick up the
> amended max name length.
Did you remember to recompile ecpg? AFAICT it uses the same NAMEDATALEN
symbol
I am trying to get command line history and editing to work with psql, as
life is a pain without it.
I'm running PostgreSQL 7.1.3 on Linux.
Documenation on this subject is very archaic, but I have done the following
so far:
- installed readline library
- run ./configure with the following com
"Christian Gerdes" <[EMAIL PROTECTED]> writes:
> Is there an opportunity to configure postgre to keep databases in Memory?
> I need to store a lot of data (many little entries) on IDE- flashdrive.
> But flashdrives have a little problem with write-cycles.
> Each flash-cell can be rewritten approx
Friends,
Yesterday I upgraded from 7.1.3 on RedHat 6.2 to 7.2.1 on RedHat 7.2, and
now I'm having problems with ODBC connections from access on windows. The
problem I'm having is that I am unable to change or delete data; it says
that "The microsoft jet database engine stopped the process
[EMAIL PROTECTED] (David A. Leedom) writes:
> If I created 100 separate databases on a Linux Server would this be a
> problem? Or is the issue more related to concurrent connections?
If you're talking about multiple databases served by a single
postmaster, I don't believe it's much of an issue.
Hi Jodi,
Its to stop the triggers firing when you restore the new database from
the dumped file.
Imagine that the triggers have already done their work on other tables
when the data was first inserted or
later changed.
With pg_dump you are taking a snap shot that you would lat
Hi, everybody!
I was wonderring if it is a known "feature" to begin with, and, if there are any plans
to fix
it in future?
I had two very large tables in my database (about 30 million rows each), connected by
a foreign key,
and wanted to merge them together...
Something like this:
create tabl
Ciao Gianmarco;
You can upgrade your pg installation by using the rpm version.
download the rpm version, the latest at the moment could be the 7.2, and
try to upgrade your intstallation using the RPM command.
p.s. man rpm
--
Auri
On Fri, 12 Apr 2002, Gianmarco Piola wrote:
> I want to repor
Hi,
I need to extend the maximum name length for tables as the databases
that I'm using use automatically generated tables names that can get
quite lengthy. I've managed to find the appropriate header file to set
the max name length so that calls to create tables from the psql command
line work ok
Hi all together,
i hope i'm at right list...
Is there an opportunity to configure postgre to keep databases in Memory?
I need to store a lot of data (many little entries) on IDE- flashdrive.
But flashdrives have a little problem with write-cycles.
Each flash-cell can be rewritten approxiatly 30
Hi.
Mi name is Juan Pablo, I'm from Argentina and in my
job we are using PostgreSQL as a database server.But I have a problem using
triggers (ON INSERT). I can create a trigger without problem, but when it is
called,
I get the following error message:
"fmgr_info: function 18375: cache lo
Maybe it's your firewall that's blocking connections, check ipchains.
--
Rasmus T. MohrDirect : +45 36 910 122
Application Developer Mobile : +45 28 731 827
Netpointers Intl. ApS Phone :
I have installed PostgreSql7.2.1 on a mandrake8.2 with no errors
made a su - postgres and run /usr/local/pgsql/bin/postmaster -D -i
/usr/local/pgsql/data >logfile 2>&1 &
If I try to /usr/local/pgsql/bin/createdb test I get and error psql: could
not connect to server: No such file or directory ...
> If you're going to run tests on foreign-key performance, please use
> 7.2.*.
I just installed 7.2.1. I run 7.1.3 in parallel. after I run the script
to introduce 1000 rows in T1 in each version, deleting is much faster
with 7.1.3 than with 7.2.1 (I took the same configuration parameters for
bo
Hi Folks
I am trying to write a function that should archive old values to an
archiving table before update on the orignal table but it inserts both old
and new values to the archiving table here is the code:
CREATE FUNCTION fn_archive_01() RETURNS OPAQUE AS '
BEGIN
/* TG_OP is the
What is the practical limit of Postgres Databases on one typical PC
class Linux server?
If I created 100 separate databases on a Linux Server would this be a
problem? Or is the issue more related to concurrent connections?
---(end of broadcast)---
I have a 2 million+ table, mbz_rpt_item_val:
bank_id (integer)
item_name (character(16))
org_allow (integer)
time_id (character(10))
item_value(character varying(12))
and an index test_idx2:
time_id
org_allow
bank_id
The query planner seems to choose a very dumb method when I tell it to
expla
Hello all.
I've a performance problem on specific requests :
When I use timestamps + interval in where clauses, query performance is
slowed down by a factor of 20 or 30 For exemple :
select timestamp,value
from measure
where timestamp(now() - '1 hour'::interval)
Hello all.
I've a performance problem on specific requests :
When I use timestamps + interval in where clauses, query performance is slowed
down by a factor of 20 or 30 For exemple :
select timestamp,value
from measure
where timestamp(now() - '1 hour'::interval)
Hi,
I have installed postgres in red hat linux. the
pblm. is i couidn't able to connect from the client
machine which is also running in linux.
i have tried by intiating the postmaster with -i
option but still i coudn't able to connect.
can u clear me the following the doubts
1. how do
31 matches
Mail list logo