On Jan 26, 4:52 pm, Rodrigo E. De León Plicet rdele...@gmail.com
wrote:
Quote:
==
This thread
http://postgresql.1045698.n5.nabble.com/Multithread-Query-Planner-td5...
was mentioned in a performance sub-group posting. Give
Quote:
==
This thread
http://postgresql.1045698.n5.nabble.com/Multithread-Query-Planner-td5143643.html
was mentioned in a performance sub-group posting. Give it a read.
Back? It means, so far as I can see, that PG is toast.
http://www.dbms2.com/2011/11/23/hope-for-a-new-postgresql-era/
Some of the points mentioned:
- MySQL is narrowing the gap, but PostgreSQL is still ahead of MySQL
in some ways. (Database extensibility if nothing else.)
- Neither EnterpriseDB (which now calls itself “The enterprise
PostgreSQL
Here:
http://cglendenningoracle.blogspot.com/2011/06/oracle-vs-postgres-postgresql.html
Any comments?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, Oct 11, 2010 at 6:57 PM, David Boreham david_l...@boreham.org wrote:
http://www.xtranormal.com/watch/6995033/
(warning: may not be sfw).
ROFLMAO!!!
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On Mon, Aug 9, 2010 at 1:39 PM, samantha sjatk...@mac.com wrote:
I have been digging into NoSQL of late (...)
Be wary of DBAs Running with Scissors...
http://www.pgcon.org/2010/schedule/attachments/141_PostgreSQL-and-NoSQL.pdf
--
Sent via pgsql-general mailing list
On Fri, May 22, 2009 at 10:38 PM, Scott Marlowe scott.marl...@gmail.com wrote:
On Fri, May 22, 2009 at 4:10 PM, Benjamin Smith
li...@benjamindsmith.com wrote:
Is there a better way?
Yeah, natural keys.
+1.
Also, what Ben described reeks of EAV.
Ben, please read:
2009/2/20 Angelo Astorga angeloasto...@gmail.com:
Tenia RH enterprise 3.0 con postgresql 7.4.3 y PHP 4.3.2, migre todo a RH
enterprise 5.3 con postgresql 8.1.11 y PHP 5.1.6, migre la BD y pude
montarla, pero, no tengo acceso a la BD desde apache... algun ayudita al
respecto !!!
Demasiado
On Wed, Jan 21, 2009 at 5:44 PM, Keaton Adams kad...@mxlogic.com wrote:
Is there a way to do this in a single SQL statement in PostgreSQL 8.1?
SELECT
d.policyNumber
, d.CompanyName
, d.Address
, p.AllPolicyNumbersIncluded
FROM PolicyPrint p
INNER JOIN PolicyDetails d
ON (
On Wed, Nov 26, 2008 at 3:36 PM, Karina Guardado [EMAIL PROTECTED] wrote:
I have a problem I have created a database with encoding SQL_ASCII and when
I insert the data using a terminal in linux and insert the data for example
Insert into mytable values(1,'Eléctrico'); it works fine but if I try
On Wed, Nov 19, 2008 at 10:03 PM, novice [EMAIL PROTECTED] wrote:
sorry I get nothing :(
Of course not. None of the dates you gave in the example overlap.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On Sun, Oct 12, 2008 at 8:10 PM, Ben Chobot [EMAIL PROTECTED] wrote:
On Oct 12, 2008, at 5:51 PM, Martin Gainty wrote:
could you provide a brief explanation of EAV ?
(...) in an EAV model you would do something like:
create table eav
(
kind text primary key,
attr text,
value text
);
On Wed, Sep 17, 2008 at 9:43 AM, Ivan Sergio Borgonovo
[EMAIL PROTECTED] wrote:
The subjects says it all.
A couple of links that may be of use:
http://pooteeweet.org/files/phpworks06/explaining_explain.pdf
http://redivi.com/~bob/oscon2005_pgsql_pdf/OSCON_Explaining_Explain_Public.pdf
Good
On Tue, Aug 26, 2008 at 2:41 AM, Ivan Price [EMAIL PROTECTED] wrote:
If anyone knows of such a thing i'd greatly appreciate some advice..
Gedafe - http://isg.ee.ethz.ch/tools/gedafe/index.en.html
DaDaBIK - http://www.dadabik.org/
Good luck.
--
Sent via pgsql-general mailing list
On Sat, Aug 2, 2008 at 9:14 AM, johnf [EMAIL PROTECTED] wrote:
I wonder if he talking about pgadmin3? It's on the menu.
Only J.M. knows for sure...
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On Fri, Jul 25, 2008 at 8:35 AM, Bruno Lavoie [EMAIL PROTECTED] wrote:
The hesitation here is : how to store the fields values pairs, in
FIELDS_VALUES?
Check out contrib/hstore:
http://www.postgresql.org/docs/current/static/hstore.html
--
Sent via pgsql-general mailing list
On Tue, Jul 22, 2008 at 5:36 AM, Brandon Metcalf [EMAIL PROTECTED] wrote:
I've been able to find a couple of packages, but wondering if there is
a good system out there what will create an ER diagram of an existing
PostgreSQL DB. Open source would be nice.
PostgreSQL Autodoc:
On Mon, Jun 23, 2008 at 2:45 PM, Kynn Jones [EMAIL PROTECTED] wrote:
Actually, the DB I have in mind would certainly be approaching silly
territory. I'm looking at a schema with around 10 thousand tables (or
views).
What kind of app would require such a schema? Just curious...
--
Sent via
On Thu, Apr 10, 2008 at 10:26 PM, kevin kempter
[EMAIL PROTECTED] wrote:
However I'm stumped [er how to get the number of months from 09/01/2007
thru 01/01/2007
select extract(month from (age(date '2007-1-1', date '2006-9-1')));
--
Sent via pgsql-general mailing list
On Thu, Apr 3, 2008 at 11:50 AM, William Temperley
[EMAIL PROTECTED] wrote:
This works very well, however I'm currently directly concatenating a sql
query:
select st_collect(the_geom) from tiles where tilename in
(comma delimited list))
Which leaves my application vulnerable to sql
On Wed, Apr 2, 2008 at 12:36 PM, Alex Solovey [EMAIL PROTECTED] wrote:
... I have no idea how it could be fixed.
- CREATE INDEX xifoo ON foo(bar_id);
- ANALYZE;
- Retry.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Also important, consider creating additional indexes based on your
access patterns.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wed, Apr 2, 2008 at 1:20 PM, Alex Solovey [EMAIL PROTECTED] wrote:
In this simple (which means reduced) test database, yes. But the actual
table foo in production database:
1. partitioned, with 50+ partitions
2. heavily updated (and indexes make it slow)
3. has more fields like bar_id
On 3/21/08, Gauthier, Dave [EMAIL PROTECTED] wrote:
I can do it in a formal declaration of a procedure, and then execute the
procedure. But is there a less formal way?
No. There are no anonymous blocks in PostgreSQL.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
On Tue, Mar 18, 2008 at 9:00 AM, Dan Searle [EMAIL PROTECTED] wrote:
I've racked my brain about this but can't think of a simple solution,
even though this appears to be a simple problem, any suggestions much
appreciated.
Your fact is split across more than one row.
I recommend that you
On Tue, Feb 26, 2008 at 3:51 PM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
As discussed earlier I can't use dump/dumpall since my data needs
persistent tableoids which, however, are not the same after a restore.
What about the workarounds / refactoring tips proposed in previous discussions?
On 2/23/08, dvanatta [EMAIL PROTECTED] wrote:
How should this function be written?
Define output parameters in the function and return SETOF RECORD, e.g.:
--- SQL ---
CREATE OR REPLACE FUNCTION
GET_FOO1(BAR INT, OUT BAZ INT, OUT ZAB INT)
RETURNS SETOF RECORD AS
$BODY$
SELECT $1, $1;
$BODY$
On Jan 31, 2008 8:49 AM, Enrico Sirola [EMAIL PROTECTED] wrote:
I'd create a previousTime column and manage it using a trigger.
Anyway, it depends on the time-dependancy of the table
Then you can perform temporal in a much easier way.
You could be interested in taking a look at the following
On Jan 12, 2008 5:22 PM, Sergei Shelukhin [EMAIL PROTECTED] wrote:
Hi.
I was wondering if I could do something similar to this in Postgres and
if yes how?
UPDATE table1 SET blah = 1 FROM table1
INNER JOIN table2 ON table1.id = table2.t1id
UPDATE table1 t1
SET blah = 1
FROM table2 t2
On Jan 13, 2008 12:05 AM, I said
It's all in the docs:
http://www.postgresql.org/docs/8.2/static/sql-update.html
To clarify, you can use the direct form, without using a subselect:
UPDATE table1 t1
SET blah = 1
FROM table2 t2
JOIN table3 t3
ON t2.id = t3.t2id
WHERE t1.id = t2.t1id
Lookup
On Jan 12, 2008 11:26 PM, Sergei Shelukhin [EMAIL PROTECTED] wrote:
Hmmm. What if there's more than one table? Is from x,y a viable option?
UPDATE table1 t1
SET blah = 1
FROM (
SELECT t2.t1id
FROM table2 t2
JOIN table3 t3
ON t2.id = t3.t2id
) foobar
WHERE t1.id = foobar.t1id
It's all in
On Jan 8, 2008 7:36 PM, Joshua D. Drake [EMAIL PROTECTED] wrote:
There is no other open source database that can compare with
PostgreSQL's extensibility, reliability and scalability.
+1000
---(end of broadcast)---
TIP 5: don't forget to increase
32 matches
Mail list logo