Re: [PERFORM] Bitmap indexes

2005-02-02 Thread Daniel Ceregatti
intarray methods for updating the attributes column. All of these methods are detailed in the intarray README. I'm happy with the performance in production so far. I've yet to see any gist concurrency issues affect performance with normal rates of DML. Daniel -- Daniel Ceregat

Re: [PERFORM] postgresql amd-64

2004-11-05 Thread Daniel Ceregatti
t; >Merlin > >---(end of broadcast)--- >TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html > > -- Daniel Ceregatti - Programmer Omnis Network, LLC The forest is safe because a lion lives ther

Re: [PERFORM] Article about PostgreSQL and RAID in Brazil

2004-09-16 Thread Daniel Ceregatti
Josh Berkus wrote: Primer, The site seems to be down. I was looking forward to reading it. :( I didn't have a problem. The site *is* in Portuguese, though. Yes, it came up finally. Fortunately I'm Brazilian. :) -- Daniel Ceregatti - Programmer Omn

Re: [PERFORM] Article about PostgreSQL and RAID in Brazil

2004-09-16 Thread Daniel Ceregatti
/bonnie.txt -- Daniel Ceregatti - Programmer Omnis Network, LLC A little suffering is good for the soul. -- Kirk, "The Corbomite Maneuver", stardate 1514.0 ---(end of broadcast)--- TIP 6: Have you searched our list archives?

Re: [PERFORM] Comparing user attributes with bitwise operators

2004-09-16 Thread Daniel Ceregatti
h my original plan, which is to maintain a 1:1 table of people:attributes where each attribute is in its own column. Still, no index is used, but it's been the best performer up to now. I'm still looking for a better plan though. Daniel -- Daniel Ceregatti - Programmer Omnis Network, L

[PERFORM] What is the best way to do attribute/values?

2004-08-24 Thread Daniel Ceregatti
goal is performance. This _must_ be fast. And by fast, I mean, < 1 second, for every permutation of the number of attributes searched for. Flexibility would be a bonus, but at this point I'll settle for something that's harder to maintain if I can get the speed g