On 5/13/2013 9:31 PM, kristian kvilekval wrote:
I saw on the mailing list that back in 2010 there was some
discussion of using Zorba to add xquery capabilities to postgres. I
was wondering if any progress had been made on this and what the
current interest levels of supporting xml in postgr
Easy money indeed. Thanks for the help
On Mon, 2013-05-13 at 15:28 -0500, Justin Tocci wrote:
> em stands for "easy money"
>
> update tbl1
> set col3=em.col3,col4=em.col4,col5=em.col5
> from
> (select col3, col4,col5 from tbl2 where col1="criteria") em
>
> Regards,
>
> Justin Tocci
> Programmer
I saw on the mailing list that back in 2010 there was some discussion of
using Zorba to add xquery capabilities to postgres. I was wondering if
any progress had been made on this and what the current interest levels of
supporting xml in postgres are?
Thanks,
Kris
On 5/13/2013 7:10 PM, S H wrote:
My disk is utilized by many other components, thus do we have minimum
recommendation my postgres to have sufficient speed. Current
perfomance of my disk is around 1-5MB/sec. Is it sufficient?
how are you measuring this? thats painfully slow by today's standa
My disk is utilized by many other components, thus do we have minimum
recommendation my postgres to have sufficient speed. Current perfomance of my
disk is around 1-5MB/sec. Is it sufficient?
Is it slow and can be cause of slow vacuuming..
Jeff Janes writes:
> On Mon, May 13, 2013 at 2:00 PM, Alvaro Herrera
> wrote:
>> Jeff Janes escribió:
>>> I think "reassign owned" should detect that it is being invoked on the
>>> internal user (as it does now) but then instead of refusing to run, it
>>> should DWIM.
>> Hm, so what would you ha
On Mon, May 13, 2013 at 2:00 PM, Alvaro Herrera wrote:
> Jeff Janes escribió:
>
> > I think "reassign owned" should detect that it is being invoked on the
> > internal user (as it does now) but then instead of refusing to run, it
> > should DWIM. I suppose that was not implemented because it is d
Jeff Janes escribió:
> I think "reassign owned" should detect that it is being invoked on the
> internal user (as it does now) but then instead of refusing to run, it
> should DWIM. I suppose that was not implemented because it is difficult to
> do so (but of course that is all the more reason no
Le lundi 13 mai 2013 à 13:23 -0700, Bret Stern a écrit :
> PG 8.4
>
> Having trouble putting together an update query to update
> multiple columns in tbl1 from columns in tbl2.
>
> update tbl1
> set col3,col4,col5
> from
> (select col3, col4,col5 from tbl2 where col1="criteria")
>
UPDATE tbl1
On Mon, May 13, 2013 at 9:13 AM, Vincent Veyron wrote:
> Le mercredi 08 mai 2013 à 14:11 -0700, Jeff Janes a écrit :
> > Let's say you have a database which is owned (as well as all the
> > contents within it) by the postgres internal user.
> >
> >
> > Having created or inherited a mess, how do y
em stands for "easy money"
update tbl1
set col3=em.col3,col4=em.col4,col5=em.col5
from
(select col3, col4,col5 from tbl2 where col1="criteria") em
Regards,
Justin Tocci
Programmer
www.workflowproducts.com
7813 Harwood Road
North Richland Hills, TX 76180
phone 817-503-9545
skype justintocci
On M
> PG 8.4
>
> Having trouble putting together an update query to update multiple
> columns in tbl1 from columns in tbl2.
>
> update tbl1
> set col3,col4,col5
> from
> (select col3, col4,col5 from tbl2 where col1="criteria")
>
>
>
> Can someone add to the Postgres Docs (shown below) to help me w
PG 8.4
Having trouble putting together an update query to update
multiple columns in tbl1 from columns in tbl2.
update tbl1
set col3,col4,col5
from
(select col3, col4,col5 from tbl2 where col1="criteria")
Can someone add to the Postgres Docs (shown below) to help me with this.
UPDATE employe
"Sahagian, David" writes:
> I see in the Release Notes for 9.3 beta . . .
> "Force cached functions to be replanned if the search_path changes (Tom
> Lane)
> Previously functions already run in the current session ignored search_path
> changes."
> Question:
> Do Prepared Statements also g
Hi,
Please follow the below link for the release notes:
http://www.postgresql.org/docs/devel/static/release-9-3.html
Hope this helps.
--
Thanks & Regards,
Naveed Shaikh
On Mon, May 13, 2013 at 11:53 PM, Sahagian, David wrote:
> I see in the Release Notes for 9.3 beta . . .
>
> ** **
>
I see in the Release Notes for 9.3 beta . . .
"Force cached functions to be replanned if the search_path changes (Tom Lane)
Previously functions already run in the current session ignored search_path
changes."
Question:
Do Prepared Statements also get replanned, if the search_path changes
Le mercredi 08 mai 2013 à 14:11 -0700, Jeff Janes a écrit :
> Let's say you have a database which is owned (as well as all the
> contents within it) by the postgres internal user.
>
>
> Having created or inherited a mess, how do you fix it?
>
with sed on Linux/Unix, you could do this :
pg_du
On Mon, May 13, 2013 at 8:37 AM, S H wrote:
>> What is the db server doing when this happens? What does top, vmstat,
>> iostat etc have to say about it?
>
> It is high end server with 96 GB of RAM , 16 core server, but there are many
> other application running, This db is used for monitoring the
> vacuum or vacuum full?
vacuum analyze.
> What is the db server doing when this happens? What does top, vmstat,
> iostat etc have to say about it?
It is high end server with 96 GB of RAM , 16 core server, but there are many
other application running, This db is used for monitoring the performa
On Mon, May 13, 2013 at 8:05 AM, S H wrote:
> Hi,
>
> I have my database in which i am executing vacuuming running manually in one
> hour.
vacuum or vacuum full?
> In my production database sometime when vacuuming is running it is taking
> long time in opening connection.
What is the db server
Hi,
I have my database in which i am executing vacuuming running manually in one
hour.
In my production database sometime when vacuuming is running it is taking long
time in opening connection.
My current version is version 8.1. Is there any known issue about open
connection problem with vacuu
On Sun, May 12, 2013 at 8:20 PM, John R Pierce wrote:
> On 5/12/2013 6:13 PM, David Boreham wrote:
>>
>>
>> Not quite. More like : a) I don't know where to buy SLC drives in 2013
>> (all the drives for example for sale on newegg.com are MLC) and b) today's
>> MLC drives are quite good enough for m
On May 13, 2013, at 12:20 AM, Tsunakawa, Takayuki wrote:
> I'm not sure whether there are any situations where the DBAs need to use
> different username/password pairs for the OS user who starts/stops the
> database server, and the database superuser.
I was thinking obscurity might be a good f
On Mon, May 13, 2013 at 11:17 AM, Amit Langote wrote:
> > However, PG documentation doesn't highlight about this in psql or PAM
> > section, because log entries written are slightly confusing.
> > http://www.postgresql.org/docs/9.2/static/auth-methods.html
> > http://www.postgresql.org/docs/9.2/st
Hi all...
Forgive me if this is not the correct forum for such suggestions.
I'm about to begin using the custom format options for pg_restore, so that
we can leverage the performance gains from --jobs options.
However I would like to be able to specify the tablespace for individual
tables/indexes
oh thanks a lot, we desperately needed to work on the stats collector and since
we were using windows platform, there is not even a decent application that
reports such information
regards and greetings from india
Date: Sun, 12 May 2013 20:33:14 +0900
Subject: Re: [GENERAL] PG Stats Collec
Thanks. I didn't even imagine such a situation.
I'd like to hear other cases like:
- Packaged applications (not OS) that embeds or uses PostgreSQL
- The corporate environment where some security policy is enforced that the OS
user and the database administrator user must be different
Regards
T
27 matches
Mail list logo
