Re: [PERFORM] Pipelined functions in Postgres

Amjad   On 9/19/06, Milen Kulev <[EMAIL PROTECTED]> wrote: Hello Lister,I am curios whether I can emulate the Oracle pipelined functions functionality in PG too (using RETURN NEXT ). For more information and examples about Oracle pipelined functi

Re: [PERFORM] Pipelined functions in Postgres

int); Hope this helps...Thanks,-- Shoaib MirEnterpriseDB (www.enterprisedb.com) On 9/20/06, Milen Kulev <[EMAIL PROTECTED]> wrote: Hello Lister,I am curios whether I can emulate the Oracle pipelined functions functionality in PG too (using RETURN NEXT ). For moreinform

[PERFORM] Pipelined functions in Postgres

Hello Lister, I am curios whether I can emulate the Oracle pipelined functions functionality in PG too (using RETURN NEXT ). For more information and examples about Oracle pipelined functions see: http://asktom.oracle.com/pls/ask/f?p=4950:8:8127757633768425921::NO::F4950_P8_DISPLAYID,F4950_P8_CRI

Re: [PERFORM] Partition elimination problem -> Solved

And sorry for the hassle. I was running the db cluster with Tthw wrong(old) postgresql.conf ;( Best Regrads. Milen -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 1:14 AM To: Milen Kulev Cc: pgsql-performance@postgresql.org

Re: [PERFORM] Partition elimination problem

constraint_exclusion ; constraint_exclusion-- on(1 row)   Best Regards. Milen -Original Message-From: Tom Lane [mailto:[EMAIL PROTECTED]]Sent: Monday, September 18, 2006 1:14 AMTo: Milen KulevCc: pgsql-performance@postgresql.orgSubject: Re: [PERFORM] Partition elimination

[PERFORM] Partition elimination problem

Title: Nachricht Hi listers,I wanted to try PG partitioning (aka constraint exclusion) with two levels .I am  using  PG 8.1.3 on  RHEL4U2,My setup:CREATE TABLE part (    id1    int not null,    id2    int not null,    id3    int not null,    filler varchar(200)    );--- level 1 partitions

Re: [PERFORM] XFS filessystem for Datawarehousing -2

gust 03, 2006 7:36 AMTo: Luke LonerganCc: Milen Kulev; pgsql-performance@postgresql.orgSubject: Re: [PERFORM] XFS filessystem for Datawarehousing -2I was kinda thinking that making the Block Size configurable at InitDB time would be a nice & simple enhancement for PG 8.3.  My own

Re: [PERFORM] XFS filessystem for Datawarehousing

Hi Luke, That is ~ 50% increase !! Amazing... How many reader processes did you have to get this results ? Regards. Milen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Luke Lonergan Sent: Thursday, August 03, 2006 6:05 AM To: Michael Stone; pgsql-perfo

Re: [PERFORM] XFS filessystem for Datawarehousing

our any FS over another .   Best Regards. MIlen Kulev   -Original Message-From: Steve Poe [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 02, 2006 11:27 PMTo: Milen KulevCc: pgsql-performance@postgresql.orgSubject: Re: [PERFORM] XFS filessystem for DatawarehousingMilen,

Re: [PERFORM] XFS filessystem for Datawarehousing

outpertform ETX3 (no default setups for both are planned !). I am not sure whether is it worth to include JFS in comparison too ... Best Regards, Milen Kulev -Original Message- From: Luke Lonergan [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 02, 2006 4:43 AM To: Milen Kulev; pgsql

Re: [PERFORM] XFS filessystem for Datawarehousing

it should be a a good idea to use as much contigious chunks of space (from OS point of view) as possible in order to make full table scans as fast as possible. Best Regards, Milen Kulev -Original Message- From: J. Andrew Rogers [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 02

FW: [PERFORM] XFS filessystem for Datawarehousing -2

Sorry, forgot to ask: What is the recommended/best PG block size for DWH database? 16k, 32k, 64k ? What hsould be the relation between XFS/RAID stripe size and PG block size ? Best Regards. Milen Kulev -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf

[PERFORM] XFS filessystem for Datawarehousing

) should I configure 5) Is it wortj settion noatime ? 6) What I/O scheduler(elevators) should I use (massive sequencial reads) 7) What is the ideal stripe unit and width (for a RAID device) ? I will appreciate any options, suggestions, pointers. Best Regards. Milen Kulev

Re: [PERFORM] RAID stripe size question

According to http://www.pcguide.com/ref/hdd/perf/raid/concepts/perfStripe-c.html, it seems to be the other way around? ("As stripe size is decreased, files are broken into smaller and smaller pieces. This increases the number of drives that an average file will use to hold all the blocks contain

Re: [PERFORM] Quick Performance Poll

Reading a PDF document on Bizgres site). Thanks ahain for the information. Regards. Milen -Original Message- From: Luke Lonergan [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 11:28 PM To: Milen Kulev Cc: pgsql-performance@postgresql.org; bizgres-general Subject: Re: [PERFORM

Re: [PERFORM] Quick Performance Poll

Hi Luke, I (still) haven't tried Bizgres, but what do you mean with "The current drawback to bitmap index is that it isn't very maintainable under insert/update, although it is safe for those operations"? Do you mean that INSERT/UPDATE operations against bitmap indexes are imperformant ? If ye