[GENERAL] Re: ERROR: unrecognized object class: 1262 with 9.2.2 but not with 9.2.1

2012-12-09 Thread Thomas Kellerer
Jeff Janes, 09.12.2012 23:41: I recently upgraded from 9.2.1 to 9.2.2 and my unit tests for my application are failing when cleaning up my test database. I am using the statement: drop owned by wbjunit cascade; at the end of a test suite to get rid of everything that was created during th

Re: [GENERAL] SSDs - SandForce or not?

2012-12-09 Thread Greg Smith
On 11/14/12 2:11 AM, Toby Corkindale wrote: So on the face of it, I think the Sandforce-based drives are probably a winner here, so I should look at the Intel 520s for evaluation, and whatever the enterprise equivalent are for production. As far as I know the 520 series drives fail the requirem

[GENERAL] Re: ERROR: unrecognized object class: 1262 with 9.2.2 but not with 9.2.1

2012-12-09 Thread Thomas Kellerer
Jeff Janes, 09.12.2012 23:41: On Sun, Dec 9, 2012 at 2:36 AM, Thomas Kellerer wrote: I recently upgraded from 9.2.1 to 9.2.2 and my unit tests for my application are failing when cleaning up my test database. I am using the statement: drop owned by wbjunit cascade; at the end of a test s

Re: [GENERAL] Query and index ... unexpected result need advice.

2012-12-09 Thread Condor
On 2012-12-10 00:31, Jeff Janes wrote: On Sat, Dec 8, 2012 at 5:54 AM, Condor wrote: I am interested to know where is my mistake or something wrong with server which I doubt. Here is my current query with explain: (I change names to XXX YYY ZZZ because original names is written on CP1251 and

Re: [GENERAL] Problem with aborting entire transactions on error

2012-12-09 Thread David Johnston
On Dec 9, 2012, at 22:20, Zbigniew wrote: > Hello, > > As I read while googling the web, many people complained about this > before. Couldn't it be made optional (can be even with "default ON")? > I understand, that there are situations, when it is a must - for > example, when the rest of querie

Re: [GENERAL] query performance, though it was timestamps,maybe just table size?

2012-12-09 Thread Jeff Janes
On Mon, Dec 3, 2012 at 5:56 AM, Henry Drexler wrote: > On Sun, Dec 2, 2012 at 12:44 AM, Jeff Janes wrote: >> >> Could you do it for the recursive >> SQL (the one inside the function) like you had previously done for the >> regular explain? >> >> Cheers, >> >> Jeff > > > Here they are: > > for the

Re: [GENERAL] ERROR: unrecognized object class: 1262 with 9.2.2 but not with 9.2.1

2012-12-09 Thread Jeff Janes
On Sun, Dec 9, 2012 at 2:36 AM, Thomas Kellerer wrote: > I recently upgraded from 9.2.1 to 9.2.2 and my unit tests for my application > are failing when cleaning up my test database. > > I am using the statement: > >drop owned by wbjunit cascade; > > at the end of a test suite to get rid of ev

Re: [GENERAL] Query and index ... unexpected result need advice.

2012-12-09 Thread Jeff Janes
On Sat, Dec 8, 2012 at 5:54 AM, Condor wrote: > I am interested to know where is my mistake or something wrong > with server which I doubt. Here is my current query with explain: > (I change names to XXX YYY ZZZ because original names is written on CP1251 > and most ppl in list can't read them) >

Re: [GENERAL] When is archive_cleanup called?

2012-12-09 Thread Jeff Janes
On Fri, Nov 30, 2012 at 6:44 AM, François Beausoleil wrote: > > How come no new restart points were achieved? I had 4008 WAL archives on my > slave. I expected them to be removed as streaming replication progressed. Are > restart points prevented while long queries are running? They can be pre

Re: [GENERAL] Statistics mismatch between n_live_tup and actual row count

2012-12-09 Thread tim_wilson
It seems that we are currently running 8.4.3 on the server we are encountering the problem. Will upgrade to 8.4.9 and then will come back with a test case if we still see the issue Thanks again for your help. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Statistics-

Re: [GENERAL] When is archive_cleanup called?

2012-12-09 Thread Vincent Veyron
Le vendredi 30 novembre 2012 à 09:44 -0500, François Beausoleil a écrit : > I'm using 9.1.5 on Ubuntu 11.10, in a streaming replication scenario. On my > slave, recovery.conf states: > > standby_mode = on > restore_command = '/usr/local/omnipitr/bin/omnipitr-restore -D > /var/lib/postgresql/9.1

Re: [GENERAL] Installation Issue on Ubuntu under Xen

2012-12-09 Thread Adrian Klaver
On 12/09/2012 02:40 AM, P. Broennimann wrote: Hi there I have a VM running under XEN XCP. The VM is Ubuntu server 12.04.1/64 headless. The VM is completely fresh & clean and works fine. Then I install Postgresql... sudo apt-get install python-software-properties sudo add-apt-repositor

[GENERAL] Re: ERROR: unrecognized object class: 1262 with 9.2.2 but not with 9.2.1

2012-12-09 Thread Thomas Kellerer
Thomas Kellerer wrote on 09.12.2012 11:36: I recently upgraded from 9.2.1 to 9.2.2 and my unit tests for my application are failing when cleaning up my test database. I am using the statement: drop owned by wbjunit cascade; at the end of a test suite to get rid of everything that was crea

[GENERAL] Installation Issue on Ubuntu under Xen

2012-12-09 Thread P. Broennimann
Hi there I have a VM running under XEN XCP. The VM is Ubuntu server 12.04.1/64 headless. The VM is completely fresh & clean and works fine. Then I install Postgresql... sudo apt-get install python-software-properties sudo add-apt-repository ppa:pitti/postgresql sudo apt-get update s

[GENERAL] ERROR: unrecognized object class: 1262 with 9.2.2 but not with 9.2.1

2012-12-09 Thread Thomas Kellerer
I recently upgraded from 9.2.1 to 9.2.2 and my unit tests for my application are failing when cleaning up my test database. I am using the statement: drop owned by wbjunit cascade; at the end of a test suite to get rid of everything that was created during the tests. Now since the upgrade