Am 20.11.2011 23:54, schrieb Andreas 'ads' Scherbaum:
FOSDEM 2012 - PostgreSQL Devroom: Call for Speakers
The PostgreSQL project will have a Devroom at FOSDEM 2012, which takes
place on February 4-5 in Brussels, Belgium. The Devroom will mainly
cover topics for PostgreSQL users, developers and
On Thu, Dec 15, 2011 at 2:01 PM, Scott Marlowe wrote:
> On Thu, Dec 15, 2011 at 10:17 AM, Eliot Gable
> wrote:
>> Is this bogus, or is it an upcoming feature?
>>
>> http://wiki.postgresql.org/wiki/Lock_database
LOCK DATABASE was brought up earlier this year:
http://archives.postgresql.org/pgsq
Hello,
I have a problem with PL/Proxy
(sorry for not posting to plproxy-users, but I have some problem
subscribing there).
I try to use it to achieve "single node paralellism"
- as MattK nicely put it on
http://dba.stackexchange.com/questions/9097/single-node-parallelism-with-pl-proxy
My setup
On 12/15/11, Merlin Moncure wrote:
> On Thu, Dec 15, 2011 at 11:29 AM, Robert James
> wrote:
>> Is there anyway to do the equivalent of CREATE OR REPLACE AGGREGATE?
>> Or - maybe even better - CREATE AGGREGATE if it doesn't already exist?
>
> Well, you have DROP [IF EXISTS] which should cover at
On 12/15/11, Marti Raudsepp wrote:
> On Thu, Dec 15, 2011 at 18:10, Robert James wrote:
>> How do I do the equivalent of an ANY() or ALL() in PG Aggregate SQL?
>
> Note that in many cases, writing an EXISTS(SELECT ...) or NOT
> EXISTS(...) subquery is faster, since the planner can often optimize
Some of my code involves transactions which will not have significant
effect on the database. It might be a read-only transaction (possibly
declared as one, but possibly not), or perhaps a completely empty
transaction - I have a framework that will always open a transaction,
then call on other code
On Sat, Dec 17, 2011 at 6:53 PM, Chris Angelico wrote:
> Some of my code involves transactions which will not have significant
> effect on the database. It might be a read-only transaction (possibly
> declared as one, but possibly not), or perhaps a completely empty
> transaction - I have a framew
On Sun, Dec 18, 2011 at 2:02 PM, Chris Travers wrote:
> I do not believe there are performance penalties for either. All
> commit or rollback does is determine visibility of changes made.
Thanks. (And thanks for the incredibly quick response!)
My framework has a "read-only mode" (determined by
Patrick Kevin McCaffrey writes:
> I'm new to PostgreSQL, but am trying to set up a server on my machine. The
> PostgreSQL server is to run inside of a LXC container - I'm not sure if this
> is contributing to my problem or not, but it's worth mentioning. The main OS
> (host) of my machine is
