This is correct behavior with MVCC. Do a 'select * from x' in thread 2 and to
understand why. The select for update in thread 2 sees the data in table x as
it was prior to thread 1 committing, thus it won't see the row with a=2.
For further suggestions you'll have to explain what you are
On 05/03/12 05:08, Chris Angelico wrote:
On Mon, Mar 5, 2012 at 3:15 PM, Tom Moleswortht...@audioboundary.com wrote:
Can you use to_number() here? It sounds like something along the lines of
cast(to_number('0' || field::varchar, '9.') as int) might give the
behaviour you're after, and
Hi,
we have a streaming replication running and kind of suspect that the slave
contains dead files caused by an abort of a huge transaction. I'd like to ask
how we can be sure that those files are dead.
The details are:
* PostgreSQL 9.1.2 on x86_64-unknown-linux-gnu, compiled by gcc-4.6.real
If we move to Linux, what is the preferred Linux for running Postgres
on. This machine would be dedicated to the database only.=20
I'd like a recommendation for both a GUI hosted version and a non-GUI
version. I haven't used Linux in the past but did spend several year s
in a mixed Unix
Hi,
I have been using table 17-2, Postgres Shared Memory Usage
(http://www.postgresql.org/docs/9.1/interactive/kernel-resources.html)
to calculate approximately how much memory the server will use. I'm
using Postgres 9.1 on a Linux 2.6 (RHEL 6) 64bit system, with 8GB RAM.
Database is
I have gone through the issue of making a parent table not writable. After
discussing it (1) I adopted the trigger solution. But I think that a
trigger is just an invisible layer over the database model and so I'm
naively proposing a new syntax to postgresql. It would inform that the
check
On Sun, Mar 4, 2012 at 1:52 PM, Jan Meyland Andersen j...@agile.dk wrote:
How do I return an unknown resultset from a function
My main problem is that I do not know how many columns or the data type of
the columns before runtime.
It this possible at all?
I also tried to return the data as a
Thanks for all of the help. I will be doing some testing in VM's this
week before loading on my other server.
Michael Gould
Intermodal Software Solutions, LLC
904-226-0978
Original Message
Subject: Re: [GENERAL] what Linux to run
From: r d rd0...@gmail.com
Date: Mon, March
Mike C smith.not.west...@gmail.com writes:
I have been using table 17-2, Postgres Shared Memory Usage
(http://www.postgresql.org/docs/9.1/interactive/kernel-resources.html)
to calculate approximately how much memory the server will use. I'm
using Postgres 9.1 on a Linux 2.6 (RHEL 6) 64bit
Merlin Moncure mmonc...@gmail.com writes:
The only exception to this rule is cursors. Reading from cursors via
FETCH allows you to pull data from a refcursor that was set up in a
previous function call and works pretty well, but comes with the giant
downside that the results can be directed
On Mon, Mar 5, 2012 at 4:04 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Mike C smith.not.west...@gmail.com writes:
I have been using table 17-2, Postgres Shared Memory Usage
(http://www.postgresql.org/docs/9.1/interactive/kernel-resources.html)
to calculate approximately how much memory the server
Mike C smith.not.west...@gmail.com writes:
Ok, that makes sense. With regards to work_mem, am I right in thinking
the child processes only allocate enough memory to meet the task at
hand, rather than the full 16M specified in the config file?
They only allocate what's needed ... but you have
On Mon, Mar 5, 2012 at 10:08 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Merlin Moncure mmonc...@gmail.com writes:
The only exception to this rule is cursors. Reading from cursors via
FETCH allows you to pull data from a refcursor that was set up in a
previous function call and works pretty well,
On Mon, Mar 5, 2012 at 6:37 AM, Mike C smith.not.west...@gmail.com wrote:
Hi,
I have been using table 17-2, Postgres Shared Memory Usage
(http://www.postgresql.org/docs/9.1/interactive/kernel-resources.html)
to calculate approximately how much memory the server will use. I'm
using Postgres
Hi All,
Recently i was doing streaming replication, I lost the data folder on both
the servers and left with WAL archives (some how).
Can any one tell me how to recover database with WAL archives.
Thanks in advance.
--
View this message in context:
Hi
I have 2 databases running in a single server; and I installed extension
'hstore' to one database and it works fine. When I tried to use the same
extension in another database, it gives an error saying 'extension does not
exist'; nor it allow to install as it complains about its existence.
On Mon, Mar 5, 2012 at 6:38 PM, chinnaobi chinna...@gmail.com wrote:
Hi All,
Recently i was doing streaming replication, I lost the data folder on both
the servers and left with WAL archives (some how).
Can any one tell me how to recover database with WAL archives.
I don;t think you can
Hi,
Say you have a master table which has many partitioned tables, created
like this:
CREATE TABLE foo (various columns...);
CREATE TABLE foo_1 () INHERITS foo;
CREATE TABLE foo_2 () INHERITS foo;
Now lets say you insert data directly into foo_X, eg with
COPY foo_1 FROM...
COPY foo_1 FROM...
18 matches
Mail list logo