> [EMAIL PROTECTED] (Karthik Guruswamy) writes: > > Anyone tried fragmenting tables into multiple sub tables > > transparently through Postgres rewrite rules ? I'm having > > a table with 200,000 rows with varchar columns and noticed > > that updates,inserts take a lot longer time compared to a > > few rows in the same table. > > That's not a very big table ... there's no reason for inserts to > take a long time, and not much reason for updates to take long either > if you have appropriate indexes to help find the rows to be updated. > Have you VACUUM ANALYZEd this table recently (or ever?) Have you > tried EXPLAINing the queries to see if they use indexes? > > > I have a lot of memory in my > > machine like 2Gig and 600,000 buffers. > > You mean you set -B to 600000? That's not a bright idea. A few > thousand will be plenty, and will probably perform lots better.
This is a good question. When does too many buffers become a performance problem? -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
