Re: [PERFORM] Planner question - "bit" data types

2009-09-07 Thread Tom Lane
Robert Haas writes: > On Mon, Sep 7, 2009 at 10:05 PM, Karl Denninger wrote: >> The problem with re-coding for them is extensibility (by those who install >> and administer the package); a mask leaves open lots of extra bits for >> "site-specific" use, where hard-coding booleans does not, > You c

Re: [PERFORM] Planner question - "bit" data types

2009-09-07 Thread Robert Haas
On Mon, Sep 7, 2009 at 10:05 PM, Karl Denninger wrote: > The individual boolean fields don't kill me and in terms of some of the > application issues they're actually rather easy to code for. > > The problem with re-coding for them is extensibility (by those who install > and administer the package

Re: [PERFORM] Planner question - "bit" data types

2009-09-07 Thread Alvaro Herrera
Karl Denninger escribió: > The individual boolean fields don't kill me and in terms of some of the > application issues they're actually rather easy to code for. > > The problem with re-coding for them is extensibility (by those who > install and administer the package); a mask leaves open lots o

Re: [PERFORM] Planner question - "bit" data types

2009-09-07 Thread Karl Denninger
Robert Haas wrote: > On Mon, Sep 7, 2009 at 8:51 PM, Karl Denninger wrote: > >> Robert Haas wrote: >> >> On Sat, Sep 5, 2009 at 8:19 PM, Karl Denninger wrote: >> >> >> There was a previous thread and I referenced it. I don't have the other one >> in my email system any more to follow up to it. >

Re: [PERFORM] Planner question - "bit" data types

2009-09-07 Thread Brian Cox
"pgsql-performance-ow...@postgresql.org" wrote: On Sat, Sep 5, 2009 at 8:19 PM, Karl Denninger wrote: > There was a previous thread and I referenced it. I don't have the other one > in my email system any more to follow up to it. > > I give up; the attack-dog crowd has successfully driven m

Re: [PERFORM] Planner question - "bit" data types

2009-09-07 Thread Robert Haas
On Mon, Sep 7, 2009 at 8:51 PM, Karl Denninger wrote: > Robert Haas wrote: > > On Sat, Sep 5, 2009 at 8:19 PM, Karl Denninger wrote: > > > There was a previous thread and I referenced it. I don't have the other one > in my email system any more to follow up to it. > > I give up; the attack-dog crow

Re: [PERFORM] Planner question - "bit" data types

2009-09-07 Thread Karl Denninger
Robert Haas wrote: > On Sat, Sep 5, 2009 at 8:19 PM, Karl Denninger wrote: > >> There was a previous thread and I referenced it. I don't have the other one >> in my email system any more to follow up to it. >> >> I give up; the attack-dog crowd has successfully driven me off. Ciao. >> > >

Re: [PERFORM] Planner question - "bit" data types

2009-09-07 Thread Robert Haas
On Sat, Sep 5, 2009 at 8:19 PM, Karl Denninger wrote: > There was a previous thread and I referenced it. I don't have the other one > in my email system any more to follow up to it. > > I give up; the attack-dog crowd has successfully driven me off.  Ciao. Perhaps I'm biased by knowing some of the

Re: [PERFORM] Planner question - "bit" data types

2009-09-07 Thread Fernando Hevia
> -Mensaje original- > De: Karl Denninger > Enviado el: Sábado, 05 de Septiembre de 2009 21:19 > Para: Alvaro Herrera > CC: Tom Lane; Merlin Moncure; Josh Berkus; > pgsql-performance@postgresql.org > Asunto: Re: [PERFORM] Planner question - "bit" data types > > There was a previous thr

Re: [PERFORM] Using Gprof with Postgresql

2009-09-07 Thread Tom Lane
Reydan Cankur writes: > I compile PostgreSQL-8.4.0 with icc and --enable profiling option. I > ran command psql and create table and make a select then I quit psql > and go to .../data/gprof folder there are some folders named with > numbers (I think they are query ids); all of them are empt

Re: [PERFORM] Using Gprof with Postgresql

2009-09-07 Thread Jeff Janes
On Mon, Sep 7, 2009 at 8:11 AM, Reydan Cankur wrote: > Hi All, > > I compile PostgreSQL-8.4.0 with icc and --enable profiling option. I ran > command psql and create table and make a select then I quit psql and go to > .../data/gprof folder there are some folders named with numbers (I think > they

Re: [PERFORM] Using Gprof with Postgresql

2009-09-07 Thread Grzegorz Jaśkiewicz
postgresql was faster than the files ;) (sorry, I just couldn't resist). -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

[PERFORM] Using Gprof with Postgresql

2009-09-07 Thread Reydan Cankur
Hi All, I compile PostgreSQL-8.4.0 with icc and --enable profiling option. I ran command psql and create table and make a select then I quit psql and go to .../data/gprof folder there are some folders named with numbers (I think they are query ids); all of them are empty. How can I solve