Re: [PERFORM] partitioning for postgresql

2003-08-09 Thread Christopher Browne
> what is suggested partitioning schema for postgresql?? > the size of my db is 5BG and i have 36GB scsi disk! The interesting forms of partitioning kind of assume that you have multiple disk drives. If you only have one drive, then there is not terribly much reason to prefer anything much over

Re: [PERFORM] Moving postgresql.conf tunables into 2003...

2003-08-09 Thread Sean Chittenden
> >> I have an experimental patch lying around somewhere that tries to > >> work around these problems by offering different estimation methods > >> for index scans. If you are interested, I'll dig it out. > > > >Sure, I'll take a gander... had my head in enough Knuth recently to > >even hopefully

Re: [PERFORM] Odd performance results - more info

2003-08-09 Thread Medora Schauer
> > > Medora Schauer wrote: > > > I would greatly appreciate it if someone could run this > > code in their > > > environment and let me know if you get results similiar to mine. > > > The INT test results in execution times of 11 - 50+ secs > increasing > > > each time the test is run. The FL

Re: [PERFORM] How Many Inserts Per Transactions

2003-08-09 Thread Christopher Browne
Trevor Astrope wrote: > I was wondering if anyone found a sweet spot regarding how many > inserts to do in a single transaction to get the best performance? > Is there an approximate number where there isn't any more > performance to be had or performance may drop off? > > It's just a general que