> karthikg(at)yahoo(dot)com (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
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
In response to
pgsql-hackers by date
|Next:||From: Bruce Momjian||Date: 2001-09-28 19:37:41|
|Subject: Re: pg_locale (Was: Re: Problem with setlocale (found in libecpg)...)|
|Previous:||From: Bruce Momjian||Date: 2001-09-28 19:21:24|
|Subject: Re: Spinlock performance improvement proposal|