> You may find that the PGQ component of skytools is what you want:
> http://pgfoundry.org/projects/skytools
> http://skytools.projects.postgresql.org/doc/
> http://skytools.projects.postgresql.org/doc/pgq-sql.html
>
Thanks, we will look into it. Still, I am surprised to learn that SQL as such
Hi all.
This may be trivial, but I cannot find good references for it. The problem is
this:
Suppose we have one table in PgSQL which is a job queue, each row represents
one job with several status flags, IDs,... Several processes will attempt to
access the queue and "take" their batch of jobs,
Still, this sounds dangerous. It should be, even legally, WRONG to patent
something that already exist and was not invented by the patentee. I know we
can laugh off MS in court, but what about new DBs or project even built on PG
that have this functionality? Software patents are a menace, I'm af
> 1. There is no difference (speed-wise) between committing every 1K or every
> 250K rows.
It was really some time ago, since I have experimented with this. My las
experiment was on PG 7.2 or 7.3. I was inserting cca 800,000 rows. Inserting
without transactions took 25 hrs. Inserting with 10,00
> The fastest way will be copy.
> The second fastest will be multi value inserts in batches.. eg.;
>
> INSERT INTO data_archive values () () () (I don't knwo what the max is)
>
> but commit every 1000 inserts or so.
Is this some empirical value? Can someone give heuristics as to how to
calculate
Premsun Choltanwanich wrote:
Dear All,
I need to distribute my application that use PostgreSQL as
database to my customer. But I still have some questions in my mind on
database security. I understand that everybody who get my application
database will be have a full control permissio
Hi all.
I have the following:
- Mandrake Linux 9.1
- PostgreSQL 7.3.2 MDK5
There is one DB and one DB user. The DB is cleared and loaded with the
data of same volume each month (monthly report). The volume is not small
and it usually takes 3 hours to load. Loading is done with SQL files
which us
Hi all.
I've managed to get 8.0.0 up and running. Now I'm compiling some
contributed software and I hit a show stopper. Contrib - DBSize
Papa-Legba:/home/r/root/5.1/postgresql-8.0.0beta1/contrib/dbsize# gmake
; gmake install
sed 's,MODULE_PATHNAME,$libdir/dbsize,g' dbsize.sql.in >dbsize.sql
cc -
Hi all.
Ran into a minor showstopper. Sometimes, my CC is just too much of a
nitpick, but on this matter, I agree with it. "./src/timezone/zic.c" has
a mismatch in declaration and definition of "memcheck(...)" function. My
CC beltched on it (I was running it in strict ANSI mode). The diference
Tom Lane wrote:
Nikola Milutinovic <[EMAIL PROTECTED]> writes:
[ about NaN on Tru64 ]
This compiles on Tru64 4.0D (the compiler swallows it), but fails on
Tru64 UNIX 5.1B. Both basic CC and DTK Compaq CC break on that file
complaining on that constant evaluation. The best way to solve it
Nikola Milutinovic wrote:
+ #define NAN DBL_INFINITY
The compilation has went smoothly, I'll try to run regression tests.
Will let you know if something fails.
Hate to reply to myself, but here goes.
With NAN defined as "DBL_INFINITY" I get 3 failed regression test, most
notabl
Hi all.
OS: Tru64 UNIX 4.0d
PG: PostgreSQL v7.4.1
PY: Python v2.3.3
I just ran into a minor bug while compiling
PL/Python module. It bombed out on lines 153 and 160 of
./src/pl/plpython/plpython.c complaining on incomplete type
"PyObject_HEAD".
The source of the problem were these two
Hi all.
This is off topic and is a cross-post, so I'll be
brief. There is a very nasty virus out there and I urge everybody to get their
AV in order. The virus is known as: "W32.Gibe-F"
or "W32.Swen-A".
Yesterday, I got cca. 200 viral
messages.
Today, it's about 800 viral messages!
I
> This may have been better posted in the advocacy list but I am not a
> subscriber.
>
> We recently purchased Dreamweaver MX and I was a little surprised to
> find that one of its pre-defined scripting systems is PHP + MySQL. I
> haven't done much exploring of what is actually offered but wondered
Hi all.
Maybe this is not such a novice question, but I'm having problem subscribin to some
more "professional" PG lists. Here goes...
I'm trying to make a function in PostgreSQL v7.0. Right now, I'm bugging
with PL/PgSQL and SQL functions.
What I want to achieve is: "insert new row in a table
15 matches
Mail list logo
