Fragmenting tables in postgres

From: karthikg(at)yahoo(dot)com (Karthik Guruswamy)
To: pgsql-hackers(at)postgresql(dot)org
Subject: Fragmenting tables in postgres
Date: 2001-09-27 00:56:14
Message-ID: 5cfe8c88.0109261656.1a432724@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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
machine like 2Gig and 600,000 buffers.

I really appreciate any pointers.

Karthik Guruswamy

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Vince Vielhaber 2001-09-27 01:27:49 Re: casting for dates
Previous Message Tom Lane 2001-09-27 00:46:51 Re: Spinlock performance improvement proposal