Projects / PostgreSQL / Comments

RSS Comments for PostgreSQL

12 May 2009 01:51 jeffcovey

jberkus: Are they hurting something?

Thanks,
Jeff

12 May 2009 00:35 jberkus Thumbs up

Can we please purge the 7-year-old comments?

28 Feb 2009 17:20 simonbertrang Thumbs up

Re: "Object" Relational?

> Why do they call it "Object"
> relational? Where is the
> "object" part?

Because PostgreSQL supports table inheritance.

You might want to look at the corresponding page in the documentation: Data Definition - Inheritance (www.postgresql.org/doc...).

13 Dec 2007 05:47 brian54 Thumbs up

Re: Nice

>
> % Its nice and works really good but
> % sometimes its really work slow and
> % that’s create a real problem
> %
> % --
> % Web directory
>
>
>
> Yes its really very irritating when it
> work slow but overall its a good
> project.
>
> --
> Reiki
>



Its working fine for me I have got no problems....A great project.

--

WOW Gold (www.wow-gold-price-lis...)

18 Jul 2003 04:54 salukisaluki

"Object" Relational?
Why do they call it "Object" relational? Where is the "object" part?

08 Feb 2003 15:31 Avatar mariuz Thumbs up

Postgresql vs SapDB (aka gpl ADABAS D)
Anyone have a chart with the two ?
Have friend and He wants Oracle but after a talk i have told it
about Postgresql and the sister Firebird but he told me about
SAPdb how close (cloned) it is to oracle (He uses sap the application now ...) .Well i have watched some slashdot threads
and surprise i have found some links about unhappy people
but are removed from yahoo :( (groups.yahoo.com/group... the 909 message )
By the way love the replication stuff of the postgresql . I will
try to do something like that for firebird :) (gpl-ed)
And i don't know anything about Postgresql Clustering ...yet

30 Oct 2002 22:06 nconway Thumbs up

Re: PostgreSQL is a forkbomb...
This is incorrect, for several reasons. First, this specific example is not a fork bomb example -- if all a stored procedure does execute a query, another connection to the database is not made, and thus another process is not forked. While I suppose you could write a function using C that used libpq to open another DB connection, it would be pointless.

Second (and more importantly), trying to make a database secure if you allow users to execute arbitrary SQL is pointless (for example: disable the GEQO, execute a 20 table join query from 10 concurrent clients, and watch PostgreSQL eat up gigabytes of RAM and many minutes of CPU time). You simply cannot allow untrusted users to execute arbitrary SQL. It's even more dangerous to allow them to define functions; functions defined in C can trivially crash the backend. You might be able to get a modicum of security by using rlimit-style restrictions on the resources that PostgreSQL can use, but that's not a complete solution.

18 Jun 2002 17:48 phoemix Thumbs up

PostgreSQL is a forkbomb...
Try this: create a table, with an AFTER INSERT trigger on it. In the trigger procedure make a query into the database. Now, set postgres into debug level 2 or 3. every time your function runs, it connnects to the database. Postgres handles each connection in a separate process, so a new process is fork()-ed. now insert about 5000 rows into that table. notice the speed.
now install some forkbomb protection into your system(eg grsecurity), and for the test set the limit into a minimal value, 20 forks/second etc. Now insert 5000 rows again. notice the speed. It's a real forkbomb, yes.

Any comments?

04 May 2002 19:41 panserg Thumbs up

project description
I think it would make more sense to explain the difference between PostgreSQL and other databases, like MySQL and Oracle, than between current PostgreSQL and its archaic versions.

Or give the short list of unique features at least: tell about ACID, MVCC, WAL, what makes it work as a high-end database server as well as a backend of web-application servers.

14 Feb 2002 01:39 phoemix Thumbs up

User supporting and Documentation
I've been using PostgreSQL for over 6 month, and I've found it great according to it's knownladge. But every time when I want to do some non-basic things(findig information on built-in functions etc) I have to search 1) the included documentation 2) the web site 3) google.com for information about the topic, but in most cases I am unable to find enough informations, documantation or anything.

PostgreSQL is really great(but sometimes a little slow...), but it would need a better documentation. For example a complette reference for the built-in functions, aggregate functions and for the PgPL/SQL language

The developers also would have to concentrate on the speed of the DBMS, thus storec procedures written in PgPL/SQL are very slow. They are really.

Looking forward for your reply,

Screenshot

Project Spotlight

Opendedup

A deduplication-based filesystem for Windows and Linux (SDFS).

Screenshot

Project Spotlight

W3Perl

A server logfile statistic analysis program.