Re: [PERFORM] insert performance for win32

On Wed, 2 Nov 2005, Merlin Moncure wrote: > > > > By the way, we've tried to insert into the windows database from a > > linux psql client, via the network. In this configuration, inserting > > is only about 2 times slower than inserting locally (the linux client > > had a slower CPU 1700Mhz aga

Re: [PERFORM] Sorted union

On 2 Nov 2005, at 21:13, Scott Lamb wrote: I want to retrieve all the events during a timespan in one list; typical timespans will involve up to a couple rows. Err, I meant up to a couple million rows. With two rows, I wouldn't be so concerned about performance. ;) -- Scott Lamb

[PERFORM] Sorted union

Using PostgreSQL 8.0.4. I've got a table with 4.5 million rows that I expect to become huge (hundred million? who knows). Each row has a start and end time. I want to retrieve all the events during a timespan in one list; typical timespans will involve up to a couple rows. If the start and

Re: [PERFORM] Trigger Rowsets

On Thu, Nov 03, 2005 at 12:34:14PM +1300, Ralph Mason wrote: > I want to do statement level triggers for performance, but it seems > there is no 'updated', 'inserted', or 'deleted' tables inside the > trigger and nothing I can find in the documentation that offers similar > functionality. > > I

[PERFORM] Trigger Rowsets

I want to do statement level triggers for performance, but it seems there is no 'updated', 'inserted', or 'deleted' tables inside the trigger and nothing I can find in the documentation that offers similar functionality. Is there any way that I can access only those rows that were changed? Th

Re: [PERFORM] 8.x index insert performance

"Merlin Moncure" <[EMAIL PROTECTED]> writes: > > select * from sometable where somefield IS NULL won't work because IS > is > > not a nomally indexible operator. > > Ah, I didn't know that. So there is no real reason not to exclude null > values from all your indexes :). Reading Tom's recent co

Re: [PERFORM] improvise callbacks in plpgsql

oops. my blog is here: :-) http://people.planetpostgresql.org/merlin/ > http://www.postgresql.org/docs/8.0/interactive/plpgsql.html#PLPGSQL-ADVA > NTAGES ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.

Re: [PERFORM] improvise callbacks in plpgsql

> Would you be willing to write up an example of this? We often get asked > about support for WITH, so I bet there's other people who would be very > interested in what you've got. > You can see my blog on the subject here: http://www.postgresql.org/docs/8.0/interactive/plpgsql.html#PLPGSQL-ADVA N

[PERFORM] Performance difference between sql and pgsql function...

There any performance differences between a SQL function written in SQL language or PL/psSQL language? For example: Create or replace function sp_getfreq( Var1 integer ) returns Boolean as $$ Declare Myval Boolean; Begin Select var1 in (select var3 from table1) into myval;

Re: [PERFORM] insert performance for win32

"Magnus Hagander" <[EMAIL PROTECTED]> writes: >> Marc's observation that by switching to a linux client drops >> time down drastically is really intersing! > Could this be a case of the network being slow, I'm wondering about nonstandard junk lurking in the TCP stack of the Windows client machin

Re: [PERFORM] insert performance for win32

Le Mercredi 02 Novembre 2005 14:54, Magnus Hagander a écrit : > > > I've done the tests with rc1. This is still as slow on windows ... > > > > about > > > > > 6-10 > > > times slower thant linux (via Ip socket). (depending on > > > > using prepared > > > > > queries, etc...) > > > > > > By the way,

Re: [PERFORM] pgbench results interpretation?

On Wed, 2005-11-02 at 21:16 +1100, Gavin Sherry wrote: > connections are updating the branches table heavily. As an aside, did you > initialise with a scaling factor of 10 to match your level of concurrency? Yep, I did. > that. The hackers list archive also contains links to the testing Mark > Wo

Re: [PERFORM] 8.1beta3 performance

"PostgreSQL" <[EMAIL PROTECTED]> writes: > I'm seeing some other little oddities in the beta as well. I'm watching an > ALTER TABLE ADD COLUMN right now that has been running almost two hours. I > stopped it the first time at 1 hour; I suppose I'll let it go this time and > see if it ever comp

Re: [PERFORM] insert performance for win32

> > I've done the tests with rc1. This is still as slow on windows ... > about > > 6-10 > > times slower thant linux (via Ip socket). (depending on > using prepared > > queries, etc...) > > > > By the way, we've tried to insert into the windows database from a > linux > > psql > > client, via th

Re: [PERFORM] improvise callbacks in plpgsql

> Would you be willing to write up an example of this? We often get asked > about support for WITH, so I bet there's other people who would be very > interested in what you've got. Sure. In fact, I had already decided this to be the next topic on my blog. I'm assuming you are asking about tools t

Re: [PERFORM] insert performance for win32

> I've done the tests with rc1. This is still as slow on windows ... about > 6-10 > times slower thant linux (via Ip socket). (depending on using prepared > queries, etc...) > > By the way, we've tried to insert into the windows database from a linux > psql > client, via the network. In this confi

Re: [PERFORM] pgbench results interpretation?

On Tue, 1 Nov 2005, Joost Kraaijeveld wrote: > Hi Gavin, > > Thanks for answering. > > On Tue, 2005-11-01 at 20:16 +1100, Gavin Sherry wrote: > > On Tue, 1 Nov 2005, Joost Kraaijeveld wrote: > > > 1. Is there a repository somewhere that shows results, using and > > > documenting different kinds of

Re: [PERFORM] 8.1beta3 performance

I'm seeing some other little oddities in the beta as well. I'm watching an ALTER TABLE ADD COLUMN right now that has been running almost two hours. I stopped it the first time at 1 hour; I suppose I'll let it go this time and see if it ever completes. The table is about 150K rows. Top, vmsta