Re: [HACKERS] Fragmenting tables in postgres

2001-09-28 Thread Bruce Momjian
> [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

Re: [HACKERS] Fragmenting tables in postgres

2001-09-27 Thread Tom Lane
[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 ro

[HACKERS] Fragmenting tables in postgres

2001-09-27 Thread Karthik Guruswamy
Hi, 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. I have a lot of memory in my