Fragmenting tables in postgres - Mailing list pgsql-hackers

From karthikg@yahoo.com (Karthik Guruswamy)
Subject Fragmenting tables in postgres
Date
Msg-id 5cfe8c88.0109261656.1a432724@posting.google.com
Whole thread Raw
Responses Re: Fragmenting tables in postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-hackers by date:

Previous
From: Dave Page
Date:
Subject: Re: [pgadmin-hackers] Alter project: client or server side?
Next
From: Tom Lane
Date:
Subject: Moving CVS files around?