Re: [GENERAL] SELECT FOR UPDATE could see commited trasaction partially.

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

Re: [GENERAL] atoi-like function: is there a better way to do this?

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

[GENERAL] Determine dead files

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

Re: [GENERAL] what Linux to run

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

[GENERAL] Memory usage and configuration settings

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

[GENERAL] Non inheritable check constraint

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

Re: [GENERAL] Return unknown resultset from a function

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

Re: [GENERAL] what Linux to run

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

Re: [GENERAL] Memory usage and configuration settings

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

Re: [GENERAL] Return unknown resultset from a function

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

Re: [GENERAL] Memory usage and configuration settings

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

Re: [GENERAL] Memory usage and configuration settings

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

Re: [GENERAL] Return unknown resultset from a function

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,

Re: [GENERAL] Memory usage and configuration settings

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

[GENERAL] Lost data Folder, but have WAL files--- How to recover the database ?? Windows

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:

[GENERAL] Single server multiple databases - extension

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.

Re: [GENERAL] Lost data Folder, but have WAL files--- How to recover the database ?? Windows

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

[GENERAL] ANALYSE on top-level of partitioned tables - required?

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...