Re: [PERFORM] "Mysterious" issues with newly installed 8.3

The first thing I'd try is installing 8.2 on the new server to see if the problem is the server or postgresql. Set up the new server and new pgsql install the same and see how it runs. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscript

Re: [PERFORM] "Mysterious" issues with newly installed 8.3

Scott Carey wrote: On Thu, Oct 9, 2008 at 4:51 PM, Carlos Moreno <[EMAIL PROTECTED] > wrote: Ok, I know that such an open and vague question like this one is... well, open and vague... But still. The short story: Just finished an 8.3.4 installation

Re: [PERFORM] "Mysterious" issues with newly installed 8.3

On Thu, Oct 9, 2008 at 4:51 PM, Carlos Moreno <[EMAIL PROTECTED]> wrote: > > Ok, I know that such an open and vague question like this one > is... well, open and vague... But still. > > The short story: > > Just finished an 8.3.4 installation on a new machine, to replace > an existing one; the

[PERFORM] "Mysterious" issues with newly installed 8.3

Ok, I know that such an open and vague question like this one is... well, open and vague... But still. The short story: Just finished an 8.3.4 installation on a new machine, to replace an existing one; the new machine is superior (i.e., higher performance) in virtually every way --- twice as

Re: [PERFORM] low performance on functions returning setof record

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, Le 9 oct. 08 à 21:30, Tom Lane a écrit : There's not a lot you can do about that at the moment. 8.4 will have the ability to inline functions returning sets, if they're SQL- language and consist of just a single SELECT, but existing releases w

Re: [PERFORM] low performance on functions returning setof record

"Sabin Coanda" <[EMAIL PROTECTED]> writes: > I use different functions returning setof record, and they are working well. > The problem is the performance when I use those functions in joins, for > instance: > SELECT * > FROM "Table1" t1 > JOIN "Function1"( a1, a2

[PERFORM] low performance on functions returning setof record

Hi there, I use different functions returning setof record, and they are working well. The problem is the performance when I use those functions in joins, for instance: SELECT * FROM "Table1" t1 JOIN "Function1"( a1, a2, ... aN ) AS f1( ColA int4, ColB varchar,

Re: [PERFORM] Delete performance again

OK, I did try you proposal and correlated subselect. I have a database ~90 companies. First try was to remove randomly selected 1000 companies Uncorrelated subselect: 65899ms Correlated subselect: 97467ms using: 9605ms my way: 104979ms. (without constraints recreate) My is the worst because it

Re: [PERFORM] Disc space usage

On Wed, 8 Oct 2008, Tom Lane wrote: One other bit of possibly useful data would be to eyeball the file mod times in the orphaned subdirectories. If they were from failed CREATE DATABASEs then I'd expect every file in a given directory to have the same mod time (modulo the amount of time it takes