Hello.
This is a newbie question: what is the difference between using = and := in
plpgsql function ?
I tried with both and in both cases my function works...
Thanks.
Zlatko
---(end of broadcast)---
TIP 2: you can get off all lists at once with th
On May 9, 2005, at 18:00, Zlatko Matic wrote:
This is a newbie question: what is the difference between using = and
:= in plpgsql function ?
In pl/pgsql,
:= is assignment
= is a logical comparison for equality
Some languages, such as perl, use = for assignment and == for logical
comparison.
x =
Could I invite java (and may be other languages) and the Eclipse Visual Editor
as a new wrestler in the tournament?
http://www.eclipse.org/vep/
Jacques Massé
Diadfish: http://www.diadfish.org
PostgreSQL : http://www.postgresqlfr.org
> -Message d'o
Hi,
I am using Redhat Linux 9 and I configure the samba server with
workgoup of my local
area network. when i tried to connect it was getting the error message as
"\\myserver is not accessible. You might not have permission to use
this netowrk resource.
Contact the administrator of th
Hi,
I'm testing Delphi 2005 at the moment, with ZEOS Lib (libpq), and I have to say
it work fine, as Tony mentioned. I have a few questions:
1) I'm curious: are there a lot of big projects using ZEOS with PG or is that
technology still relatively new? I would like to use it a replacement for OD
Hi,
The company I work for actually uses the Zeos lib/Postgres extensively
to track the shipping and sales side for almost 3 years.
We're still running on a 7.2/7.4 Postgres database, because I haven't
been convinced yet to either update or upgrade to 8.x.x. I'm curious
if others have successfull
On Mon, 9 May 2005 08:09 pm, ElayaRaja S wrote:
> Hi,
Wrong Mailing list maybe? This is a PostgreSQL mailing list.
Regards
Russell Smith
> I am using Redhat Linux 9 and I configure the samba server with
> workgoup of my local
> area network. when i tried to connect it was getting the error
Hi,
I need a db connection pooling in PHP. As far I know persistent
connections are not the best solution so I'm thinking about using
SQLRelay. Does anyone have any experience using PostgreSQL + PHP +
SQLRelay ? Maybe you know other "connection pooling" solutions for PHP ?
Thanks in advance.
ML
Hi
I have the following functions , the functions are created but when it is invoked it errors out /
SampleDB=# create or replace function getmatch(anyarray) returns anyarray as $$SampleDB$# declareSampleDB$# sys_cursor cursor(key integer) is select sys_id from
Not with Postgres, but i'm using it with PHP/Oracle (easier to install
sqlrelay than oracle lient :) )
Anyway, it works ok and judging on comments on sqlrelay list, lots of
people find it good solution for connection pooling.
When I get some spare time, i'll probably rewrite postgres applications
I know that it was decided a fair few releases ago to stop creating an
implicit index for each foreign key,
By the way, I presume foreign key indices are used to check for
referential integrity on insert. Can the query planner also use then
somehow?
Thanks.
- John D. Burger
MITRE
---
Greetings,
We are working on speeding up the queries by creating indexes. We have
queries with searching criteria such as "select ... where *col1='...'*".
This is a simple query with only "=" operation. As a result I setup hash
index on column "col1". While, in postgreSQL 8 doc, it is wirttern:
For the second function you called select getmatch
without specifying the columns you want.
try select * from getmatch()
"Vidya" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]...
Hi
I have the following functions , the functions are created but when it is
invoked it e
Vidya,
Array_append is a function and is called - select
array_append(array,val).
You left out the select.
Sim
"Vidya" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]...
Hi
I have the following functions , the functions are created but when it is
invoked it errors
Michael Glaesemann <[EMAIL PROTECTED]> writes:
> On May 9, 2005, at 18:00, Zlatko Matic wrote:
>> This is a newbie question: what is the difference between using = and
>> := in plpgsql function ?
> In pl/pgsql,
> := is assignment
> = is a logical comparison for equality
It looks like the code w
On Thu, 2005-05-05 at 15:28, CSN wrote:
>
> --- Dann Corbit <[EMAIL PROTECTED]> wrote:
> > > why do you suppose
> > > neither Mysql nor Oracle has bothered to implement
> > it?
> >
> > Probably they just create a domain using a char
> > which can take on two
> > values (e.g. 't'/'f' or 1/0). Ora
Hi ALL,
we have a site that uses postgres as a backend for a forum. this forum
does a lot of deletes, selects and inserts. just recently for some reason
postgres eats a lot of processing power..
here are some tech-details:
tcpip_socket = true
max_connections = 260
superuser_
Ying Lu wrote:
May I know for simple "=" operation query, for "Hash index" vs. "B-tree"
index, which can provide better performance please?
I don't think we've found a case in which the hash index code
outperforms B+-tree indexes, even for "=". The hash index code also has
a number of additional
Hi:
My OS is RHL9. I installed postgresql-8.0.2. There are the
alterations I remembered. (1) in /etc/init.d/postgresql change " su
-l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA -p
/usr/bin/postmaster -o "-i" '-p ${PGPORT}' start > /dev/null 2>&1" <
/dev/null" to
" su -l postgr
Hi,
I have created a simple plpgsql function as follows as included below.
The function works fine but I need to have this done automatically on
updates and inserts. So I have a table
CREATE TABLE addresses (
address_id serial PRIMARY KEY,
companyvarchar(250),
fnamevarchar
Hi All,
Has anybody tried using gnuplot to plot results from queries; there
are some suggestions given in PostgreSQL Developer's Handbook but i
have not any luck so far!
Any pointers as how to send results from queries straight to a simple
plotting utility (ex:gnuplot)!
Thanks,
Hrishi
--
On Mon, 2005-05-09 at 08:55, JM wrote:
> Hi ALL,
>
> we have a site that uses postgres as a backend for a forum. this forum
> does a lot of deletes, selects and inserts. just recently for some reason
> postgres eats a lot of processing power..
>
> here are some tech-details:
>
>
Heh. Funny you should ask; I spent a fair amount of time yesterday
doing precisely this.
Here's my gnuplot file:
set terminal png small color picsize 1000 400
set style fill solid 1.0 border
set title "Concurrent listeners"
set xdata time
set xlabel "Time"
set ylabel "Cuncurrent Logged In Listen
H..looks like i simply can't send the query results to gnuplot
without an intermediary!! So far my search results have not yielded
anythingi guess intermediary is the only way to !! :(((
Hrishi
On 5/9/05, Ben <[EMAIL PROTECTED]> wrote:
> Heh. Funny you should ask; I spent a fair amoun
> Has anybody tried using gnuplot to plot results from queries; there
> are some suggestions given in PostgreSQL Developer's Handbook but i
> have not any luck so far!
> Any pointers as how to send results from queries straight to a simple
> plotting utility (ex:gnuplot)!
I use a text file as an i
Has anybody tried using gnuplot to plot results from queries; there
are some suggestions given in PostgreSQL Developer's Handbook but i
have not any luck so far!
Any pointers as how to send results from queries straight to a simple
plotting utility (ex:gnuplot)!
I use a text file as an intermed
Today I stumbled upon a very strange error. I was getting tired of
getting errors when I tried using function round(double
precision,integer) so I decided to build one of my own. I did*, then I
issued
select round(1.::double precision,2)
To this the connection to the postgres serv
Bonjour,
je me tourne vers vous car je n'arrive pas à solutionner mon probleme
qui est le suivant :
Je dois créer une Bd Postgres avec une table qui doit utiliser un
champ auto incrémental d'un pas de 6.
J'ai trouvé le type auto incrémental qui est SERIAL , mais je n'arrive
pas à voir comment
As an alternative, be sure to check out pl/R. Everything happens inside the
server except for the actual plot which goes to a file.
Sean
- Original Message -
From: "Hrishikesh Deshmukh" <[EMAIL PROTECTED]>
To: "Ben" <[EMAIL PROTECTED]>
Cc: "Postgresql-General"
Sent: Monday, May 09, 200
En français, il vaudrait mieux poster sur : [EMAIL PROTECTED]
Allez voir CREATE SEQUENCE INCREMENT BY ...
Voir la doc : le type serial equivaut à
CREATE SEQUENCE tablename_colname_seq;
CREATE TABLE tablename (
colname integer DEFAULT nextval('tablename_colname_seq') NOT NULL);
Jacques Mass
Hiya-
I'm looking for a function to return the number of words in a string,
split on whitespace. I'm coming from python, so I may just write it in
that but I wanted to check first. In python, one would write:
s="some string or other"
len(s.split())
Thanks!
--
Peter Fein [EMAI
Well, there is this:
http://www.varlena.com/varlena/GeneralBits/Tidbits/bernier/art_66/graphingWithR.html
I thought it was overkill for me, so I went with the gnuplot method.
On Mon, 9 May 2005, Hrishikesh Deshmukh wrote:
> H..looks like i simply can't send the query results to gnuplot
thanks.
- Original Message -
From: "Michael Glaesemann" <[EMAIL PROTECTED]>
To: "Zlatko Matic" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, May 09, 2005 11:30 AM
Subject: Re: [GENERAL] = or := ?
On May 9, 2005, at 18:00, Zlatko Matic wrote:
This is a newbie question: what is the difference be
On Mon, May 09, 2005 at 09:04:49AM -0400, John D. Burger wrote:
> >I know that it was decided a fair few releases ago to stop creating an
> >implicit index for each foreign key,
>
> By the way, I presume foreign key indices are used to check for
> referential integrity on insert. Can the query p
Can someone explain me the following options while using pgAdimn III for
backup:
blobs
insert commands
verbose messages
Thanks.
- Original Message -
From: "Sean Davis" <[EMAIL PROTECTED]>
To: "Hrishikesh Deshmukh" <[EMAIL PROTECTED]>; "Ben"
<[EMAIL PROTECTED]>
Cc: "Postgresql-General"
You can use a combination of regex
(http://www.postgresql.org/docs/8.0/static/functions-matching.html#FUNCTIONS-POSIX-REGEXP)
and strpos inside a plpgsql function to do this, but using plpython or
plperl might be faster. A C function would possibly be faster still.
On Mon, May 09, 2005 at 11:21:28
On Mon, May 09, 2005 at 11:49:41AM -0500, Jim C. Nasby wrote:
> You can use a combination of regex
> (http://www.postgresql.org/docs/8.0/static/functions-matching.html#FUNCTIONS-POSIX-REGEXP)
> and strpos inside a plpgsql function to do this, but using plpython or
> plperl might be faster. A C func
HI all,
I am new to PostGreSQL and I need some help. We received a database in PostGreSQL from
another group within the company, and we are planning to use ERWIN to
Forward/Engineer it into a SQL Server because one of our tool
can only use SQL Server. Don’t
know if anyone had done thi
For the sake of the archives, I just found out that my problem was that:
echo -e "Content-type: image/png\n\n";
...actually throws in 3 newlines, not two. (Doh!) Fixing that means I now
have a CGI that generates gnuplots from postgres entirely in the pipeline,
withouut any annoying temp files. p
By the way, I presume foreign key indices are used to check for
referential integrity on insert. Can the query planner also use then
somehow?
It can use them the same way it can use any other index.
Hmm, I guess I thought that "foreign key indices" were some special
kind of index. For instance,
On Mon, 2005-05-09 at 12:40, John D. Burger wrote:
> >> By the way, I presume foreign key indices are used to check for
> >> referential integrity on insert. Can the query planner also use then
> >> somehow?
> >
> > It can use them the same way it can use any other index.
>
> Hmm, I guess I thoug
> I'm guessing now that we're just talking about a regular index on a
> column that happens to have a foreign key reference to another column.
> Is that the case?
>
That's true, but just as the query planner can use an index for WHERE
conditions, it can use an index for a join condition. So if y
On 05/09/05 11:21 AM CDT, Peter Fein <[EMAIL PROTECTED]> said:
> Hiya-
>
> I'm looking for a function to return the number of words in a string,
> split on whitespace. I'm coming from python, so I may just write it
> in that but I wanted to check first. In python, one would write:
>
> s="some s
it is about null problem
declare
res numeric(15,2);
_pida integer[4]; < Problem is here must be ---> pida
integer[4]='{}';
_pid integer;
_rec record;
..
"ALÝ ÇELÝK" <[EMAIL PROTECTED]>, haber iletisinde þunlarý
yazdý:[EMAIL PROTECTED]
>
> I have a
On 5/9/05, Neil Conway <[EMAIL PROTECTED]> wrote:
> I don't think we've found a case in which the hash index code
> outperforms B+-tree indexes, even for "=". The hash index code also has
> a number of additional issues: for example, it isn't WAL safe, it has
> relatively poor concurrency, and crea
Christopher Petrilli wrote:
This being the case, is there ever ANY reason for someone to use it?
Well, someone might fix it up at some point in the future. I don't think
there's anything fundamentally wrong with hash indexes, it is just that
the current implementation is a bit lacking.
If not, t
On Tue, May 10, 2005 at 01:34:57AM +1000, Neil Conway wrote:
> Christopher Petrilli wrote:
> >This being the case, is there ever ANY reason for someone to use it?
>
> Well, someone might fix it up at some point in the future. I don't think
> there's anything fundamentally wrong with hash indexes,
Jim C. Nasby wrote:
Having indexes that people shouldn't be using does add confusion for
users, and presents the opportunity for foot-shooting.
Emitting a warning/notice on hash-index creation is something I've
suggested in the past -- that would be fine with me.
Even if there is some kind of adv
On Tue, May 10, 2005 at 02:38:41AM +1000, Neil Conway wrote:
> Jim C. Nasby wrote:
> >Having indexes that people shouldn't be using does add confusion for
> >users, and presents the opportunity for foot-shooting.
>
> Emitting a warning/notice on hash-index creation is something I've
> suggested i
Hi
In MS SQL there is a concept of Clustering database servers. This allows for
load balancing.
Does PostgreSQL have a similar concept?
Thanks
Craig
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
On Mon, May 09, 2005 at 10:13:12AM -0700, Jonathan Lam wrote:
> HI all,
>
> I am new to PostGreSQL and I need some help. We received a database
> in PostGreSQL from another group within the company, and we are
> planning to use ERWIN to Forward/Engineer it into a SQL Server
> because one of our
> So how can I create a trigger to automatically update the hash fields
> on updates and inserts?
Something like the following works for me:
create or replace function public.my_trigger()
returns trigger as '
NEW.hashfield = hashfunction(NEW.data1,NEW.data2);
RETURN NEW;
END;
' language 'plpgsq
Slony is the master-slave (not multi-master IIRC) replication environment.
I haven't used it, but apparently there are cognoscenti among us who have.
I would think, a bit, about what kind of "load" (e.g. CPU, network, disk
queues, disk allocation, et cetera) you want to balance before picking u
I would like to write a trigger or function that spawns a forked
process so that the transaction is considered 'complete' to the client,
but continues to perform more work. I've been looking for examples to
steal^H^H^H^H^H learn from but have only found someone asking pretty
much the same question
Christopher Murtagh <[EMAIL PROTECTED]> writes:
> I would like to write a trigger or function that spawns a forked
> process so that the transaction is considered 'complete' to the client,
> but continues to perform more work.
It's not very clear what you are hoping to have the forked process do,
On Mon, 2005-05-09 at 13:41, Craig Bryden wrote:
> Hi
>
> In MS SQL there is a concept of Clustering database servers. This allows for
> load balancing.
> Does PostgreSQL have a similar concept?
This really kinda depends on what you are tring to load balance. I/O,
parallel users, CPU intensive
Hi All,
How can one use a table created for saving the results for a query be
used in WHERE for subsequent query!!!
Step 1) create table temp as select gene from dataTable1 intersect
select gene from dataTable2;
Now temp has been created, temp has only one column which has list of
genes and noth
Hello,
> But I know from past experience that I am not going to make a lot of
> progress teaching myself any form of C language.
I had to learn programming with Pascal at university first. It worked
for me.
Then I had to learn Fortran. Didn't like some things about it, but
still managed to
Temp tables go away after the transaction completes.
Perhaps you want a permanent table, dropped later with "drop table".
Either that, or you may want to bracket the entire sequence in
begin/end.
I imagine that what you want to accomplish can be done.
But your pseudo-code is very vague.
Give the
Hi,
I have two tables with genes and its annotation and a bunch of
parameters, i wanted to know what are the genes common to these two
tables, so i wrote this query
create table temp as select gene from dataTable1 intersect
select gene from dataTable2;
The resulting table has only genes list (on
If I understand correctly, you are not creating a temp table, but
(rather) a table called 'temp.'
What you want to accomplish is still not entirely clear to me.
Do you wish to "embellish" or "enhance" the 'temp' table data with
description data? If so, then you want an outer join.
Do you want t
On Mon, 2005-05-09 at 15:38 -0400, Tom Lane wrote:
> Christopher Murtagh <[EMAIL PROTECTED]> writes:
> > I would like to write a trigger or function that spawns a forked
> > process so that the transaction is considered 'complete' to the client,
> > but continues to perform more work.
>
> It's no
On 5/9/05, Hrishikesh Deshmukh <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have two tables with genes and its annotation and a bunch of
> parameters, i wanted to know what are the genes common to these two
> tables, so i wrote this query
>
> create table temp as select gene from dataTable1 intersect
>
Christopher Murtagh <[EMAIL PROTECTED]> writes:
> No, I don't want the trigger to do any db stuff at all. Basically, I've
> got a content management system that is going to be split across a
> cluster. Upon an update submission from one of them, I want to replicate
> across the others (which can
Douglas McNaught <[EMAIL PROTECTED]> writes:
> Why not have a client connection LISTENing and doing the
> synchronization, and have the trigger use NOTIFY?
> Or, you could have the trigger write to a table, and have another
> client periodically scanning the table for new sync events.
> Either one
Excellent, I got it working...Thanks ;)
Abdul-Wahid
On 5/9/05, Mike Nolan <[EMAIL PROTECTED]> wrote:
> > So how can I create a trigger to automatically update the hash fields
> > on updates and inserts?
>
> Something like the following works for me:
>
> create or replace function public.my_trig
Jonathan Lam wrote:
> HI all,
>
> I am new to PostGreSQL and I need some help. We received a database
> in PostGreSQL from another group within the company, and we are
> planning to use ERWIN to Forward/Engineer it into a SQL Server
> because one of our tool can only use SQL Server.
Have you inv
Postgres Newsgroup,
My company has been looking for a good database
modelling tool for postgres and have yet to find something that completely
satisfies our needs. We are currently using a product called DBWrench which is
pretty good and has all the features we are looking for but is f
Mark Borins wrote:
-->
Postgres Newsgroup,
My company has been looking for a good database modelling tool for
postgres and have yet to find something that completely satisfies our
needs. We are currently using a product called DBWrench which is pretty
good and has all the features we are loo
Sorry, I should have also specified that we are looking for a tool where we
can save the schema externally. Then take that schema and have the tool
compare it to a database and generate a change script.
So the process would be to maintain database structure in a tool.
Be able to save the schema.
Other possibilities:
http://www.datanamic.com/dezign/factsheet.html
http://www.visual-paradigm.com/product/dbva/
From: Dann Corbit
Sent: Monday, May 09, 2005 3:24 PM
To: 'Mark Borins'
Subject: RE: [GENERAL] Data
Modelling Tools
Free trial:
http://www.dds-pro.com/main
This is my favits just awesome...
http://www.sqlmanager.net/
On 5/9/05, Mark Borins <[EMAIL PROTECTED]> wrote:
>
>
>
> Postgres Newsgroup,
>
>
>
> My company has been looking for a good database modelling tool for postgres
> and have yet to find something that completely satisfies
I have to say that ERwin is pretty much the bomb. It indirectly
supports postgresql through ODBC, which I've used with much success.
It will also port your schema to another RDBMS system if you wish. It
can build a model from either a running database or DDL or by
construction, and will also out
Hello again. I had a problem a few weeks ago with using IN ( some_array
) having really rough performance. Special thanks to Ron Mayer for the
suggestion of using int_array_enum(some_array) to join against. I had
to upgrade to PG8 but that technique works really well. Now I have a
question
[note: it is better to create a new thread than to hijack an
unrelated one]
On Mon, 2005-05-09 at 18:45 +0200, Zlatko Matic wrote:
> Can someone explain me the following options while using pgAdimn III for
> backup:
>
my guess is...
> blobs
include blobs in backup. blobs are not included
Jim C. Nasby wrote:
>> No, hash joins and hash indexes are unrelated.
I know they are now, but does that have to be the case?
I mean, the algorithms are fundamentally unrelated. They share a bit of
code such as the hash functions themselves, but they are really solving
two different problems (dis
On Mon, 2005-05-09 at 17:01 -0400, Douglas McNaught wrote:
> Why not have a client connection LISTENing and doing the
> synchronization, and have the trigger use NOTIFY?
>
> Or, you could have the trigger write to a table, and have another
> client periodically scanning the table for new sync even
On Mon, 2005-05-09 at 17:07 -0400, Tom Lane wrote:
> Douglas McNaught <[EMAIL PROTECTED]> writes:
> > Why not have a client connection LISTENing and doing the
> > synchronization, and have the trigger use NOTIFY?
> > Or, you could have the trigger write to a table, and have another
> > client perio
Christopher Murtagh <[EMAIL PROTECTED]> writes:
> On Mon, 2005-05-09 at 17:01 -0400, Douglas McNaught wrote:
>> Why not have a client connection LISTENing and doing the
>> synchronization, and have the trigger use NOTIFY?
>>
>> Or, you could have the trigger write to a table, and have another
>>
On Mon, May 09, 2005 at 07:05:18PM -0400, Bart Grantham wrote:
>
> Let me put it this way... how do I do this:
>
> -- my_array is an INT[]
>
> _my_array := select some_column from some_table;
In PostgreSQL 7.4 and later you can use an array constructor:
my_array := ARRAY(SELECT some_column FR
On Mon, May 09, 2005 at 07:05:18PM -0400, Bart Grantham wrote:
> Hello again. I had a problem a few weeks ago with using IN ( some_array
> ) having really rough performance. Special thanks to Ron Mayer for the
> suggestion of using int_array_enum(some_array) to join against. I had
> to upgrad
Jim C. Nasby wrote:
> On Tue, May 10, 2005 at 02:38:41AM +1000, Neil Conway wrote:
> > Jim C. Nasby wrote:
> > >Having indexes that people shouldn't be using does add confusion for
> > >users, and presents the opportunity for foot-shooting.
> >
> > Emitting a warning/notice on hash-index creation
Hi,
I'm running Postgres 8 and need a log analyzer to report connection stats.
I've installed pganalyzer which doesn't seem to work with 8.0.
I've also installed Pratical Query Analyzer however this doesn't report
on connections.
Can anyone recommend another log analyzer like pg-analyzer?
Your
Christopher Murtagh <[EMAIL PROTECTED]> writes:
> On Mon, 2005-05-09 at 17:07 -0400, Tom Lane wrote:
>> ... not to mention it would avoid the risk of propagating
>> not-yet-committed changes.
> How's that? If I can notify a daemon that the change is committed, then
> why couldn't I write a forkin
I need a db connection pooling in PHP. As far I know persistent
connections are not the best solution so I'm thinking about using
SQLRelay. Does anyone have any experience using PostgreSQL + PHP +
SQLRelay ? Maybe you know other "connection pooling" solutions for PHP ?
Try pgpool.
Chris
Christopher Kings-Lynne wrote:
I need a db connection pooling in PHP. As far I know persistent
connections are not the best solution so I'm thinking about using
SQLRelay. Does anyone have any experience using PostgreSQL + PHP +
SQLRelay ? Maybe you know other "connection pooling" solutions for P
Neil Conway <[EMAIL PROTECTED]> writes:
> Jim C. Nasby wrote:
>>> No, hash joins and hash indexes are unrelated.
>> I know they are now, but does that have to be the case?
> I mean, the algorithms are fundamentally unrelated. They share a bit of
> code such as the hash functions themselves, but t
Tom Lane wrote:
On the other hand, once you reach the target index page, a hash index
has no better method than linear scan through all the page's index
entries to find the actually wanted key(s)
I wonder if it would be possible to store the keys in a hash bucket in
sorted order, provided that the
On Monday 09 May 2005 23:28, Scott Marlowe wrote:
> On Mon, 2005-05-09 at 08:55, JM wrote:
> > Hi ALL,
> >
> > we have a site that uses postgres as a backend for a forum. this forum
> > does a lot of deletes, selects and inserts. just recently for some
> > reason postgres eats a lot of proces
i didnt set fsm... the config i paste is all that i put into place...
is there a way to look at the query that's eating too much process
without starting the DB and redirect stdout out to a file?
process ID 32082..
32082 pts/3S 0:08 postgres: mydbuser mydb 10.10.10.1 SELECT
if i do top
Case Studio doesn't generate alter statements.
It does have a database comparison tool, which I have found to be very cool.
""Joshua D. Drake"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Mark Borins wrote:
> > -->
> >
> > Postgres Newsgroup,
> >
> >
> >
> > My company has been
Christopher Kings-Lynne napisaÅ(a):
I need a db connection pooling in PHP. As far I know persistent
connections are not the best solution so I'm thinking about using
SQLRelay. Does anyone have any experience using PostgreSQL + PHP +
SQLRelay ? Maybe you know other "connection pooling" solutions
Wolfgang, thanks! I am very persuaded by your arguments regarding
Python. What you have written makes me look at Python in a different
light.
I happened to find a download of Python2.2 which I installed at work but
have not tried out. I wish I could find detailed instructions on WHICH
py
On Tue, 10 May 2005 12:19:43 +0800 Jerome Macaranas <[EMAIL PROTECTED]> thought
long, then sat down and wrote:
> im using RH9
>
> postgres 7.3.4
Maybe you ran into the same problem I had about a year ago. See
http://archives.postgresql.org/pgsql-general/2004-03/msg00810.php and thread.
My dat
Hi,
what fix did you do? go for 7.4?
tia,
On Tuesday 10 May 2005 14:33, Frank Finner wrote:
> On Tue, 10 May 2005 12:19:43 +0800 Jerome Macaranas <[EMAIL PROTECTED]>
thought long, then sat down and wrote:
> > im using RH9
> >
> > postgres 7.3.4
>
> Maybe you ran into the same problem I had abou
my data directory is just 1.7G
On Tuesday 10 May 2005 14:33, Frank Finner wrote:
> On Tue, 10 May 2005 12:19:43 +0800 Jerome Macaranas <[EMAIL PROTECTED]>
thought long, then sat down and wrote:
> > im using RH9
> >
> > postgres 7.3.4
>
> Maybe you ran into the same problem I had about a year ag
Neil Conway <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> On the other hand, once you reach the target index page, a hash index
>> has no better method than linear scan through all the page's index
>> entries to find the actually wanted key(s)
> I wonder if it would be possible to store the key
Tom Lane wrote:
I have a gut reaction against that: it makes hash indexes fundamentally
subservient to btrees.
I wouldn't say "subservient" -- if there is no ordering defined for the
index key, we just do a linear scan.
However: what about storing the things in hashcode order? Ordering uint32s
d
Tom Lane <[EMAIL PROTECTED]> writes:
> However: what about storing the things in hashcode order? Ordering uint32s
> doesn't seem like any big conceptual problem.
>
> I think that efficient implementation of this would require explicitly
> storing the hash code for each index entry, which we don'
99 matches
Mail list logo
