[BUGS] Measuring execution time

2010-08-10 Thread vamsi krishna
Hello all I want to measure the execution time spent running an SQL select query after the plan generation. So precisely I want to put my start timer before createQueryDesc() or ExecutorStart() and end timer after freeQueryDesc() or ExecutorEnd(). Right now I did so in "spi.c", "explain.c", "pqu

Re: [BUGS] Measuring execution time

2010-08-10 Thread Robert Haas
On Tue, Aug 10, 2010 at 3:46 AM, vamsi krishna wrote: > I want to measure the execution time spent running an SQL select query after > the plan generation. > > So precisely I want to put my start timer before createQueryDesc() or > ExecutorStart() and end timer after freeQueryDesc() or ExecutorEnd

[BUGS] BUG #5610: Extremely slow bulk insert performance

2010-08-10 Thread William Wei
The following bug has been logged online: Bug reference: 5610 Logged by: William Wei Email address: william@tsx.com PostgreSQL version: AS8.4.4 Operating system: 64-bit Linux 2.6.18-164.6.1.el5 Description:Extremely slow bulk insert performance Details: We now e

Re: [BUGS] BUG #5610: Extremely slow bulk insert performance

2010-08-10 Thread Heikki Linnakangas
On 10/08/10 18:11, William Wei wrote: PostgreSQL version: AS8.4.4 This is an EnterpriseDB-specific issue, EnterpriseDB support people have been notified. sorry for the noise. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] BUG #5601: cannot create language plperl;

2010-08-10 Thread Alex Hunsaker
On Mon, Aug 9, 2010 at 01:30, Rene Novotny wrote: > Thank's a lot > > with  Activestate 64 bit perl 5.10 it works. > > It would be very desirable for plperl supporter to to add some plperl release > notes with Postgresql > production release for users to know , with what PERL distribution it work

[BUGS] BUG #5611: SQL Function STABLE promoting to VOLATILE

2010-08-10 Thread Brian Ceccarelli
The following bug has been logged online: Bug reference: 5611 Logged by: Brian Ceccarelli Email address: bceccare...@net32.com PostgreSQL version: 8.4.4 Operating system: Windows XP 32 bit and Red Hat 5.4 64 bit Description:SQL Function STABLE promoting to VOLATILE De

Re: [BUGS] BUG #5611: SQL Function STABLE promoting to VOLATILE

2010-08-10 Thread Tom Lane
"Brian Ceccarelli" writes: > --1. It seems that STABLE functions called within a SQL language > get promoted to VOLATILE. That has got nothing to do with it. The change in behavior from 8.2 is due to the fact that set-returning SQL functions can now be inlined. The statement in f_pass_