Hi,
someone gave me the tip to use the -F-flag to improve performance. Since
I can't run the postmaster with -F but just postgres how do I do it, if I
want to import a big amount of data?
Konstantin
--
Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: [EMAIL PROTECTED]
Otkerstr. 28,
(This was: "Re: [GENERAL] Re: PostgreSQL vs Oracle vs
DB2 vs MySQL - Which should I use?", but I think a new
thread has spun off...)
[Tom Lane said ...]
I agree we need to work harder on making answers
findable
outside the mailing lists. Improving the docs,
making the mail archives
more
[EMAIL PROTECTED] (Konstantinos Agouros) writes:
someone gave me the tip to use the -F-flag to improve performance. Since
I can't run the postmaster with -F but just postgres how do I do it, if I
want to import a big amount of data?
In 7.0.* (but not prior versions) it is safe to run
Hello,
I'm a bit new to postgres. Is there anyway to tell the current number of
connections on a database or server? I'm having a connection closing
problem and would like to debug it somehow. I know on Sybase you can check
a sys table to determine this. Not familiar with how to do this on
On 14 Feb 2001 11:57:47 -0500, Vince Vielhaber wrote:
On Wed, 14 Feb 2001, Bruce Momjian wrote:
I am not sure how many people have looked at my book on Amazon.com, but
I have received my first negative book review:
Ok, the type your looking for to auto create a sequence and increment by
one is called SERIAL (an int4 field). And yes, pgsql has oid's. Heres
what your table would look like with serial type's:
CREATE TABLE tablename (
item_idSERIAL,
name VARCHAR(10)
);
The serial type will
Hi,
is there a way to get statistuics from postgres, like the amount of
requests it handled, or the amount of connections it had the last 10 min.
Just curious so I can link it with Mysql.
May pg_statistics is the solution for my problem, but don;t get it atm.
ys,
--
-- Ramses Smeyers [EMAIL
If I create a table like
create table tablename (
aNuminteger not null,
namevarchar(10)
);
If I do select * from tablename;
q1. Is there such thing rowid similar to Oracle in PostgreSQL?
q2. How do I make aNum auto increment by 1? Need to write
a trigger? how to write that?
I want to
create table vals (
x float,
y float
);
insert into vals values (2,4);
insert into vals values (2,2);
insert into vals values (2,1);
insert into vals values (2,0);
select x/y from vals where y0 and x/y1;
will give a divide by zero error as A=(y0) and B=(x/y1) can be evaluated in
any order (A
Can you EXPLAIN that query and send us the results (the query plan)? That
should tell a whole lot.
-Mitch
- Original Message -
From: "Dave Edmondson" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, February 16, 2001 1:32 PM
Subject: Postgres slowdown on large table joins
I'm
I'm having a problem here. I'm using Postgres 7.0.3 on a FreeBSD 4.2-RELEASE
machine... it's a Pentium II/450 w/ 128MB of RAM (not nearly enough, but
there'll be an upgrade soon). Anyway, I have a data table, which currently
has around 146,000 entries, though it will grow to a few million
You didn't mention what version of Postgres, but in 7.1beta, you could do
the following (pretty sure on the syntax):
SELECT a.x/b.y FROM vals a, (SELECT y FROM vals WHERE y 0) b WHERE (a.x
/ b.y) 1;
In anything else, you could try a view:
CREATE VIEW valid_vals AS SELECT y FROM vals WHERE y
Hello,
I'm a bit new to postgres. Is there anyway to tell the current number of
connections on a database or server? I'm having a connection closing
problem and would like to debug it somehow. I know on Sybase you can
check
a sys table to determine this. Not familiar with how to do
hi. i was wondering how to go about creating an assertion to be used within a
pl/sql function.
do i put
create assertion assertion name
check ...
before or after "begin"?
thanks
--
-leon (in the dungeon of EUII @ UC Davis)
On Thu, 15 Feb 2001, Michael Fork wrote:
Indexes *can* and *will* be used if you create the appropiate
functional indexes, i.e:
CREATE INDEX idx_table_field_upper ON table(upper(field));
SELECT field FROM table WHERE upper(field) LIKE upper('some string');
Hmmm...I'd hate to have two
Looking for an open source web development tool that supports commercial as
well as open source databases? Check out http://www.openbedrock.org
sqlconnect
table
sqlselect "select * from customers"
tr
tdvar $name/td
tdvar $address/td
tdvar $phone/td
/tr
/sqlselect
/table
I have tried the function gethostbyname(text), which should return an inet value
or reference. However, it gave me something like unprintable
sql#= select gethostbyname('www.postgres.org');
Anyone got any clue?
Phillip Pan
---
Title: Question
Does this run on Windows NT or 2000.
Hmmm...I'd hate to have two indexes on every field I query like this, one
case-senstive, one case-insensitve (like the one you create here). Is
there a configuration option or something that will tell pgsql to do
case-insensitive comparisons (kinda like MS SQL Server has)? That could
save us
On Thu, 15 Feb 2001, Michael Fork wrote:
Indexes *can* and *will* be used if you create the appropiate
functional indexes, i.e:
CREATE INDEX idx_table_field_upper ON table(upper(field));
SELECT field FROM table WHERE upper(field) LIKE upper('some string');
Hmmm...I'd hate to
Patrick Welche [EMAIL PROTECTED] writes:
select x/y from vals where y0 and x/y1;
will give a divide by zero error as A=(y0) and B=(x/y1) can be evaluated in
any order (A and B = B and A). I obviously would like (y0) to happen first,
but I don't see how this can be achieved.. Any ideas?
Of
Hi,
What exactly does vacuumdb do? In what way does it 'clean' the db?
Also what are the best ways to optimise a pg databaseThanks,
Jonathan Daniels
Hello,
I am putting together a web site to display a collection of Chinese
woodblock prints. I want to be able to store double byte values (that is
to say Big5, Unicode etc encoded) in a text field for things such as the
artist's name and the title of the print. I have the following questions:
: SELECT a.x/b.y FROM vals a, (SELECT y FROM vals WHERE y 0) b WHERE (a.x
: / b.y) 1;
How much of a performance hit is there when using a select in the FROM
clause? Is it even noticeable? How much better is it to create a static
view?
-Dan
Hi.
I have a problem getting postgresql to work on my Debian 2.2 system, and
i hope someone in this group can help me.
I have successfully compiled, installed and used postgresql 7.02 on a
RedHat6.2 system.
The problem is the same for postgresql 7.02 and 7.03 on two different
computers, both
In psql, gethostbyname() is defined as taking a text parameter and return an
inet type value or reference.
However, if you do
psql=# select gethostbyname('www.postgres.org');
gethostbyname
---
unprintable
(1 row)
the inet address will be unprintable.
Has anyone got any idea?
help
Hi,
It would work fine to have a web interface in case the
application could be developed with that... In fact,
we had started working on the project with PG and Java
Servlets et al... However, we ran into problems after
a month of designing and actual implementaiton work
was over only
Hello!!
I need demostrate that PostgreSQL is a great RDBMS for my undergraduate
project, because this, Does somebody has a bechmark (or similar
document) between Postgres and others DB (commercial DB's, principally)
Thanks in advance!!
On Fri, 16 Feb 2001, Bruce Momjian wrote:
Yes, our CREATE INDEX lower(col) already does that, but you do have to
use lower(col) when doing the query.
Right, that's what I'm suggesting a configuration that automates the
lower(col) bit in CREATE INDEX and that automates the lower(col) in
Hello!!
I need demostrate that PostgreSQL is a great RDBMS for my undergraduate
project, because this, Does somebody has a bechmark (or similar
document) between Postgres and others DB (commercial DB's, principally)?
Thanks in advance!!
You should have a look at the wiki stuff
http://c2.com/cgi/wiki?WikiWikiWeb
Dave
- Original Message -
From: "Richard" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, February 16, 2001 12:40 PM
Subject: [GENERAL] Annotatable on-line documentation
(This was: "Re: [GENERAL] Re:
... I wonder whether this is an inbuilt,
unavoidable problem with free software projects once they reach a certain
level of popularity.
Funny you should mention PHP. I talked to Rasmus about the email volume
when I first met him in the fall. He said the volume of email is so
great
The license agreements of many commercial DBs forbid licensees from
publishing benchmarks of their software.
What is your undergraduate project? More details could help, anyway most of
the popular RDBMS features are in Postgresql.
I'd figure Postgresql is one of the best RDBMSes to use for an
I'm willing to do some writing if someone will explain things to me.
I've pretty much disected all the sql used by Rserv.pm to see what it
does so I've got a decent head start.
The two questions that are holding me up at this point are:
1. which column do you specify for setting up the
I am putting together a web site to display a collection of Chinese
woodblock prints. I want to be able to store double byte values (that is
to say Big5, Unicode etc encoded) in a text field for things such as the
artist's name and the title of the print. I have the following questions:
Is
In [EMAIL PROTECTED] [EMAIL PROTECTED] (Tom Lane) writes:
[EMAIL PROTECTED] (Konstantinos Agouros) writes:
someone gave me the tip to use the -F-flag to improve performance. Since
I can't run the postmaster with -F but just postgres how do I do it, if I
want to import a big amount of data?
[EMAIL PROTECTED] (Konstantinos Agouros) writes:
export PGOPTIONS="-F"
psql mydb
A O thanks for the help I was confused. Does this also work
that way, if I use it from DBI::Pg from perl? Like setting
$ENV{'PGOPTIONS'}
Yeah, I think that should work if you do it before opening a
HI tom
A few days back i had bugged this list about the seemingly impossible
select queries results..
##RECAP##
select distinct site_section as "distinct site sections" from
exhibit_distributions ;
distinct site sections
ARCHIVED
ARTETC
CALENDAR
GALLERY
POSTCARD
(5
Hi,
In the documentation there is this page about partial indicies:
http://postgresql.planetmirror.com/devel-corner/docs/user/partial-index.htm
From my reading of that I would guess they are supported but since they
aren't mentioned anywhere else, I guess they're not.
Can somone clarify the
Are you referring to short circuit? That's a language feature, isn't it? I
didn't think it had anything to do with the compiler (I know C and a few
other languages do it). Anyway, I could be wrong.. Seems that could break a
lot of code if the programmer relies on short circuit in some conditional
will give a divide by zero error as A=(y0) and B=(x/y1) can be
evaluated in
any order (A and B = B and A). I obviously would like (y0) to happen
first,
but I don't see how this can be achieved.. Any ideas?
I have one idea that would be nifty to implement. In some compilers, you
can turn
Bruce Momjian wrote:
Interesting. I think GIST itself may be too specific for a talk.
However, type extensibility would be very interesting.
As it turns out, there are just two am's one will most likely build
new types upon: btree and GiST. A useful tutorial should include
examples of both,
Now you know the answer; for some resources of how to do it try taking a
look at:
http://people.freebsd.org/~kevlo/postgres/portNT.html
It is pretty similar to the official windows install docs:
http://www.postgresql.org/docs/faq-mswin
Or, for a more automated install check out:
Tom Lane [EMAIL PROTECTED] writes:
[EMAIL PROTECTED] (Konstantinos Agouros) writes:
export PGOPTIONS="-F"
psql mydb
A O thanks for the help I was confused. Does this also work
that way, if I use it from DBI::Pg from perl? Like setting
$ENV{'PGOPTIONS'}
Yeah, I think that
I believe that first number is oid.
Jie LIANG
St. Bernard Software
Internet Products Inc.
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873
[EMAIL PROTECTED]
www.stbernard.com
www.ipinc.com
On Thu, 15 Feb 2001, Richard Huxton wrote:
From: "Jean-Arthur Silve"
Martijn van Oosterhout [EMAIL PROTECTED] writes:
In the documentation there is this page about partial indicies:
http://postgresql.planetmirror.com/devel-corner/docs/user/partial-index.htm
From my reading of that I would guess they are supported but since they
aren't mentioned anywhere else,
46 matches
Mail list logo