Gregory Stark wrote: > "Bruce Momjian" <[EMAIL PROTECTED]> writes: > > > Well, it is summarized here: > > > > http://momjian.us/expire/TOAST/SUMMARY.html > > > > It made non-TOAST access 2x faster, but TOAST 7x slower, and that seemed > > like a good compromise. > > Is this still testing with all data fitting in RAM?
Yes. Having things out of RAM is going to make access even slower, but it is going to allow the heap to be in RAM more often. -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
