Hi,
I'm going to be deploying Postgres in a semi-embedded system where end
users might simply power the thing off from one moment to the next.
Or the disk might start to go wonky, or any number of other problems.
Because it's a standalone device, it may well run in an environment
where we can't sh
Hi,
I have a very similar problem... details below.
On Wed, Jul 3, 2013 at 5:19 PM, Paul Tilles wrote:
> Recently, I've had a PostgreSQL 8.2.11 server upgraded to 8.4 in order to
> take advantage of autovacuum features. This server exists in a very closed
> environment (isolated network, limited
Hi,
I think I could write a script to do something similar to what is
happening if anyone is interested. I'd want some direction as to the
best way to handle this though: it'd be easier for me to script it as
Rails code because that's what the app is. Perhaps from that we can
get the generated S
to tell given
> that it is no longer a problem.
>
> Thanks for the offer, and I apologize if I'm just slightly ignorant about
> your intentions.
>
>
> On Mon, Jul 15, 2013 at 4:33 AM, David Welton wrote:
>>
>> Hi,
>>
>> I think I could write a script to do
Hello,
I sort of volunteered for work on an Erlang Postgres driver, here:
https://github.com/epgsql/epgsql
And one thing I was looking into was a patch regarding the cleanup of
named queries.
Specifically, I'm wondering how this code behaves in the case that the
Execute runs into trouble:
http
Hi,
> David Welton writes:
>> Specifically, I'm wondering how this code behaves in the case that the
>> Execute runs into trouble:
>
>> https://github.com/epgsql/epgsql/blob/0e84176be4b54fb712d1cc227a2b91c24b7a66ab/src/pgsql_sock.erl#L199
>
> I guess you
Hi,
On Thu, Mar 13, 2014 at 1:51 AM, Tom Lane wrote:
> David Welton writes:
>>> send(State, ?BIND, ["", 0, StatementName, 0, Bin1, Bin2]),
>>> send(State, ?EXECUTE, ["", 0, <<0:?int32>>]),
>>> send(State, ?CLOSE, [?PREPARED_STATE
Hi,
We have a situation where HIPAA data that needs to be encrypted.
Since we have lots of users, and a number of users who access the data
of different people, we cannot simply encrypt the disk and call it
good - it's not fine-grained enough.
So far, we've been encrypting each row, and that actu
Hi,
I'm curious as to what the general opinion is on these different
queries and their relative merits, especially in terms of speed:
-
select count(*) from zstore_temp where product_code not in (select
product_code from zstore)
QUERY PLAN
-
One thing you might consider is the 'Base' application from
openoffice. I'm not sure it's what you want, but it might work... In
any case it's likely worth looking at.
> > I prefer major (A status) programming language using classification from
> > http://www.tiobe.com/tpci.htm
... wandering of
Hi,
I'm trying to figure out the best way to handle the following situation.
There are two processes, A, and B.
A is a daemon process that performs a select, and then slowly iterates
over the results, performing updates along the way.
It is possible that interactive process B comes along, and w
[ Oops, I missed the reply-to button the first time - sorry for the
repeat, Csaba ]
On 3/28/06, Csaba Nagy <[EMAIL PROTECTED]> wrote:
> > Try breaking down the A query with LIMIT/OFFSET so that it never holds
> > locks for long. That way B will not wait for long, if at all, and will
> > not fail.
there is using it for a heavy duty web
project on Irix, and if so, how well it has performed.
I would be overjoyed to chuck msql out the window:->
Thanks,
--
David Welton http://www.efn.org/~davidw
Debian GNU/Linux - www.debian.org
13 matches
Mail list logo
