Thanks Tom,
You are absolutely right, the commandt stty istrip was the first line of my
.profile...
Regards,
Patrick
---
Patrick Fiche
email : [EMAIL PROTECTED]
tél : 01 69 29 36 18
-
Am Freitag, den 03.06.2005, 00:36 +0200 schrieb Peter Eisentraut:
> On a particular system, loading 1 million rows (100 bytes, nothing
> fancy) into PostgreSQL one transaction at a time takes about 90
> minutes. Doing the same in MySQL/InnoDB takes about 3 minutes. InnoDB
> is supposed to have
That certainly looks like it! Thanks!
- DAP
>-Original Message-
>From: Michael Fuhr [mailto:[EMAIL PROTECTED]
>Sent: Thursday, June 02, 2005 8:47 PM
>To: Bruno Wolff III; David Parker; postgres general
>Subject: Re: [GENERAL] SQL call to get pid of current connection
>
>On Thu, Jun 02,
"David Parker" <[EMAIL PROTECTED]> writes:
> Is there a function call that will return the pid of the postgres
> process associated with the current client connection?
libpq makes this available as PQbackendPID(). Dunno about other
client libraries.
regards, tom lane
---
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Something ain't kosher. I tried the same test with the latest and greatest
DBI, DBD::Pg, and PostgreSQL, tuned everything up, and still got around
10,000 transactions per minute or so. There is no way MySQL is doing an
order of magnitude or more bett
On Thu, Jun 02, 2005 at 05:02:14PM -0500, Bruno Wolff III wrote:
> On Thu, Jun 02, 2005 at 17:04:22 -0400,
> David Parker <[EMAIL PROTECTED]> wrote:
> > Is there a function call that will return the pid of the postgres
> > process associated with the current client connection?
>
> I thought I re
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> On a particular system, loading 1 million rows (100 bytes, nothing
> fancy) into PostgreSQL one transaction at a time takes about 90
> minutes. Doing the same in MySQL/InnoDB takes about 3 minutes.
What sort of hardware, exactly?
Simple division s
Dear People,
After a long time of various timeouts, I managed to get back on track
developing the long promised PQDN website. As some of you might know. I was
working on a project called the PostgreSQL Developer Network.
The websites (which is a la MSDN) is meant to provide a knowl
On Fri, Jun 03, 2005 at 12:36:29AM +0200, Peter Eisentraut wrote:
> On a particular system, loading 1 million rows (100 bytes, nothing
> fancy) into PostgreSQL one transaction at a time takes about 90
> minutes. Doing the same in MySQL/InnoDB takes about 3 minutes.
> InnoDB is supposed to have a s
Peter Eisentraut wrote:
On a particular system, loading 1 million rows (100 bytes, nothing
fancy) into PostgreSQL one transaction at a time takes about 90
minutes.
Doing the same in MySQL/InnoDB takes about 3 minutes. InnoDB
is supposed to have a similar level of functionality as far as th
On a particular system, loading 1 million rows (100 bytes, nothing
fancy) into PostgreSQL one transaction at a time takes about 90
minutes. Doing the same in MySQL/InnoDB takes about 3 minutes. InnoDB
is supposed to have a similar level of functionality as far as the
storage manager is concer
Marcelo wrote:
Hi,
Thanks for your reply, but I have some doubts.
Are yoy sugesting I create the column as an Integer then change it to
Serial? in Pgsql 7 you cant change a column type.
Serial is not a real data type. Do this.
create table foo (bar integer not null);
create sequence foo_bar_s
On Thu, 2005-06-02 at 17:47 -0400, Marcelo wrote:
> Hi,
> Thanks for your reply, but I have some doubts.
>
> Are yoy sugesting I create the column as an Integer then change it to
> Serial? in Pgsql 7 you cant change a column type.
>
> If I create the column as an int then add a default value, how
Yeah, simple enough. I just wanted to make sure I wasn't duplicating
something that was already there.
Thanks.
- DAP
>-Original Message-
>From: Bruno Wolff III [mailto:[EMAIL PROTECTED]
>Sent: Thursday, June 02, 2005 6:02 PM
>To: David Parker
>Cc: postgres general
>Subject: Re: SQL cal
On Thu, Jun 02, 2005 at 17:04:22 -0400,
David Parker <[EMAIL PROTECTED]> wrote:
> Is there a function call that will return the pid of the postgres
> process associated with the current client connection?
I thought I remembered seeing one, but I looked through the development
docs and didn't see
Hi,
Thanks for your reply, but I have some doubts.
Are yoy sugesting I create the column as an Integer then change it to
Serial? in Pgsql 7 you cant change a column type.
If I create the column as an int then add a default value, how can I make
this default value increment with each insert?
Tha
Is there a function
call that will return the pid of the postgres process associated with the
current client connection?
-
DAP--David
Parker Tazz Networks (401)
709-5130
On Thu, 2005-06-02 at 15:29, Marcelo wrote:
> Hello,
> Using Postgres 7.4, I am trying to perform an "alter table
> temptable add column "myCol" serial"
>
> It gives the following msg
> ERROR: adding columns with defaults is not implemented
>
> You cannot add a column that is serial in a table
Hello,
Using Postgres 7.4, I am trying to perform an "alter table temptable add
column "myCol" serial"
It gives the following msg
ERROR: adding columns with defaults is not
implemented
You cannot add a column that is serial in a table
which already has data in postgres 7.
Is there a w
A couple of links:
http://www.dbazine.com/ofinterest/oi-articles/celko24
http://www.dbmsmag.com/9603d06.html
On Jun 2, 2005, at 2:33 AM, Joachim Zobel wrote:
Hi.
I am looking for a way to write a SELECT that finds connectivity
components of a graph or at least for one that given two nodes
de
I'm not sure if it's relevant to your question
http://www-2.cs.cmu.edu/~cache/pg_graph/
pg_graph provides a way of handling graph-based data structures within
the relational database PostgreSQL. In particular, it provides a convenient
means of inserting graphs as BLOB-like objects in the RDBMS.
You mean, you want to be able to say something like:
select isConnected(a,b)
and get back a true/false, or maybe the path?
That seems quite doable in SQL, assuming you either store those results
and simply use sql to retrieve them, or use a stored proc to compute the
result each time.
On Thu,
On Thu, Jun 02, 2005 at 18:00:17 +0100,
Richard Huxton wrote:
>
> Certainly, but if the text in the logfile row is the same, then hashing
> isn't going to make a blind bit of difference. That's the root of my
> concern, and something only Dinesh knows.
Sure it is. Because the hash can be use
Hi.
I am looking for a way to write a SELECT that finds connectivity
components of a graph or at least for one that given two nodes
determines if there is a path between them. It seems that this is not
possible, no matter what graph representation I choose. Which constructs
from set theory are mis
Tom Lane <[EMAIL PROTECTED]> writes:
> "Roman F" <[EMAIL PROTECTED]> writes:
>
> > DELETE FROM child_table WHERE parentid NOT IN
> > (SELECT parentid FROM parent_table)
>
> Another idea is to try an outer join:
>
> SELECT child_table.parentid INTO tmp_table
> FROM child_table LEFT
Tony Caduto wrote:
Sean,
I am tooting my own horn here, but I would recomend PG Lightning Admin.
It has a incredible function editor (and query editor) that is based on
Synedit(synedit.sourceforge.net), and has full code completion that
includes
all the Postgres built in functions,exception nam
On Jun 2, 2005, at 9:43 AM, [EMAIL PROTECTED] wrote:Your "cron" job on ALIS. $HOME/.profile; pg_dump alis -U postgres -f $AQSADIR/data/backup/alis_data.sql -a -d >/dev/null 2>&1 produced the following output: stty: : No such device or address What's wrong with it ? Your .profile executes the st
Bruno Wolff III wrote:
On Thu, Jun 02, 2005 at 13:40:53 +0100,
Richard Huxton wrote:
Actually, Dinesh didn't mention he was using this for the speed of
lookup. He'd defined the columns as being the PRIMARY KEY, presumably
because he feels they are/should be unique. Given that they are rows
On Thu, Jun 02, 2005 at 13:40:53 +0100,
Richard Huxton wrote:
>
> Actually, Dinesh didn't mention he was using this for the speed of
> lookup. He'd defined the columns as being the PRIMARY KEY, presumably
> because he feels they are/should be unique. Given that they are rows
> from a logfile
I changed from postgresql to mysql and everything now is great ;)
Same machine, same os, etc...
On 6/2/05, Roman Neuhauser <[EMAIL PROTECTED]> wrote:
> # [EMAIL PROTECTED] / 2005-05-03 17:56:53 -0300:
> > The FreeBSD is the last STABLE version. I can try to change some
> > hardware, I already
AAARRRGGGHHH... Now I understand you, Josh. Sorry.
You are correct.
Thanks!
Mark
On Jun 1, 2005, at 4:39 PM, Joshua D. Drake wrote:
[EMAIL PROTECTED] wrote:
Hello!
I have a view that I'm putting into a report in my application. I'd
like to get several blank lines returned by the view as w
Tom Lane <[EMAIL PROTECTED]> wrote:
> backends only ship stats to the collector at transaction commit.> Or maybe it's at the end of processing a client command. It's certainly> not continuous.
yup that i already know
but is there any way to make it do the update more frequently 4 times i
[EMAIL PROTECTED] writes:
> The dump execution is OK but my user gets a mail containing the =
> following
> message :
>
> Your "cron" job on ALIS
> . $HOME/.profile; pg_dump alis -U postgres -f
> $AQSADIR/data/backup/alis_data.sql -a -d >/dev/null 2>&1
>
> produced the following output:
>
> s
On 6/2/05, Richard Huxton wrote:
> KÖPFERL Robert wrote:
> > To me it seems that the definer of this table missed the concept index ...
> > or the concept database
> > One usually looks up data using a key, but if the whole row is the key, what
> > data shall be looked up.
>
> > So short story lo
I do not believe you can do this without a subquery - you are tryingto get 2 separate pieces of information from your data
* some data about the record having MAX(rank) for each categoryand * the count of records in each category
Hi, I guess i try to answer my own question which end up with c
# [EMAIL PROTECTED] / 2005-05-03 17:56:53 -0300:
> The FreeBSD is the last STABLE version. I can try to change some
> hardware, I already changed memory, what can I try now ? the processor
> ? motherboard ??
> On 5/3/05, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> > On Tue, 2005-05-03 at 15:04,
Richard Huxton writes:
> It is possible that during very busy periods the stats don't get
> recorded - that's part of the design.
IIRC, backends only ship stats to the collector at transaction commit.
Or maybe it's at the end of processing a client command. It's certainly
not continuous.
"Gerald D. Anderson" <[EMAIL PROTECTED]> writes:
> So, the plot thickens. Is there somewhere I can go tweak a few bytes to
> make it think it's 7.3?
No. That's not what you want anyway; you want a late 7.4 build, just
one without the hierarchical-queries patch. I dunno enough about Gentoo
to s
I am trying to automate a postgres database data and schema
dump through windows.
Does anyone have any suggestions on best way to do
so.
Thanks
Kind Regards,Shaun
Clements
Hi
all,
I'm using PostgreSQL
8.0.2 on Solaris 10.
I would like to
manage an automatic backup of my database.
Here is the line in
the cron :
37 * * * * .
$HOME/.profile; pg_dump alis -U postgres -f $AQSADIR/data/backup/alis_data.sql
-a -d >/dev/null 2>&1
The dump execution
is OK but my
On Thu, Jun 02, 2005 at 11:00:56AM +0100, Richard Huxton wrote:
> Nageshwar Rao wrote:
> >Can we write/read a file in postgresql procedure ?
>
> Using one of the "untrusted" languages, yes. They can only be used by an
> administrator but have access to the full capabilities of the underlying
> p
KÖPFERL Robert wrote:
To me it seems that the definer of this table missed the concept index ...
or the concept database
One usually looks up data using a key, but if the whole row is the key, what
data shall be looked up.
So short story long: Remove data from your index. The data column seem
Ok, well it looks like Richard owes Tom a lunch, or that's my best guess
anyway. I am running Gentoo, as far as that particular patch, I'm
unsure, but if it's installed by default then yes. So, I've pulled down
the earliest ebuild I can get which is 7.3.6. Get it installed and go
to start it
I don't think there is a way to do that. You'll have to create an audit table
and a rule to update it or you'll have to add a column to the table and a
trigger to update it.
On Thursday 02 June 2005 01:22 am, Eisenhut, Glenn saith:
> Folks - hi
>
> Is it possible to determine when a row was inse
On Thu, Jun 02, 2005 at 06:22:01 +0100,
"Eisenhut, Glenn" <[EMAIL PROTECTED]> wrote:
>
>
> Folks - hi
>
> Is it possible to determine when a row was inserted into a table using the
> system catalogs or such.
> I have the situation where I need to find out when a user was added to a user
> ta
On Thu, Jun 02, 2005 at 17:48:47 +0530,
Dinesh Pandey <[EMAIL PROTECTED]> wrote:
> Yes I am storing some "error messages" in data column, and the PK columns
> are party of search criteria.
If you need to be able to search based on the entire stored error message,
than you might try adding an ind
Folks - hi
Is it possible to determine when a row was inserted into a table using the
system catalogs or such.
I have the situation where I need to find out when a user was added to a user
table - the table was not setup with a date to track this.
Thanks
Glenn
**
[EMAIL PROTECTED] (Yudie Pg) writes:
> Hello,
> I have a table, structure like this:
> create table product(
> sku, int4 not null,
> category int4 null,
> display_name varchar(100) null,
> rank int4 null
> )
> let say example data:
> sku, category, display_name
> ===
> 10
On Thu, Jun 02, 2005 at 13:26:32 +0200,
Havasvölgyi Ottó <[EMAIL PROTECTED]> wrote:
>
> I tried to simulate this unexpected result, but with no success. Here in
> Hungary we had daylight saving this year on the 27th of March
> (http://webexhibits.org/daylightsaving/b.html). So I tried these:
>
Sean,
I am tooting my own horn here, but I would recomend PG Lightning Admin.
It has a incredible function editor (and query editor) that is based on
Synedit(synedit.sourceforge.net), and has full code completion that includes
all the Postgres built in functions,exception names,types etc etc, and
On Thu, Jun 02, 2005 at 14:08:54 +0200,
KÖPFERL Robert <[EMAIL PROTECTED]> wrote:
> To me it seems that the definer of this table missed the concept index ...
> or the concept database
> One usually looks up data using a key, but if the whole row is the key, what
> data shall be looked up.
You s
Yes I am storing
some “error messages” in data column, and the PK columns are party
of search criteria.
Thanks
Dinesh Pandey
From: Ramakrishnan
Muralidharan [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 02, 2005 4:44
PM
To: [EMAIL PROTECTED];
pgsql-general@postgresql.org;
To me it seems that the definer of this table missed the concept index ...
or the concept database
One usually looks up data using a key, but if the whole row is the key, what
data shall be looked up.
So short story long: Remove data from your index. The data column seems
like the data to be look
Am Donnerstag, 2. Juni 2005 12:03 schrieb Martijn van Oosterhout:
> On Thu, Jun 02, 2005 at 12:58:33PM +0300, Kaloyan Iliev Iliev wrote:
> > Hi,
> >
> > I suppose the paralel work will be a problem if you are using one
> > sequence for all tables.
>
> I don't know about this. Sequences are designe
Shaun Clements wrote:
Apologies if this post is a repeat.
I am trying to automate a postgres database data and schema dump through
windows.
Does anyone have any suggestions on best way to do so.
Thanks
Call pg_dump via a batch-file and run it from the Windows scheduler? Or
am I missing some
Hi,
- Original Message -
From: "Bruno Wolff III" <[EMAIL PROTECTED]>
To: "Havasvölgyi Ottó" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, June 02, 2005 3:53 AM
Subject: Re: [GENERAL] interval integer comparison
> On Thu, Jun 02, 2005 at 01:54:12 +0200,
> Havasvölgyi Ottó <[EMAIL PROTECTED]
Hi
It is not advisable to add a variable length data field in the Index key, since
it is very difficult predict the size of the field which may vary from record to
record.
are you included this field for Full text search on data
field?
Regards,
R.
Apologies if this post is a repeat.
I am trying to automate a postgres database data and schema
dump through windows.
Does anyone have any suggestions on best way to do
so.
Thanks
Kind Regards,Shaun
Clements
Himanshu Baweja wrote:
i also noted one more thing... the stats are getting updated only
when i do vacuum is that wht is supposed to happen... or
something is wrong
Hmm - there's something strange going on certainly. Try a couple of
simple queries on a table and see whether the stats g
i also noted one more thing... the stats are getting updated only when i do vacuum is that wht is supposed to happen... or something is wrong
thx
HimanshuHimanshu Baweja <[EMAIL PROTECTED]> wrote:
i am trying to identify which tables should be moved to diff drives i first identified
Dinesh Pandey wrote:
I am inserting some log messages in the column "data". (Basically I am
inserting records from reading an xml file)
In the PRIMARY KEY, btree (scan_id, host_ip, port_num, plugin_id, severity,
data) data is of type TEXT and can contain long string values.
I'm still not convi
On Thu, Jan 01, 2004 at 03:13:48PM +0530, Dinesh Pandey wrote:
> One of the columns in primary key is of type "TEXT". I am able to insert
> with small data, but for around 3000 characters it's failing. How to handle
> that?
Easy, btree indexes can't handle data with more that 2713 bytes.
You need
I am inserting some log messages in the column "data". (Basically I am
inserting records from reading an xml file)
In the PRIMARY KEY, btree (scan_id, host_ip, port_num, plugin_id, severity,
data) data is of type TEXT and can contain long string values.
The question is how to remove this error "i
On Thu, Jun 02, 2005 at 12:58:33PM +0300, Kaloyan Iliev Iliev wrote:
> Hi,
>
> I suppose the paralel work will be a problem if you are using one
> sequence for all tables. If you insert a large amount of rows in
> different tables there will be great slowdown because your sequence is
> the bott
Am Donnerstag, den 02.06.2005, 15:06 +0530 schrieb Nageshwar Rao:
> Can we write/read a file in postgresql procedure ?
Yes.
--
Tino Wildenhain <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 6: Have you searched our list archives?
Nageshwar Rao wrote:
Can we write/read a file in postgresql procedure ?
Using one of the "untrusted" languages, yes. They can only be used by an
administrator but have access to the full capabilities of the underlying
procedural language.
Of course, you will read and write files as the user
Am Donnerstag, 2. Juni 2005 11:36 schrieb Nageshwar Rao:
> Can we write/read a file in postgresql procedure ?
That depends on the language you use. PL/PerlU and PL/sh can do it, for
example, whereas plain PL/Perl or PL/pgSQL cannot.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
Dinesh Pandey wrote:
---+---+---
Column| Type
---+---+---
scan_id| bigint
host_ip| character varying(15)
port_num | integer
plugin_id | integer
I have to recommend pgEdit (nearly free and does have a nearly
fully-functional test version).
Sean
On Jun 2, 2005, at 3:57 AM, Rodríguez Rodríguez, Pere wrote:
Hello,
I'm writing a large store procedures (more than 700 lines) and I have
much problems to debug it. How can I debug it easily?
Hi,
I suppose the paralel work will be a problem if you are using one
sequence for all tables. If you insert a large amount of rows in
different tables there will be great slowdown because your sequence is
the bottle neck of your database. All the inserts must read from it one
by one. If you
Hi,
One of the columns in primary key is of
type “TEXT”. I am able to insert with small data, but for around
3000 characters it’s failing. How to handle that?
Thanks
Dinesh Pandey
From: Ramakrishnan
Muralidharan [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 02, 2005 3:11
Can we write/read a file in postgresql procedure ?
Hi,
The issue looks like your Index width exceeds the maximum width
of the index key limit,
Please review the keys used in the index.
Regards,
R.Muralidharan
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On
Behalf Of Din
i am trying to identify which tables should be moved to diff drives i first identified the most used tables... by looking at the data in pg_statio_user_tables.
and then i did sampling of the io-usage of these tables every 2 mins... to identify which are getting used when
but the probl
Hi,
if you define a SERIAL column postgresql's default is to generate a sequence
for each SERIAL column (table_column_seq). But you can use one sequence for
the whole database like this:
CREATE dbsequence;
CREATE TABLE one (
id int4 NOT NULL DEFAULT nextval('dbseq')
);
CREATE TABLE two (
id
Title: writting a large store procedure
I use EMS postgresql manager
2.8.0.3
- Original Message -
From:
Rodríguez Rodríguez,
Pere
To: pgsql-general@postgresql.org
Sent: Thursday, June 02, 2005 3:57
PM
Subject: [GENERAL] writting a
large store procedure
Title: writting a large store procedure
Hello,
I'm writing a large store procedures (more than 700 lines) and I have much problems to debug it. How can I debug it easily?
I use pgAdmin, is there another editor (free software) that permit write large store procedure more easily?
Thanks in
TABLE
---+---+---
Column | Type
---+---+---
scan_id | bigint
host_ip | character varying(15)
port_num | integer
plugin_id | integer
78 matches
Mail list logo
