"Livio Righetti" wrote:
>Hi,
>
>Talking about insert, I know Mysql is fast than Postgresql.
>
>I've made the following test :
>
>40'000 insert (accouting context) using Perl and dbd :
>
>Postgresql :
> text : 4 min 53 s
> varchar : 4 min 49 s
> char : 4 min
On Fri, Apr 06, 2001 at 10:56:43AM +0200, Al wrote:
> Hi all. I have a problem understanding/using PostgreSQL as a multiuser
> database.
> I have a simple table with a number of different IDs (int8) used for
> different activities.
> It should be possible for any number of simultaneous users to re
Hi all,
Is it just my route to the main webserver, or is the website at
www.postgresql.org down?
Can access the mirrors, but can't touch anything at the main PostgreSQL
website.
Rats, wanted to submit results of 7.1RC3 to Vince's database...
Regards and best wishes,
Justin Clift
On Tue, 3 Apr 2001, Kevin Willems wrote:
> I wrote the following test function:
>
> CREATE FUNCTION tester(text)
> RETURNS text
> AS 'DECLARE
>str text;
> BEGIN
>str := upper($1);
>RETURN str;
> END;'
> LANGUAGE'plpgsql'
>
> This runs OK. However, when I go to use it as follows:
>
"mike" wrote:
>is there a way to reindex a sequence?
>if so how and is it in the curent docs?
If you wish to reset its value, the function is setval().
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
"Alastair D'Silva" wrote:
>I am using PostgreSQL 7.0.3 and have the following schema:
>
>CREATE TABLE "products" (
...
>There are various other tables inheriting from "products".
...
>There is also another table which references products:
...
>Now, if I insert a row into one of "produ
"Thomas F. O'Connell" wrote:
>test_db=# create table foo( id int2 primary key );
>NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'foo_pkey'
>for table 'foo'
>CREATE
>test_db=# create table sub_foo() inherits( foo );
>CREATE
>test_db=# create table bar( sub_foo_id int2
I've a table containing some sort of logs, the table layout ist:
Attribute | Type | Modifier
---+--+---
id| integer | not null default nextval('ids'::text)
serverid |
On Fri, Apr 06, 2001 at 06:57:03PM +0530, Atul wrote:
> Hi,
>
> I have a query regarding composite types (user-defined types). I have
> defined a type alongwith its input and output functions. But I am not
> able to access the type using my PL/pgSQL function. My type is as
> follows
>
> typedef
On Sun, Apr 08, 2001 at 01:04:16PM +0800, Alastair D'Silva wrote:
> I am using PostgreSQL 7.0.3 and have the following schema:
>
> CREATE TABLE "products" (
> "id" SERIAL NOT NULL PRIMARY KEY,
> "name" text NOT NULL,
> "description" text NOT NULL,
> "brand" text NO
On Wed, 4 Apr 2001, roy cabaniss wrote:
> I am in the process of converting from php3 to php4 and at the same time
> going from mysql to postgres.
>
> All the relevent files reside in
>
> ../foo/bar
>
> And the vast majority are in the form *.php3 with internal references to
> other webpages
Hello,
> Just finished reading all of the comments at
>
> http://openacs.org/philosophy/why-not-mysql.html
>
> and became concerned about the comments regarding severe memory leaks with
> PostgreSQL. Is this true? Have they been fixed? Are there any
> workarounds?
There are some still. Althou
On Tue, 3 Apr 2001, Nick T wrote:
> Howdy all:
>
> I'm brand new to postgresql, so don't beat me too severely about the head
> and shoulders over this question.
>
> I see that we can add users and delete or drop users. As the database
> administrator, I'd like to be able to view all of the use
On Tue, 3 Apr 2001, Livio Righetti wrote:
> Hi,
>
> Talking about insert, I know Mysql is fast than Postgresql.
>
> I've made the following test :
>
> 40'000 insert (accouting context) using Perl and dbd :
>
> Postgresql :
> text : 4 min 53 s
> varchar : 4 min 49 s
> char :
Nick T writes:
> Just finished reading all of the comments at
>
> http://openacs.org/philosophy/why-not-mysql.html
>
> and became concerned about the comments regarding severe memory leaks with
> PostgreSQL. Is this true? Have they been fixed? Are there any
> workarounds?
There are certain qu
Joel Burton writes:
> I started writing a 'Features+' document a few months ago, but it got sat
> aside during a busy work time. I'd like to restart that work.
>
> I don't want to recreate the manuals -- I envision something like a 5-page
> 'product datasheet' that explains just enough about what
Mario Weilguni writes:
> Now when I type:
> explain select min(id)from log;
> NOTICE: QUERY PLAN:
>
> Aggregate (cost=45702.20..45702.20 rows=1 width=4)
> -> Seq Scan on log (cost=0.00..41978.36 rows=1489536 width=4)
>
> I don't understand why the index log_pkey is not used here. I guess it
On Saturday, April, 2001-04-07 at 23:04:23, Doug McNaught wrote:
> Marek Pętlicki <[EMAIL PROTECTED]> writes:
>
> > Hi!
> >
> > I've got a question: has anybody noticed in your production
> > tables, that updates on existing rows take longer than inserts
> > into those same tables?
>
> Standard
Hi Joel,
Since you've got a 5 page document already, maybe you'd like to put what
you've got on the net somewhere (I can put it on techdocs.postgresql.org
if you'd like), then massage it into shape for an updated 2 page intro
Peter is suggesting?
Don't want to lose 3 pages of what may just be re
Great! You guys do it and I'll put it on the website.
Vince.
On Sun, 8 Apr 2001, Bruce Momjian wrote:
> Sounds great.
>
> I have collected some comments from people about PostgreSQL vs. other
> databases at:
>
> ftp://candle.pha.pa.us/pub/postgresql/comparison.mbox
>
> This may help.
Ok, so here's the draft I wrote a few months ago up the updated features
document.
--
pg_advocates of the world, unite!
As I've recommended it to other people, I've found myself at a loss to
explain all of
the features that recommend the system. Digging around, almost all of
these can be
iden
It's back.
Vince.
On Sun, 8 Apr 2001, Justin Clift wrote:
> Hi all,
>
> Is it just my route to the main webserver, or is the website at
> www.postgresql.org down?
>
> Can access the mirrors, but can't touch anything at the main PostgreSQL
> website.
>
> Rats, wanted to submit results of 7.1RC3
22 matches
Mail list logo