Hi,
Konstantinos Agouros schrieb:
>
> When I insert I do something like $dbh->{'AutoCommit'} = 0 and every 100,000
> entries or so I do a commit.
try to make the commit every 500 or 1000 inserts. It seems to me, that
PG slow down if there are lots of MBs waiting for commit ...
And also try to
Hi,
Me and others are planning to move PG to ISO19100 compliance. ISO19100 is
the future standard that is describing GIS systems.
If you visit FMaps.sourceforge.net and go in the CVS you will see in the
directory /src/geoobj/ procedures to add geographic data types to PG. These
procedures need
> try to make the commit every 500 or 1000 inserts. It seems to me, that
> PG slow down if there are lots of MBs waiting for commit ...
MB == Memory Buffers?
If so then it shouldn't be the case for 7.0.X with Tom' work in bufmgr area.
Vadim
Hi,
> > try to make the commit every 500 or 1000 inserts. It seems to me, that
> > PG slow down if there are lots of MBs waiting for commit ...
>
> MB == Memory Buffers?
> If so then it shouldn't be the case for 7.0.X with Tom' work in bufmgr area.
Megabytes :-)
tested in 7.1
The inserts slo
> However the result was (running on 64bit Sol 7, E250/1Gig
> RAM) that Oracle was roughly twice as fast. Is this real
> or might there be stuff I could do, to improve postgres performance?
PostgreSQL version?
You didn't use -F, did you?
Vadim
Camm Maguire <[EMAIL PROTECTED]> writes:
> Greetings! Just read that this functionality is planned for the
> future. Can 7.1 have cursors in pgsql functions, for example?
No, it can't.
I have a patch which adds support for cursors in PL/pgSQL. If anybody
is interested, I can provide that pat
Hi,
today I did my first test with Oracle instead of PG (I had to really the boss
wanted it \:).
I have some perl-scripts using DBI, that insert a large amount of data, reduce
it and then create some report.
When I insert I do something like $dbh->{'AutoCommit'} = 0 and every 100,000
entries or s
[ Charset ISO-8859-1 unsupported, converting... ]
> Hi Doug, your comments caught my eye and I thought I'd ask you something..
> Are you speaking of using persistant connections with PHP? I'm not sure what
> Enhydra is, so forgive me if this is totally off base..
>
> We do a lot of development in
I wrote a plpgsql function/stored procedure to get around this problem.
I am not sure specifically what information you need about the row
after INSERT, but you could write a function that performs the INSERTs
and summing. After the initial INSERT you can use a SELECT INTO
statement to pass
We know we need to change INSERT rules to fire after the command.
Hopefully this will be done in 7.2.
> I read at the docs that rules are executed before the query that
> generated them. Is there any way to change this?
>
> Here's my problem: I have two tables, A and B, and after an INSERT on
>
I would like to know if there is a way to return nTuples for a cursor
without having to FETCH ALL from the cursor. I am sorting over 500k
records and growing.. and return 1k at time from the cursor. But, It I
also need to obtain the total number of records in the cursor without
having to eit
Hello everybody,
We are trying to migrate an application from MySQL to PostgreSQL, and all
works fine except for a text based search we must do.
In MySQL we can run the next SQL sentence:
SELECT *, MATCH a,b AGAINST ('sample text') as x FROM t;
and it returns th
Hi,
I have managed to change the length of a varchar field to 100 using:
update pg_attribute set atttypmod = 104 where attname = 'field_name' and
attrelid = (select oid from pg_class where relname = 'table_name');
I was wondering if I can do something similar to change the size of a
numeric fie
Greetings! Just read that this functionality is planned for the
future. Can 7.1 have cursors in pgsql functions, for example?
Take care,
--
Camm Maguire[EMAIL PROTECTED]
==
"The
http://www.borland.com/kylix/
I'm assuming this is Delphi, correct? The page says about dbExpress drivers
for several databases (MySQL being one of them). How does this package
interact with postgres?
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
How can i retrive the IP address of a user connected to database?
Please, help me.
Thanks
Gianfranco Masia
Hello,
I have just updated to 7.0 and have observed the following:
When the system boots, and Postgres is attempting to
start, I get the following error: 564, unary operator expected.
Yet after boot, I can see that postmaster is running and I
can connect to it with my application.
[root@Be
Hello PG's,
I am trying to use the Perl module for Postgresql, but when I start
a simple example like this:
#!/usr/local/bin/perl -w
use Pg;
$conn = Pg::connectdb("dbname=template1");
die $conn->errorMessage unless PGRES_CONNECTION_OK eq $conn->status;
$result = $conn->exec("select tablename
On Wed, Jan 31, 2001 at 07:34:51PM -0500, Brett W. McCoy wrote:
> On Wed, 31 Jan 2001, Dan Wilson wrote:
>
> > I wouldn't call PHP a subset of Perl at all! I'd call them sibling
> > languages with different strengths. I think Perl does certain things better
> > than PHP but PHP has strengths th
On Wed, Jan 31, 2001 at 12:15:49PM -0500, Doug McNaught wrote:
>
> As for whether it will be done, well, what does PHP give you over
> Perl? I know Perl well and PHP AFAICS is a tiny subset of Perl
> designed to be embedded in web pages. Given PL/Perl, do we really
> need PL/PHP?
PHP is a tiny
Jeff wrote:
>It is still strange though that I get different behavior
>from the exact same source when built on two different
>computers. I installed 7.0.2 on my laptop and I get an
>interactive prompt ">". On my linux box I installed 7.0.2
>and I get a "#" as the last character in the
On Wed, Jan 31, 2001 at 11:27:18PM +, Oliver Elphick wrote:
> Adam Haberlach wrote:
> >I'm trying to back up a database, including the user records. If
> >I use pg_dump, I can get the table, but I cannot seem to be the user
> >information.
>
> pg_dump -d database >dump
>
> s
Quoting elein <[EMAIL PROTECTED]>:
Redirecting to the jdbc list...
>
> I'm a Java novice and I would like to be able to
> use JDBC to get Points and Paths into a Java
> program as native Java objects. Note that the
> binary form of Paths is more than a simple array.
>
> I know how to do thi
23 matches
Mail list logo