You wrote that either it is not implemented well (catastrophic data losss) or is
expensive (Oracle) or it is a monopoly (MSSQL). None of those are easy.
Expensive and monopoly don't seem to me to be non-easy, rather undesirable if
you don't need to get into it.
When someone asks a question abou
On Jan 8, 2008 11:21 PM, x asasaxax <[EMAIL PROTECTED]> wrote:
> Hi everyone,
>
>I´m trying to undestand how to do select with xml path.
First of all, what is your Postgres version? 8.3 with xml support or
older one with conrib/xml2?
In case of 8.3, you can find some examples in current docs:
Ow Mun Heng wrote:
On Tue, 2008-01-08 at 23:05 -0800, Joshua D. Drake wrote:
Sim Zacks wrote:
The reason companies go with the closed source, expensive solutions is
because they are better products.
Sometimes, sometimes not. It depends on your needs.
This is total FUD. Everything has a pla
On Wed, 2008-01-09 at 00:24 -0700, Guido Neitzer wrote:
> On 09.01.2008, at 00:14, Ow Mun Heng wrote:
>
> >> Like, I have a situation where I need multi-master just for
> >> availability. Two small servers are good enough for that. But
> >> unfortunately with PostgreSQL the whole setup is a major
On Wed, 2008-01-09 at 00:21 -0700, Guido Neitzer wrote:
> On 09.01.2008, at 00:08, Joshua D. Drake wrote:
> > Great! I was just trying to show you that there was a JDBC layer
> > available for multi-mastering with PostgreSQL.
>
> When I find some time, I might dig a bit deeper in the Sequoia s
On 09.01.2008, at 00:14, Ow Mun Heng wrote:
Like, I have a situation where I need multi-master just for
availability. Two small servers are good enough for that. But
unfortunately with PostgreSQL the whole setup is a major pain in
the ...
Isn't that the reason they hire DB admins and not t
On Tue, 2008-01-08 at 23:05 -0800, Joshua D. Drake wrote:
> Sim Zacks wrote:
>
> >
> > The reason companies go with the closed source, expensive solutions is
> > because they are better products.
>
> Sometimes, sometimes not. It depends on your needs.
This is total FUD. Everything has a plac
On 09.01.2008, at 00:08, Joshua D. Drake wrote:
Did you even bother to read the page?
Actually I tried but typed it in the browser and it resolved directly
to continuent.com (which I have as a bookmark) and I wasn't aware of
the Sequoia stuff anymore and combined Contiuent with uni/cluster
On Tue, 2008-01-08 at 23:16 -0800, Joshua D. Drake wrote:
> Ow Mun Heng wrote:
> > On Wed, 2008-01-09 at 08:41 +0200, Sim Zacks wrote:
> >> Another way of doing this, without dblink, is using an unsecured language
> >> (plpython, for example) is to connect to the sql server using odbc and
> >> t
Ow Mun Heng wrote:
On Wed, 2008-01-09 at 08:41 +0200, Sim Zacks wrote:
Another way of doing this, without dblink, is using an unsecured language
(plpython, for example) is to connect to the sql server using odbc and then
putting the data into your postgresql.
I use perl DBI to connect to both
On Tue, 2008-01-08 at 23:37 -0700, Guido Neitzer wrote:
> On 08.01.2008, at 23:20, Joshua D. Drake wrote:
> Like, I have a situation where I need multi-master just for
> availability. Two small servers are good enough for that. But
> unfortunately with PostgreSQL the whole setup is a major pa
On Wed, 2008-01-09 at 08:41 +0200, Sim Zacks wrote:
> Another way of doing this, without dblink, is using an unsecured language
> (plpython, for example) is to connect to the sql server using odbc and then
> putting the data into your postgresql.
I use perl DBI to connect to both PG and MSSQL.
Guido Neitzer wrote:
On 08.01.2008, at 23:40, Joshua D. Drake wrote:
There are OS level things you can do here.
They are normally not really easier and, more important, I don't have
them on my deployment environment.
http://www.continuent.org/HomePage
When I'm talking about two cheap ma
Sim Zacks wrote:
> That isn't really an extensibility argument. At least not in my mind.
> Further I don't know of anyone that can "easily" do it. You either
> suffer the possibility of catastrophic data loss (dolphins) or you
> suffer guaranteed bank account drainage (Oracle), or you suffer
> That isn't really an extensibility argument. At least not in my mind.
> Further I don't know of anyone that can "easily" do it. You either
> suffer the possibility of catastrophic data loss (dolphins) or you
> suffer guaranteed bank account drainage (Oracle), or you suffer the
> willingness of
On 08.01.2008, at 23:40, Joshua D. Drake wrote:
There are OS level things you can do here.
They are normally not really easier and, more important, I don't have
them on my deployment environment.
http://www.continuent.org/HomePage
When I'm talking about two cheap machines you recommend
Another way of doing this, without dblink, is using an unsecured language
(plpython, for example) is to connect to the sql server using odbc and then
putting the data into your postgresql.
Sim
Afewtips.com wrote:
On Jan 4, 10:08 am, "Afewtips.com" <[EMAIL PROTECTED]> wrote:
Hi,
I am new to t
Guido Neitzer wrote:
On 08.01.2008, at 23:20, Joshua D. Drake wrote:
That isn't really an extensibility argument.
I was thinking about that too - for me, it still is just an outstanding
issue with PostgreSQL. It is incredibly scalable on one machine but it
totally sucks when you want more,
A tangentially PG related question:
In a PHP project I have several functions that I use for DB operations.
I only want to allow one of them to write, all the others are for
reading only. I was thinking that a way I can enforce this would be to
check that the read only ones only have queries w
On 08.01.2008, at 23:20, Joshua D. Drake wrote:
That isn't really an extensibility argument.
I was thinking about that too - for me, it still is just an
outstanding issue with PostgreSQL. It is incredibly scalable on one
machine but it totally sucks when you want more, but not much more.
Guido Neitzer wrote:
On 08.01.2008, at 17:36, Joshua D. Drake wrote:
2. What types of extensibility (possibly already available in
other DBMSs) are currently missing in PostgreSQL?
None that I am aware of.
Easy multi-master clustering with just two machines.
That isn't really an exte
On 08.01.2008, at 17:36, Joshua D. Drake wrote:
2. What types of extensibility (possibly already available in
other DBMSs) are currently missing in PostgreSQL?
None that I am aware of.
Easy multi-master clustering with just two machines.
cug
--
http://www.event-s.net
---
On Tuesday 08 January 2008 21:31, Gregory Stark wrote:
> "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> >> 2. What types of extensibility (possibly already available in
> >> other DBMSs) are currently missing in PostgreSQL?
> >
> > None that I am aware of.
>
> I'm sure there are some options
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
>> 2. What types of extensibility (possibly already available in
>> other DBMSs) are currently missing in PostgreSQL?
>
> None that I am aware of.
I'm sure there are some options available in some databases which Postgres
doesn't have. Usually P
Joshua D. Drake wrote:
> On Tue, 08 Jan 2008 16:28:11 -0800
> Eric Davies <[EMAIL PROTECTED]> wrote:
> > 3. To what extent was your choice of PostgreSQL as a development
> > platform based primarily on its extensibility features?
>
> There is no other open source database that can compare
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 increa
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 08 Jan 2008 16:28:11 -0800
Eric Davies <[EMAIL PROTECTED]> wrote:
> The existing server extensibilities in modern DBMSs have been
> critical in our company's development of software products that
> improve database performance for certain sc
The existing server extensibilities in modern DBMSs have been
critical in our company's development of software products that
improve database performance for certain scientific computing
applications. We are planning to develop other products that will
utilize an extensible database engine, a
"D. Dante Lorenso" <[EMAIL PROTECTED]> writes:
> I don't understand why the ORDER BY condition would be affecting my
> WHERE criteria. Shouldn't the ordering be done after the filter is
> first applied?
No, not necessarily. The problem you've got is that the planner
thinks there are 1473 rows
I've to sync 2 tables with pk (serial/identity).The source comes from
MS SQL, the destination is pg (ODBC is not an option currently).
One solution would be to truncate the destination and just copy the
new data in it but I prefer a slower sync but avoid a period where no
data is available.
So I
All,
I have a simple query:
SELECT tcq_id
FROM queue q
WHERE q.status = 'D'
ORDER BY tcq_id ASC
LIMIT 1;
What I'm trying to do is find all the items in the queue which have a
status of 'D' and then select the oldest item first. My data is very
skewed such that there are not many re
Hi everyone,
I´m trying to undestand how to do select with xml path.
I have this xml example:
create table temp(id integer, xml text, Primary Key(id));
On Tue, Jan 08, 2008 at 06:06:43PM +, William Temperley wrote:
> Hi
>
> Does anyone know if there is an 8.2.X windows build that has xml
> support, including the XML datatype and SQL/XML functions such as
> xmlagg and xmlelement?
No, and there won't be in the future. We don't add features af
[EMAIL PROTECTED] ("Harald Armin Massa") writes:
>> Not likely to change in the future, no. Slony uses triggers to manage the
>> changed rows. We can't fire triggers on large object events, so there's no
>> way for Slony to know what happened.
>
> that leads me to a question I often wanted to ask
Hi
Does anyone know if there is an 8.2.X windows build that has xml support,
including the XML datatype and SQL/XML functions such as xmlagg and
xmlelement?
I know 8.3 has excellent support for this, however I have a client that
requires a routing solution using the PGRouting extension, which onl
cdecarlo <[EMAIL PROTECTED]> writes:
> I'm new to pl/pgsql and postgres and I need some help with a part of
> my function. In the function I loop through a multidemensional array
> ( [n][3] ), once, while inside the loop, I find the index I want to
> work with I would like to set a separate variab
rihad <[EMAIL PROTECTED]> writes:
> Could you please be more specific? I can't find the steps to jump from
> 8.3beta2 to 8.3rc1, only from 8.2 to 8.3.
You should be able to just dump and restore. The forced initdb for
beta4 was to fix a couple of mistaken system-catalog entries, but it
shouldn't
Alvaro Herrera wrote:
Sergei Shelukhin escribió:
Hi. I have a query that does some batch deletes and inserts into a
table. It runs for 2-3 minutes when the application that uses the
database is in production with users doing stuff.
Recently I have noticed that this query is a frequent victim
On Jan 8, 2008, at 9:13 AM, Scott Marlowe wrote:
On Jan 8, 2008 9:01 AM, Harald Armin Massa
<[EMAIL PROTECTED]> wrote:
Not likely to change in the future, no. Slony uses triggers to
manage the
changed rows. We can't fire triggers on large object events, so
there's no
way for Slony to kn
On Jan 8, 2008 9:01 AM, Harald Armin Massa <[EMAIL PROTECTED]> wrote:
> > Not likely to change in the future, no. Slony uses triggers to manage the
> > changed rows. We can't fire triggers on large object events, so there's no
> > way for Slony to know what happened.
>
> that leads me to a questi
Can you provide more info please?
- pgpool version(I assume it's pgpool-II since you use 3 PostgreSQL
servers)
- pgpool.conf
Do you get the error right after start psql? Or it only happens after
you issue create database command?
Also please provide detailed log which can be obtained by using
> Not likely to change in the future, no. Slony uses triggers to manage the
> changed rows. We can't fire triggers on large object events, so there's no
> way for Slony to know what happened.
that leads me to a question I often wanted to ask:
is there any reason to create NEW PostgreSQL databas
>I have a very large table (~5GB, 100mm rows) on which I am creating an
>index on an int4 column:
>CREATE INDEX CONCURRENTLY rums_idx2
> ON rums
> USING hash
> (user_id);
Why are you using a hash index on an int4 column?
as you have 100mm (mm= Million?) rows, only 1 GIG ram and the
column_name i
Hello
yes, new 8.3 supports SQL/XML
http://www.postgresql.org/docs/8.3/static/datatype-xml.html
http://www.postgresql.org/docs/8.3/static/functions-xml.html
Regards
Pavel Stehule
On 05/01/2008, Joana G. Malaverri <[EMAIL PROTECTED]> wrote:
> I like to know if Postgre has an embebed aplicattion
Sergei Shelukhin escribió:
> Hi. I have a query that does some batch deletes and inserts into a
> table. It runs for 2-3 minutes when the application that uses the
> database is in production with users doing stuff.
> Recently I have noticed that this query is a frequent victim of
> deadlocks.
Wh
On Mon, Jan 07, 2008 at 12:58:44PM +0100, Michelle Konzack wrote:
> > except he has large objects, which slony can't replicate.
>
> currently or will this be changed in the future?
Not likely to change in the future, no. Slony uses triggers to manage the
changed rows. We can't fire triggers on
On Jan 4, 11:22 pm, [EMAIL PROTECTED] ("Jeff Larsen") wrote:
> On Jan 4, 2008 8:33 AM, Magnus Hagander <[EMAIL PROTECTED]> wrote:
>
>
>
>
>
> > On Wed, Jan 02, 2008 at 11:17:52PM -0800, Goboxe wrote:
> > > Hi,
>
> > > What are required to be configured in order to send logs to
> > > remote syslog s
Hello,
I need to write a stored procedure that does look something like this:
CREATE FUNCTION foo() RETURNS SETOF BIGINT LANGUAGE plpgsql AS $$
DECLARE
result RECORD;
BEGIN
EXECUTE 'CREATE TEMP TABLE foo (id int,...)';
-- Insert something into foo depending on contents of the data
Hi. I have a query that does some batch deletes and inserts into a
table. It runs for 2-3 minutes when the application that uses the
database is in production with users doing stuff.
Recently I have noticed that this query is a frequent victim of
deadlocks.
Is there any way to set a deadlock prio
On Jan 4, 10:08 am, "Afewtips.com" <[EMAIL PROTECTED]> wrote:
> Hi,
> I am new to this product and don't quite know what can and cannot be
> done.
>
> I need to submit queries to a SQL Server database and create a table
> in Postgresql with the results from SQL Server.
>
> Normally I would do this
> "Lane, Tom" <[EMAIL PROTECTED]> writes:
>
> Ugh. Does it work if you do
>
> export PGOPTIONS="--ignore_system_indexes=1"
>
> first? If so, the problem would evidently be corruption of
> the indexes for pg_attribute, specifically
> pg_attribute_relid_attnum_index. It seems pretty su
"Lane, Tom" <[EMAIL PROTECTED]> writes:>
> "O'Shea, Brendan" <[EMAIL PROTECTED]> writes:
> >> "Lane, Tom" <[EMAIL PROTECTED]> writes:
> >> Ugh. Does it work if you do
> >> export PGOPTIONS="--ignore_system_indexes=1"
>
> > I tried that, but unfortunately pg_dump still fails to run
> and the err
Thanks a lot. It helps.
On Fri, 04 Jan 2008 16:54:32 +0100, Oleg Bartunov <[EMAIL PROTECTED]> wrote:
On Wed, 2 Jan 2008, Jan Sunavec wrote:
Hi all
I have following problem when I use this
select headline('asd asd asd asd asd asd asd asd asd asd asd asd more
more more more more more more',
Hi,
I am new to this product and don't quite know what can and cannot be
done.
I need to submit queries to a SQL Server database and create a table
in Postgresql with the results from SQL Server.
Normally I would do this with an ODBC driver into SQL Server, but I
don't see any references to doing
I like to know if Postgre has an embebed aplicattion to allow
transform a sql query and return a xml request.
Thanks Joana
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
D. Dante Lorenso wrote:
But if I want to find all the items which are not in any folder, I want:
SELECT *
FROM mytable
WHERE folder_id IS NULL;
I don't have any folder_id 0, so on a URL I might do this:
http://xyz/page.php?fid=123
http://xyz/page.php?fid=0
SELECT * FROM mytable WHE
I have 3 postgresql services running and I have them correctly
referenced in the pgpool.conf file.
However, I get the following error when I try to create db's to them
using the following command:
psql -p db_name
psql: server closed the connection unexpectedly
This probably means the
I have a very large table (~5GB, 100mm rows) on which I am creating an
index on an int4 column:
CREATE INDEX CONCURRENTLY rums_idx2
ON rums
USING hash
(user_id);
The process has been running for about two days, and the index has
been growing; when I run du i can see that it is ~2GB on the
f
Hello,
I'm new to pl/pgsql and postgres and I need some help with a part of
my function. In the function I loop through a multidemensional array
( [n][3] ), once, while inside the loop, I find the index I want to
work with I would like to set a separate variable equal to the element
in the array
Hi, all! Subj, as is. Any other pitfalls I should be aware of?
Please check the release notes for this information.
Could you please be more specific? I can't find the steps to jump from
8.3beta2 to 8.3rc1, only from 8.2 to 8.3.
http://www.postgresql.org/docs/8.3/static/release-8-3.html
--
Hello Vivek,
Am 2007-12-21 15:59:21, schrieb Vivek Khera:
>
> On Dec 21, 2007, at 11:09 AM, Martijn van Oosterhout wrote:
>
> >The usual answer is use slony. You can use it to replicate the 8.0
> >server onto an 8.1 server. This may take weeks/months/years/whatever
> >to
> >synchronise. When t
Am Dienstag, 8. Januar 2008 schrieb rihad:
> Hi, all! Subj, as is. Any other pitfalls I should be aware of?
Please check the release notes for this information.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
Paul McGarry wrote:
> Bearing in mind that I don't particularly need the data in that table
> can I simply truncate it or drop/recreate it to clear the above error?
Yes, truncate should work.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company -
Pedro Briones García wrote:
> Tengo un fichero .SQL generado con SHP2PGSQL a partir de un
> fichero SHAPE de polígonos. El problema es que algunos de
> esos polígonos están definidos por muchas coordenadas (crean
> una sentencia INSERT muy grande). En una instalación de
> PostgreSQL/PostGIS se
On Mon, Jan 07, 2008 at 02:32:26PM -0500, Kevin Hunter wrote:
> Something along the lines of
>
> CREATE TABLE o_1 ( id SERIAL ... );
> CREATE TABLE o_2 ( id SERIAL ... );
> CREATE TABLE o_3 ( id SERIAL ... );
> CREATE TABLE comments (
>id SERIAL,
>obj_id INTEGER ...
>FOREIGN KEY (obj_
Hola a todos.
Tengo un fichero .SQL generado con SHP2PGSQL a partir de un fichero SHAPE de
polígonos. El problema es que algunos de esos polígonos están definidos por
muchas coordenadas (crean una sentencia INSERT muy grande). En una instalación
de PostgreSQL/PostGIS se cargan bien. Sin e
2008/1/8, Alvaro Herrera <[EMAIL PROTECTED]>:
> Clodoaldo escribió:
>
> 8.2:
>
> > Trigger for constraint datas: time=14231.240 calls=880691
> > Total runtime: 356862.302 ms
> > (12 rows)
> >
> > Time: 357750.531 ms
>
> 8.3:
>
> > Trigger for constraint datas: time=33179.197 calls=877895
> > To
On Mon, 2008-01-07 at 12:32 -0800, Joshua D. Drake wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On Mon, 07 Jan 2008 20:25:45 +
> Richard Huxton <[EMAIL PROTECTED]> wrote:
>
> > Scott Marlowe wrote:
> > > On Jan 7, 2008 12:57 PM, Devrim GÜNDÜZ <[EMAIL PROTECTED]>
> > > wrote:
>
On Mon, 07 Jan 2008 20:56:49 -0800
"Joshua D. Drake" <[EMAIL PROTECTED]> wrote:
> Some people won't like this but... packet shaping and bandwidth
> control as well.
Isn't there a native way to allocate postgresql resources accordingly
to the user?
Won't traffic shaping place "on hold" things that
69 matches
Mail list logo
