> 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
> >> 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
>
> > 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
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